Do you regularly use a spreadsheet application and need to know how to create complex spreadsheets and be able to sort, query and chart data?
If so ECDL Advanced Spreadsheets will give you the knowledge and skills you need. The syllabus covers the following:
- Formatting - naming cell range, automatic & conditional formatting.
- Data Handling - import data from other applications, use one or two input data and what-if tables. Sort and query data using single and multiple criteria, use pivot tables and dynamic cross-tabs.
- Display - free data headings, hide rows, columns and worksheets.
- Security - protect worksheets or cells, password protect.
- Linking Data - link data in worksheets and between worksheets and other applications. Consolidate data across worksheets.
- Charts and Graphs - create charts and graphs and adjust presentation.
- Functions and Macros - use a range of functions including text, statistical and lookup functions. Record and run macros.
- Auditing - trace precedent and dependant cells in a worksheet. Edit and add worksheet comments.
See the full syllabus here. Try a sample test from the British Computer Society, or purchase an learning pack from the Learning Team, Uxbridge Library for only £20 (includes a multitude of exercises & sample tests but not exam registration).
AM3 - Word Processing | AM4 - Spreadsheets | AM5 - Databases | AM6 - Presentations
