To provide students with the theoretical and practical knowledge to implement advanced features of a spreadsheet using Microsoft Office Excel.

Contents:
The IF statement,  use of nested functions, more advanced functions: Round; Floor; Ceiling; Roundup; Round down, using a Lookup table, error handling, auditing features, multiple file linking, outlining and consolidation, goal seeker and Solver, Review of charting.


Entry Requirements:
A good pass in Excel Stage 2

Dates: 18/5/10 - 11/6/10

Fee:
$20