Microsoft Excel 2003 Advanced
Training Course Outline

1-day course

This course includes the following topics:

Working with advanced formulas
Using names
Using decision-making functions
Creating nested functions
Using financial functions
Lookups and data tables
Working with lookup functions
Using MATCH and INDEX
Creating data tables
Advanced list management
Creating subtotals
Validating cell entries
Exploring database functions
Working with data forms
Working with PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with PivotCharts
Exporting and importing
Exporting and importing text files
Exporting and importing XML data
Querying external databases
Using analytical options
Working with Goal Seek and Solver
Working with the Analysis ToolPak
Working with scenarios
Working with views
Working with macros
Running and recording a macro
Working with VBA code
Function procedures
Interactive Web pages
Creating interactive Web spreadsheets
Publishing PivotTables on the Web
Using SharePoint services
Document Workspaces

For further details, or to book a course, please contact us:
email: training@ictwizard.com
telephone: 01382 453447

Our courses are delivered by top-class trainers and consultants that are leaders in their field and meet our highest standards of experience, qualifications and ability.