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 ...
Click here to go back