MicroKnowledge Excel 2000 Advanced

Excel XP 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 2000 Intermediate or equivalent knowledge.

Lesson 1: Advanced Formulas

Using names
Decision making
Nesting
Financial functions

Lesson 2: Lookups and Data Tables

Lookup functions
MATCH and INDEX
Data tables

Lesson 3: Advanced List Management

Sub-totals
Data validation
Database functions
Data forms

Lesson 4: Pivot Tables

Creating a pivot table
Rearranging a pivot t able
Formatting a pivot table
PivotCharts

Lesson 5: Exporting and Importing

Exporting data
Importing data
Querying external databases

Lesson 6: Analytical Options

Goal Seek and Solver
Scenarios
Views
Reports

Lesson 7: Macros

Recording and running a macro
Editing VBA code
Function procedures

Optional Topics: Advanced Web Topics

Creating interactive web spreadsheets
PivotTables on the Web