|
Advanced ECDL 1.5: Module AM4 Spreadsheets: Excel XP Spiral Bound
As well as comprehensively covering the ECDL 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 advanced Functions, Scenarios and Pivot Tables. Data files, which allow you to practise the different features, are available on the
web. Approved by the ECDL Foundation.
CONTENTS:
Freezing Panes
Conditional Formatting
Paste Special
Worksheet and Workbook Protection
Cell Comments
Names
Creating and Using Templates
Display Formulas
Formulas that Produce Errors
Custom Number Formats
Using Scenarios
Linking Cells, Sheets and Books
Sorting Data
Filtering Lists
Pivot Tables
Advanced Functions
Formatting and Modifying Charts
Data Tables
Using Macros
Auditing
Importing Data
|
