Title:
ECDL advanced spreadsheets for Office XP & 2003
Personal Author:
Publication Information:
Harlow, Essex : Pearson Education Limited, 2006
Physical Description:
1 CD-ROM ; 12 cm
ISBN:
9780131866546
General Note:
Accompanies text of the same title : HF5548.4.M525 H64 2006
Added Author:
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010148573 | CP 10164 | Computer File Accompanies Open Access Book | Compact Disc Accompanies Open Access Book | Searching... |
On Order
Summary
Summary
This coursebook covers all aspects of the ECDL advanced spreadsheets module using the most popular business software - the Excel package of Microsoft Office XP and Office 2003.
Table of 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 |
