By the author of Step by Step Spreadsheets. 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 (templates and solutions available) to test learning and knowledge. It meets all the learning outcomes for Spreadsheets Methods 5N1977.
Suite of “How to” video tutorials available to tutors who adopt this book as an essential text for their classes.
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.
Alan Dillon teaches Information Technology in Roslyn Park College, Dublin. He has been teaching IT for 25 years and has worked as a computer programmer.