Microsoft Excel Advanced V 2003
COURSE OBJECTIVES
This one day course covers Excel's advanced features. The course will look at the more advanced functions and analysis techniques, and particular emphasis will be given during the course to Excel's macro commands.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
COURSE CONTENTS
- Excel Database Features.
Advanced Filter
Database Functions
Pivot Tables
- Data 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.
- More Complex Message Boxes.
This Training Course is taught in classrooms in the following locations:
Bristol
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
