OCR Level 1 ITQ - Unit 69 - Spreadsheet Software Using Microsoft Excel 2007
by CiA Training Ltd.
This training guide has been written specifically for the OCR Level 1 ITQ unit Spreadsheet Software, which requires you to create and edit spreadsheets. Each exercise in this guide has been designed to gradually build up your knowledge of Microsoft Excel using a simple, user friendly, step-by-step approach.
Spiral
English
Brand New
Publisher Description
This training guide has been written specifically for the OCR Level 1 ITQ unit Spreadsheet Software, which requires you to create and edit spreadsheets. Each exercise in this guide has been designed to gradually build up your knowledge of Microsoft Excel using a simple, user friendly, step-by-step approach. This optional level 1 unit is has a credit value of 3, and requires you to select and use a range of spreadsheet software tools and techniques that are routine and familiar. This guide provides you with the knowledge and techniques necessary to meet these learning outcomes. Data files to accompany this title are available to download from our website, which allow you to practise the many different software features covered.
Table of Contents
1. Spreadsheet principles 2. Creating a spreadsheet 3. Saving, opening and closing 4. Formatting cells 5. Editing and copying 6. Formulas 7. Basic Functions 8. Creating charts 9. Formatting charts 10. Printing spreadsheets and charts 11. Formatting worksheets 12. Summarising data 13. Sorting data
Details
