Upgrade Your Head
Upgrade Your Head

Advanced
Spreadsheeting



Overview
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.

Contents

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

Instructions

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.

I hope you find the course educational and fun!
Feedback can be sent to Mike Capstick at
capsticm@gmail.com
All Content and Interface Design are copyright Mike Capstick 2006