OCR Level 3 ITQ - Unit 71 - Spreadsheet Software Using Microsoft Excel 2016

Buch | Spiralbindung

2016
CiA Training Ltd (Verlag)
978-0-85741-218-8 (ISBN)

Infos

This training guide has been written specifically for the OCR ITQ (IT User Skills) level 3 Spreadsheet Software, which requires you to use a software application to create complex spreadsheet workbooks. 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 3 unit has a credit value of 6, and requires you to demonstrate the skills and knowledge needed to select and use a range of advanced spreadsheet software tools and techniques to produce complex spreadsheets. 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.

Inhalt

Saving Spreadsheets; Importing and Exporting Data; Data Consolidation; Complex Functions; Auditing; Views; Outlines; Linking Workbooks; Sharing Workbooks; Charts; Data Validation; PivotTables; Scenarios; Sharing Workbooks;

Produkt-Details

• Erscheinungsdatum: 08.07.2016
• Verlagsort: Sunderland
• Sprache: englisch
• Maße: 210 x 300 mm
• Themenwelt: Informatik ► Office Programme ► Excel
• Themenwelt: Informatik ► Weitere Themen ► Zertifizierung
• ISBN-10: 0-85741-218-3 / 0857412183
• ISBN-13: 978-0-85741-218-8 / 9780857412188
• Zustand: Neuware