ECDL Advanced Spreadsheets (Murphy)
This comprehensive coursebook covers all aspects of the ECDL advanced spreadsheets module using the most popular business software - the Excel package of Microsoft Office 2000. It provides everything a student needs to pass the ECDL Advanced Spreadsheet certification test. As with "ECDL: The Complete" "Coursebooks", these books promise to teach you everything you need to know to pass the relevant Advanced exam - nothing more and nothing less.
- Paperback | 192 pages
- 191 x 246 x 10mm | 402g
- 15 Mar 2002
- Pearson Education (US)
- Prentice Hall
- Upper Saddle River, United States
Paul Holden is Managing Director of Redacteurs Limited, a company that specialises in information design and documentation. He is a Chartered Engineer and a Fellow of the Irish Computer Society. He is Chairman of ECDL Ireland, and a former member of the Irish Council for Science, Technology and Innovation. Sharon Murphy is a technical writer with many years' experience in the development of software-related training materials and documentation.
Table of contents
Contents Chapter 1: The 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 Chapter7: Summarizing data using PivotTables Chapter 8: Linking data in spreadsheets Chapter 9: Formatting your spreadsheets Chapter 10: Using Excel macros Chapter 11: Using reference and mathematical functions Chapter 12: Customizing charts Chapter13: Using statistical and database functions Chapter 14: Using financial functions Chapter 15: Using text and date functions Chapter16: Using logical functions Chapter 17: Using data tables and scenarios Chapter 18: Auditing your spreadsheets Chapter 19: Sharing and protecting your spreadsheets In Conclusion Index