Step by Step Spreadsheets

Updated for Excel 2007, this easy-to-use textbook presents the fundamental concepts, while providing practical experience in spreadsheet design and implementation. 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