Excel 2003 - Advanced Training Print E-mail

All our training courses can be designed to suit your company's needs. Take a look at all the different features that separate us from other Excel 2003 Advanced training courses.

Prerequisites

Intermediate Excel

Course Contents

PivotTable & PivotChart Reports
Reporting on Lists using PiovotTables and PivotCharts
Creating a PivotTable
The PivotTable toolbar
Creating a PivotChart
Editing a PivotChart
Formatting PivotTable Reports

Functions

Worksheet Functions
Logical Functions
Nesting
Lookup Functions
Efficiency Tools
Manipulating data using outlining
Saving formatting using styles
Names, Views, Scenarios & Reports
Documenting worksheets using names
Saving changing sets of data as Scenarios
Saving data displays as views
Printing your scenarios and views

Macros

Recording macros
The Visual Basic Editor
"What If" Analysis
Data analysis using Goal Seek & Solver
Data Tables
MS Query and Importing Text
Extracting data from a list or database using MS Query
The Query window
Importing data from a text file

Text Files

Importing and Exporting data
File format converters supplied with Excel
Excel formats
Text file formats
Other spreadsheet programs and databases
Clipboard formats

Workgroup Tools

Workgroups Tools
Resolving conflicting changes
Merging Changes from a shared workbook
Limitations in shared workbooks

Contact us for Last minute offers on this Course!
Excel 2003 - Advanced Training
 
Name:*
Contact Number:*
E-mail Address:
Type Your Message:
Type the digits you see in the picture below.




* This course can be tailored to meet your
exact requirement!

* One-to-One Excel 2003 - Advanced Training courses available!

* Group Excel 2003 - Advanced Training courses available at discount prices!


[Back to list]
Latest Information
Computer Generated Solutions (New York)
It gives me great pleasure to write a letter of recommendation f...
Read more...
Our Work with the London Metropolitan University
Bobby, we were very pleased with the success of our recent away ...
Read more...
What Credit Crunch
As soon as the Credit Crunch took hold Keystar training saw the ...
Read more...
What A surprise
February 2011 A recent delegate was more than surprised when at...
Read more...
What a difference
September 2011 After taking the Minutes at my company's meetings...
Read more...
Time Management Training
Once again Keystar has been contacted by the press, on this occa...
Read more...