Uses spreadsheets to produce evidence for the CLAIT Advanced Unit 2 assessments. This manual covers various aspects of Excel. It enables the student to: create multi-level spreadsheets for a common purpose, use a range of complex formulas and functions, create a macro and analyse spreadsheet data, format and maintain spreadsheets, and more.

This manual uses complex spreadsheets to produce evidence for the CLAIT Advanced Unit 2 assessments. All aspects of Excel are covered as evidence is collected. The student will be able to: create multi-level spreadsheets for a common purpose, use a range of complex formulas and functions, create a macro and analyse spreadsheet data, format and maintain spreadsheets, print spreadsheets and formulas. Data files are avialable to download allowing you to practise the software features. Endorsed by OCR.

Section 1 - Creating Spreadsheets, Section 2 - Formatting Worksheets, Section 3 - Formatting Cells, Section 4 - Formulas, Section 5 - Producing Professional Documents, Section 6 - Functions, Section 7 - Linking, Section 8 - Filtering, Section 9 - Charts, Section 10 - Names, Section 11 - Cell Comments, Section 12 - Pivot Tables, Section 13 - Auditing, Section 14 - Sharing Workbooks, Section 15 - Macros