Table of contents
Course Objectives
This course will cover some more advanced commands of this powerful application. The topics include an overview of the spreadsheet commands, the more involved graphics and database capabilities, the advanced functions and a look at Calc's macro commands.
Who Should Attend?
Those who have used Calc but have not yet tapped its full potential. Previous experience of using Calc at an introductory level will be assumed. Delegates with no previous experience of Calc should first attend our "Introduction to Star Office Calc" Course.
Course Contents
A review of Calc basics.
- Spreadsheet
- Charts
- Database
Spreadsheet commands.
- Absolute and Relative cell addresses
Calc's functions.
- IF function
- The LOOKUP function
- Discussions on other functions available
Workbooks and file linking.
More involved charting techniques.
Data Menu commands.
- Sorting Information
- Filtering information
- Data Validity
- Sub-totals
- DataPilot
Writing, running and editing Macros.
