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