|
![]() |
|||
|
||||
OverviewThis training guide has been written specifically for the OCR Level 2 ITQ unit Spreadsheet Software, which requires you use a software application 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 2 unit is has a credit value of 4, and requires you use a range of intermediate spreadsheet tools and techniques to produce spreadsheets that are at times non-routine and unfamiliar. 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. Full Product DetailsAuthor: CiA Training Ltd.Publisher: CiA Training Ltd Imprint: CiA Training Ltd Dimensions: Width: 21.00cm , Height: 1.30cm , Length: 30.00cm ISBN: 9781860059155ISBN 10: 1860059155 Pages: 144 Publication Date: 07 December 2010 Audience: Adult education , Further / Higher Education Format: Spiral bound 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 Contents1. Spreadsheet principles 2. Creating a spreadsheet 3. Opening, saving and closing 4. Formatting worksheets 5. Editing and copying 6. Formulas 7. Functions 8. Creating charts 9. Formatting charts 10. Printing spreadsheets and charts 11. Cell referencing 12. Linking across worksheets 13. Sorting and filteringReviewsAuthor InformationTab Content 6Author Website:Countries AvailableAll regions |