Excel XP Advanced
The Excel XP Advanced tutorial takes you step by step through the advanced tasks of Excel XP.
Named Ranges and Lookup Working with Named Ranges
Vlookup and Hlookup Functions
Data Management Importing and Exporting Files
Custom and Conditional Formats
Validating Data
XML and Web Queries
Group Editing Sharing and Protecting Files
Using Comments
Tracking Changes
Auditing, Scenarios and Reporting Auditing Tools
Using the Scenario Manager
Using Custom Views
Working with Report Manager
Database and Analysis Tools Working with Databases
Filtering Data
Sorting and Subtotalling
Goal Seeker and Solver
PivotTables Working with PivotTables
Using PivotCharts
PivotTables on the Web