|
![]() |
|||
|
||||
OverviewThird edition of this popular, easy-to-use textbook, updated for the revised Spreadsheet Methods Level 5 module [5N1977], which details fundamental spreadsheet methods and facilitates practical experience in spreadsheet design and implementation. New to this edition: Updated for the revised Spreadsheet Methods module [5N1977] and Excel 2010 (all assignments can be completed using Excel 2007) Includes new interactive assignments allowing students to test their spreadsheets. Details how to create formulas and functions, sort spreadsheet data, present data using a variety of charts, protect spreadsheets from unauthorised access and automate decision-making with IF functions. Presents in-depth explanations of spreadsheet concepts and of the different types of IF functions. Introduces useful Excel keyboard shortcuts in each chapter, with all images reflecting Microsoft's Ribbon system. Comprehensively deals with Excel's charting facility and introduces the use of macros and spreadsheet protection. Worked examples guide the learner through each task, while progress tests and chapter reviews support a 'learning through practice' approach. With no previous experience in spreadsheets required, the learner is brought from the basics to an advanced level. Written for: Spreadsheet Methods Level 5 module [5N1977] Full Product DetailsAuthor: Alan DillonPublisher: Gill Imprint: Gill Education Edition: 3rd Revised edition Dimensions: Width: 17.20cm , Height: 2.00cm , Length: 24.50cm Weight: 0.664kg ISBN: 9780717160440ISBN 10: 0717160440 Pages: 384 Publication Date: 21 March 2014 Audience: College/higher education , Tertiary & Higher Education Format: Paperback Publisher's Status: Active Availability: In Print ![]() This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us. Table of ContentsIntroduction Section 1: Beginners Spreadsheet Assignments Chapter 1: Spreadsheet Formulas Chapter 2: Spreadsheet Functions Chapter 3: Linking Data 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 9: Project Guidelines and Sample Exams Glossary of Spreadsheet TermsReviewsAuthor InformationAlan Dillon teaches Information Technology in Roslyn Park College, Dublin. He has been teaching IT for 20 years and has worked as a computer programmer. Tab Content 6Author Website:Countries AvailableAll regions |