MicroKnowledge Excel XP/2003 Advanced

Excel 2003 Advanced

Use advanced formulas, data lookups, and advanced list management techniques. Create PivotTables, use analysis tools. Export and import data. Automate tasks with macros and VBA.

Recommended Preparation: Excel 2003 Intermediate, or equivalent knowledge.

Lesson 1: Working with advanced formulas

Using names
Using decision-making functions
Creating nested functions
Using financial functions

Lesson 2: Lookups and data tables

Working with lookup functions
Using MATCH and INDEX
Creating data tables

Lesson 3: Advanced list management

Creating subtotals
Validating cell entries
Exploring database functions
Working with data forms

Lesson 4: Working with PivotTables and PivotCharts

Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with PivotCharts

Lesson 5: Exporting and importing

Exporting and importing text files
Exporting and importing XML data
Querying external databases

Lesson 6: Using analytical options

Working with Goal Seek and Solver
Working with the Analysis ToolPak
Working with scenarios
Working with views

Lesson 7: Working with macros

Running and recording a macro
Working with VBA code
Function procedures

Optional Topic: Interactive Web pages

Creating interactive Web spreadsheets
Publishing PivotTables on the Web