Description
New to this edition: – Completely updated for Excel 2007 – Includes more in-depth explanations of spreadsheet concepts – All images reflect Microsoft’s Ribbon System – More in-depth explanations of the different types of IF functions – Useful Excel keyboard shortcuts are introduced in each chapter – Progress tests and chapter reviews are available at the end of each chapter – More worked examples guiding the learner through each task

• Details how to: – Create formulas and functions – Sort spreadsheet data – Present data using a variety of charts – Protect spreadsheets from unauthorised access – Automate decision making with IF functions

• Brings the learner from the basics of spreadsheets to an advanced level • Emphasises learning through practice • Comprehensively deals with Excel’s Charting Facility • Introduces the use of macros and spreadsheet protection • No previous experience in Spreadsheets is required
WRITTEN FOR: Spreadsheet Methods FETAC Level 5

Author Biography
Alan Dillon teaches Information Technology in Roslyn Park College, Dublin. He has been teaching IT for 16 years, but has also worked as a computer programmer.

Table of Contents
Section 1: Beginners Spreadsheets Assignments
Chapter 1: Spreadsheet Formulas
Chapter 2: Spreadsheet Functions
Chapter 3: Naming and Linking Worksheets
Chapter 4: Spreadsheet Charts
Chapter 5: Sorting Spreadsheet Data
Section 2: Intermediate and Advanced Spreadsheet Assignments
Chapter 6: Spreadsheet Protection and Macros
Chapter 7: IF Functions
Chapter 8: Lookup Functions
Section 3: Project Guidelines and Sample Exams
Chapter 10: Project Guidelines and Sample Exams
Glossary of Spreadsheet Terms