MS Excel 2003 - Advanced

Here is what you will learn:

Working with advanced formulas (using names, decision-functions, nested functions, etc...)
Lookups and data tables (using MATCH and INDEX, creating Data Tables)
Advanced list management (creating subtotals, data validation, data forms)
How to work with PivotTables and PivotCharts
How to Export and Import in different formats (text files, XML, etc...)
How to use analytical options (Goal Seek/Solve, ToolPak, scenarios)
How to work with macros (create and run macros, work with VBA code)
and more ...