ECDLAdvanced Spreadsheets for Office XP & 2003

ECDL Advanced Spreadsheets is aimed at someone who needs to make more sophisticated and advanced use of spreadsheets, for examples managers and lecturers, and who wants to study for the ECDL Advanced certificate. This fully updated version of our market-leading ECDL Advanced Coursebook will meet this demand for courseware covering Office XP and 2003. The examples and exercises will all be based around a fictional case study, so that all the functionality is learned in a practical context (why? and well as how?). As with ECDL: The Complete Coursebooks , these books promise to teach everything you need to know to pass the relevant Advanced exam - nothing more and nothing less.

Introduction
Using templates in Excel
Importing data into a spreadsheet
Sorting data in a spreadsheet
Naming cells and adding comments
Using Paste Special
Summarizing data using PivotTables
Linking to data in spreadsheets
Formatting your spreadsheets
Using Excel macros
Using reference and mathematical functions
Customising charts
Using statistical and database functions
Using financial functions
Using text and date functions
Using logical functions
Using data tables and scenarios
Auditing your spreadsheets
Sharing and protecting your spreadsheets
In conclusion
Appendix: Advanced spreadsheets test
In this section
The test
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

ECDLAdvanced Spreadsheets for Office XP & 2003

Summary

Table of Contents

Supplemental Materials