| |
Data Consolidation
|
 |
Topic A: By Physical Layout or Category |
 |
Topic B: Consolidation using a Pivot Table
|
| |
Using Financial Functions
|
 |
Topic A: PMT Function |
 |
Topic B: FV Function
|
| |
Working with Text Strings
|
 |
Topic A: Concatenating Labels |
 |
Topic B: Text Functions
|
| |
Reports, Views and Scenarios
|
 |
Topic A: Report Manager |
 |
Topic B: View Manager |
 |
Topic C: Scenario Manager |
 |
Topic D: Using the Report Manager with Views and Scenarios
|
|
| |
Histograms, Moving Averages & Trends
|
 |
Topic A: Histograms |
 |
Topic B: Moving Averages |
 |
Topic C: Trends
|
| |
Using Macros
|
 |
Topic A: Command Macros |
 |
Topic B: Recording Command Macros |
 |
Topic C: Assigning |
 |
Topic D: Introduction to Macro Sheets |
 |
Topic E: Function Macros
|
| |
Using Pivot Tables
|
| |
Goal Seeking
|
| |
Using the Solver
|
|