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.
THE AUTHOR
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.