Created for Microsoft (MS) Excel 2019 and Excel 2016, but compatible with Excel 2010, this book contains in-depth explanations of spreadsheet concepts with interactive assignments to test learning and knowledge. It meets all the learning outcomes for Spreadsheets Methods 5N1977.

Section 1: Beginners’ Spreadsheet Assignments (no previous spreadsheet experience required)

Section 2: Intermediate and Advanced Spreadsheet Assignments (some knowledge of MS Excel)

Section 3: Project Guidelines and Sample Exams

DEMONSTRATES HOW TO:

o create formulas and functions

o sort spreadsheet data o present data using a variety of charts

o protect spreadsheets from unauthorised access

o automate decision-making with IF functions

o access data from lists using look-up functions

o program multi-step tasks through the creation, execution, and management of simple macros.

Uses flowcharts to explain difficult concepts.

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