| |
DATA COSOLIDATION
|
 |
By Physical Layout |
 |
By Category
|
| |
USING FINANCIAL FUNCTIONS
|
 |
PMT Function |
 |
FV Function |
 |
Financial Analysis Table
|
| |
WORKING WITH TEXT STRINGS
|
 |
Concatenating Labels |
 |
Text Functions |
 |
Proper, Lower, Upper Functions
|
| |
USING PIVOT TABLES
|
| |
BACKSOLVING
|
 |
Using Goal Seek |
 |
Using Solver
|
|
| |
SCENARIOS
|
 |
Reporting with the Scenario Manager |
 |
Using the Scenario Manager
|
| |
VIEW & REPORT MANAGERS
|
 |
Using View Manager (Custom Views) |
 |
Using the Report Manager with a Scenario
|
| |
INTRODUCTION TO VISUAL BASIC
|
 |
Recording Macros |
 |
User defined Functions |
 |
The Visual Basic editor |
 |
Assigning macros to buttons
|
|