Further Details
COURSE CONTENTS
- Excel Database Features.
Advanced Filter
Database Functions
Pivot Tables
- Sharing Workbooks.
- Using Outlines.
- Using Consolidation Commands.
- Advanced Analysis Techniques.
Scenario Manager
Goal Seek
Solver
- Advanced Reporting Techniques.
Custom Views
Report Manager
- Macros.
Recording a macro
The Macro Language
Running a Macro
Relative Addresses
- Range Names.
- Using Input Boxes.
- Using Message Boxes.
- Using the If Then Control Structure.
- Using Loops.
Using Do While and Do Until loops
- More Complex Message Boxes.
- Using Dialog Boxes.
userforms
textboxes, labels and command buttons
comboboxes
optionbuttons
Guide price
£150 per day |
