Description

Published: 2020

Presents in-depth explanations of spreadsheet concepts with interactive assignments to test learning and knowledge

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

New edition uses flowcharts to explain difficult concepts. 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

Created for Microsoft (MS) Excel 2019 and Excel 2016, but compatible with Excel 2010, this book contains:?

— 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 ?

Meets all the learning outcomes for Spreadsheets Methods 5N1977.