ECDL Advanced Spreadsheets for Microsoft Office XP & Office 2003

Description

This fully updated version of our market-leading ECDL Advanced Coursebook covers courseware for Office XP and 2003. The examples and exercises are all based around a fictional case study, so you can learn all the functionality you need in a practical context, reinforcing the "why" as well as the "how". Written by experienced trainers Paul Holden and Brendan Munnelly. Clear, simple, friendly guidance on the Advanced module. Basic computer terms and concepts explained in plain English. Screen images and illustrations guide the student through the Microsoft Excel application. "How-to" information based on practical examples of everyday tasks. Short cuts and insider tips drawn from the real-world experience of computer professionals. Summary of critical information at the end of each section. Easy-to-follow exercises in the book and on the CD-ROM to help you test your progress. Examples and exercises based around a fictional case study - teaches all functionality in a practical context.

CONTENTS:

Chapter 1: Introduction
Chapter 2: Using templates in Excel
Chapter 3: Importing data into a spreadsheet
Chapter 4: Sorting data in a spreadsheet
Chapter 5: Naming cells and adding comments
Chapter 6: Using Paste Special
Chapter 7: Summarizing data using PivotTables
Chapter 8: Linking to data in spreadsheets
Chapter 9: Formatting your spreadsheets
Chapter 10: Using Excel macros
Chapter 11: Using reference and mathematical functions
Chapter 12: Customising charts
Chapter 13: Using statistical and database functions
Chapter 14: Using financial functions
Chapter 15: Using text and date functions
Chapter 16: Using logical functions
Chapter 17: Using data tables and scenarios
Chapter 18: Auditing your spreadsheets
Chapter 19: Sharing and protecting your spreadsheets
In conclusion
Appendix: Advanced spreadsheets test
In this section
The test