CURRENT BASKET VALUE
£0.00
ABOUT THIS BOOK
ECDL Advanced Spreadsheet Software Using Excel 2013 (BCS ITQ Level 3)
£17.50

ECDL ADVANCED SPREADSHEET SOFTWARE USING EXCEL 2013 (BCS ITQ LEVEL 3)

SPIRAL BOUND BY CIA TRAINING LTD.

£17.50

ISBN
9780857410436
IMPRINT
CIA TRAINING LTD
 
 
EDITION
PUBLISHER
CIA TRAINING LTD
STOCK FOR DELIVERY
NOT IN STOCK - AVAILABLE TO ORDER
FORMAT
SPIRAL BOUND
PAGES
180 pages
PUBLICATION DATE
01 AUG 2013

DESCRIPTION

Approved by BCS and ECDL Foundation. 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 2013 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.

CONTENTS

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.