7 John F Kennedy  Parade, Sligo, Ireland Tel: 071-9143656      Fax: 071-9141629    Email: contact@cbtraining.ie

Advanced ECDL Spreadsheets This module requires the candidate to edit and enhance numeric, text and graphical data, and to sort, query and link data. The candidate will be expected to use logical, statistical and mathematical functions. Ability to use analysis and audit tools is required, as is the ability to record and run macros. Selection of Topics Covered: Conditional formatting Data Tables Sorting and Filtering Data Linking Charting techniques Date/time, Mathematical, Logical, Text, Lookup functions Pivot tables Scenarios Templates and Macros Subtotals Spreadsheet Security Back to Courses