ECDL Advanced Syllabus 2.0 Module AM4 Spreadsheets Using Excel 2010

Description

As well as comprehensively covering the ECDL/ICDL Advanced AM4 syllabus, this manual is useful for those wishing to increase their spreadsheet knowledge. Designed to gradually build up your knowledge the syllabus includes Functions, Scenarios and Pivot Tables. The data files allow you to practise the different software features. Data is available for download. Approved by the ECDL Foundation.

CONTENTS:

Conditional Formatting

AutoFormat

Paste Special

Worksheet and Workbook Protection

Cell Comments

Using Names

Creating and Using Templates

Display Formulas

Mixed Referencing

Custom Number Formats

Creating and Using Outlines

Using Scenarios

Linking Cell, Sheets and Books

Importing Delimited Data

Sorting

Filtering Lists

PivotTables

Using Functions

Formating and Modifying Charts

Data Tables

Creating and Running Macros

Auditing

Data Validation

Sharing Workbooks

Tracking Changes