ao link

Step by Step Spreadsheets

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]


63 Available

Add To Basket



Publication Date

March 2014




Paperback, 384 pages

Country of Origin



Gill Education



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


245 x 172 mm


By Alan Dillon

Availability Status


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.

Additional Resources

Add To Basket
Gill Education,
Hume Avenue,
Park West,
D12 YV96,
Follow Gill Education on:
Like us on Facebook
Follow us on Twitter
Follow us on Instagram
© 2021 M.H. Gill & Co. Unlimited Company