MicroKnowledge Excel 2007 Advanced

Excel 2007 Advanced

Use advanced formulas, create lookups and data tables, use advanced list management techniques, analyze data with PivotTables and PivotCharts, export and import data, automate tasks with macros and custom functions.

Recommended Preparation: Excel 2007 Intermediate or equivalent knowledge

Lesson 1: Advanced formulas

Using decision-making functions
Creating nested functions
Using financial functions

Lesson 2: Lookups and data tables

Using lookup functions
Using MATCH and INDEX
Creating data tables

Lesson 3: Advanced list management

Validating cell entries
Exploring database functions

Lesson 4: PivotTables and PivotCharts

Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts

Lesson 5: Exporting and importing

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

Lesson 6: Analytical options

Goal Seek and Solver
The Analysis ToolPak
Scenarios
Views

Lesson 7: Macros and custom functions

Running and recording a macro
Working with VBA code
Function procedures