ECDLAdvanced Spreadsheets for Office XP & 2003

by Murphy, Sharon; Holden, Paul

• ISBN13: 9780131866546
• ISBN10: 0131866540
• Edition: CD
• Format: Paperback
• Copyright: 2006-11-30
• Publisher: Prentice Hall

Summary

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.

Table of Contents

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.