ECDL Advanced Spreadsheet Software Using Excel 2016 (BCS ITQ Level 3)

Buch | Spiralbindung

180 Seiten

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

Infos

Approved by BCS and ICS Skills. This training guide has been written specifically for the ECDL unit Advanced Spreadsheet Software (BCS ITQ level 3, syllabus 2.0). Each exercise has been designed to build upon and extend your knowledge of Microsoft Excel 2016 using a simple, step-by-step approach. You will learn how to use a range of advanced spreadsheet software tools and techniques to produce complex spreadsheets. Data files to accompany this title allow you to practise the many different software features covered.

Inhalt

Conditional Formating; AutoFormat; Paste Special; Worksheet and Workbook Protection; Cell Comments; Using Names; Creating and Using Templates; Display Formulas; Mixed Referencing; Custom Number Formats; Creating and Using Outlines; Using Scenarios; Linking Cell, Sheets and Books; Importing Delimited Data; Sorting; Filtering Lists; PivotTables; Using Functions; Formating and Modifying Charts; Data Tables; Creating and Running Macros; Auditing; Data Validation; Sharing Workbooks; Tracking Changes;

Produkt-Details

• Erscheint lt. Verlag: 9.3.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-199-3 / 0857411993
• ISBN-13: 978-0-85741-199-0 / 9780857411990
• Zustand: Neuware