Table of contents
Course Objectives
This one day course covers Calc'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 Calc's macro commands.
Who Should Attend?
Those who have used Calc yet require a more in-depth knowledge of more advanced features and macros. Previous experience of using Calc to an intermediate level will be assumed. Delegates who do not have this level of knowledge of Calc should first attend our "Star Office Calc Intermediate" course.
Course Contents
Calc Database Features.
- Advanced Filter
- Database Functions
- DataPilot Tables
Using the Multiple Operations command.
Using Outlines.
Using Consolidation Commands.
Advanced Analysis Techniques.
- Scenario Manager
- Goal Seek
Advanced Reporting Techniques.
- Custom Views
Macros.
- Recording a macro
- The Macro Language
- Running a Macro
- Relative Addresses
