Microsoft Excel Advanced V2007
Sponsored links
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
- Macros.
Recording a macro
The Macro Language
Running a Macro
Relative Addresses
- Range Names.
- Using Input Boxes.
- Using 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.
