ECDL Advanced Syllabus 2.0 Module AM4 Spreadsheets using Excel 2007

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 practice the different software features. Data is available for download. Approved by the ECDL Foundation.


Contents:

Conditional Formating 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