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.