City & Guilds Level 3 ITQ - Unit 327 - Spreadsheet Software Using Microsoft Excel 2013

CiA Training Ltd. (Autor)

Buch | Spiralbindung

162 Seiten

2013
CiA Training Ltd (Verlag)
978-0-85741-128-0 (ISBN)

Infos

This training guide has been written specifically for the City & Guilds ITQ (IT Users) level 3 unit 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 unit 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

• Erscheint lt. Verlag: 1.10.2013
• Verlagsort: Sunderland
• Sprache: englisch
• Maße: 210 x 300 mm
• Themenwelt: Informatik ► Office Programme ► Excel
• Themenwelt: Informatik ► Weitere Themen ► Zertifizierung
• ISBN-10: 0-85741-128-4 / 0857411284
• ISBN-13: 978-0-85741-128-0 / 9780857411280
• Zustand: Neuware