Step by Step Spreadsheets - Softcover

Alan Dillon

Softcover

ISBN 10: 0717160440 ISBN 13: 9780717160440

Publisher: Gill & Macmillan Ltd, 2014

Synopsis

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]

About this title

About the Author

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.

Edition details

• Publisher: Gill & Macmillan Ltd
• Publication date: 2014
• Language: English
• ISBN 10: 0717160440
• ISBN 13: 9780717160440
• Binding: Paperback
• Edition number: 3
• Number of pages: 384