CLAIT Advanced 2006 Unit 2 Analysing Spreadsheets and Graphs using Excel 2010

Description

This manual uses complex spreadsheets to produce evidence for the CLAIT Advanced 2006 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 available to download allowing you to practise the software features. Endorsed by OCR.

CONTENTS:

Formatting

Auditing and Validation

Cell Referencing

Comments

Printing

Linking

Shared Workbooks

Multi-level Spreadsheets

Editing

Functions

Filtering

Lists

Names

Pivot Tables

Macros

Charts

Spreadsheet Principles