This is a self paced course covering Advanced Spreadsheeting
It addresses the National IT Training Package Competency
ICAITU018B Develop macros and templates for clients using standard products.
1 Advanced Functions
This section covers more advanced spreadsheeting topics and powerful inbuilt functions.
2 Spreadsheets by Design
In this section we will examine the importance of well designed Spreadsheets.
3 Spreadsheets as a Database
Spreadsheets can be quite effective in manipulating flat file databases.
4 Visual Basic for Applications
Unleash the power of programming on your spreadsheet with VBA
Each WebBook consists of Topics and Activities which you should work through.
You can select Topics and Activities from the list in the Control Panel at the foot of the screen.
The Activities include Exercises, a Multiple Choice Quiz and a Final Assessment.