ECDL Advanced Spreadsheets for Office XP/2003 - Paul Holden

ECDL Advanced Spreadsheets for Office XP/2003

Brendan Munnelly (Herausgeber)

Paul Holden (Autor)

Media-Kombination
248 Seiten
2006
Prentice Hall
978-0-13-186654-6 (ISBN)
35,50 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
ECDL Advanced Spreadsheets is designed for anyone making more sophisticated, advanced use of spreadsheets e.g. managers and lecturers and wanting to study for the ECDL Advanced certificate.
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.

Brendan Munnelly and Paul Holden are experienced IT trainers, consultants, journalists and authors. Based in Dublin, Ireland, they developed user training materials for a range of corporate and government organisations throughout Europe. They also offer frequent contributions to computer publications.

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

Erscheint lt. Verlag 8.12.2006
Reihe/Serie ECDL Advanced
Zusatzinfo Illustrations
Verlagsort Upper Saddle River
Sprache englisch
Maße 244 x 192 mm
Gewicht 510 g
Themenwelt Informatik Office Programme Excel
Informatik Weitere Themen Zertifizierung
ISBN-10 0-13-186654-0 / 0131866540
ISBN-13 978-0-13-186654-6 / 9780131866546
Zustand Neuware
Haben Sie eine Frage zum Produkt?