ECDL Advanced Spreadsheet Software (BCS ITQ L3), Excel 2010

Beschreibung

Approved by BCS and ICS Skills. This training guide has been written specifically for the ECDL unit Advanced Spreadsheet Software (BCS ITQ level 3, syllabus 2.0). Each exercise has been designed to build upon and extend your knowledge of Microsoft Excel using a simple, step-by-step approach. You will learn how to use a range of advanced spreadsheet software tools and techniques to produce complex spreadsheets. Data files to accompany this title allow you to practise the many different software features covered.

Contents

This product contains approximately 180 pages and covers the following topics:

1. Conditional Formatting
2. AutoFormat
3. Paste Special
4. Worksheet and Workbook Protection
5. Cell Comments
6. Using Names
7. Creating and Using Templates
8. Display Formulas
9. Mixed Referencing
10. Custom Number Formats
11. Creating and Using Outlines
12. Using Scenarios
13. Linking Cell, Sheets and Books
14. Importing Delimited Data
15. Sorting
16. Filtering Lists
17. PivotTables
18. Using Functions
19. Formating and Modifying Charts
20. Data Tables
21. Creating and Running Macros
22. Auditing
23. Data Validation
24. Sharing Workbooks
25. Tracking Changes