Step by Step Spreadsheets - Alan Dillon

Step by Step Spreadsheets

(Autor)

Buch | Softcover
384 Seiten
2014 | 3rd Revised edition
Gill & Macmillan Ltd (Verlag)
978-0-7171-6044-0 (ISBN)
49,95 inkl. MwSt
  • Titel nicht im Sortiment
  • Artikel merken
Third edition of this popular, easy-to-use textbook, updated for the revised Spreadsheet Methods Level 5 module [5N1977], which details fundamental spreadsheet methods and facilitates practical experience in spreadsheet design and implementation.




 







New to this edition:







Updated for the revised Spreadsheet Methods module [5N1977] and Excel 2010 (all assignments can be completed using Excel 2007)






Includes new interactive assignments allowing students to test their spreadsheets. 













Details how to create formulas and functions, sort spreadsheet data, present data using a variety of charts, protect spreadsheets from unauthorised access and automate decision-making with IF functions. 






Presents in-depth explanations of spreadsheet concepts and of the different types of IF functions. 






Introduces useful Excel keyboard shortcuts in each chapter, with all images reflecting Microsoft’s Ribbon system. 






Comprehensively deals with Excel’s charting facility and introduces the use of macros and spreadsheet protection. 






Worked examples guide the learner through each task, while progress tests and chapter reviews support a ‘learning through practice’ approach. 






With no previous experience in spreadsheets required, the learner is brought from the basics to an advanced level.







 




Written for:







Spreadsheet Methods Level 5 module [5N1977]

Alan Dillon teaches Information Technology in Roslyn Park College, Dublin. He has been teaching IT for 20 years and has worked as a computer programmer.

Introduction




Section 1: Beginners Spreadsheet Assignments


Chapter 1: Spreadsheet Formulas


Chapter 2: Spreadsheet Functions


Chapter 3: Linking Data Worksheets


Chapter 4: Spreadsheet Charts


Chapter 5: Sorting Spreadsheet Data





Section 2: Intermediate and Advanced Spreadsheet Assignments


Chapter 6: Spreadsheet Protection and Macros


Chapter 7: IF Functions


Chapter 8: Lookup Functions





Section 3: Project Guidelines and Sample Exams


Chapter 9: Project Guidelines and Sample Exams




Glossary of Spreadsheet Terms

Erscheint lt. Verlag 21.3.2014
Reihe/Serie Step by Step
Verlagsort Dublin
Sprache englisch
Maße 172 x 245 mm
Gewicht 664 g
Themenwelt Informatik Office Programme Office
Informatik Office Programme Excel
Sozialwissenschaften Pädagogik
ISBN-10 0-7171-6044-0 / 0717160440
ISBN-13 978-0-7171-6044-0 / 9780717160440
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich