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

Sprache: Englisch
Office-Version: MS Office 2010
Produktform: Buch
Hersteller CiA Training
  CHF 26.00


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.


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