BCS Advanced ECDL Wordprocessing and Spreadsheets

BCS Advanced ECDL - Wordprocessing & Spreadsheets

Code: 70017

Department: ICT

Short Description: ECDL advanced Word Processing and Spreadsheets will allow someone who used the applications regularly to use more advanced tools.

Entry Requirements: ECDL

Content: Spreadsheets
Formatting Naming cell range, using automatic and conditional cell formatting.

Data Handling Import data, use what-if tables. Sort and query data. Use pivot tables and Dynamic crosstabs
Display Freeze data headings, hide rows, columns and worksheets

Security Protect worksheets or cells, password protect

Linking Data Link data between worksheets and other applications. Consolidate data across worksheets

Charts & Graphs Create charts and graphs and adjust presentation

Functions & 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

Word Processing
Text Management Using subscript and superscript, animated text, different orientation and text wrapping

Automation Using automatic text formatting and correction, using and creating macros and field codes, creating advanced mail merges, automated captioning

Layout Creating templates and master documents, inserting tables of contents, using sections and columns

Organisation Creating bookmarks and indexes, using footnotes and endnotes

Document Elements Creating forms, text boxes and tables

Images & Drawing Creating simple drawings and using drawing and image tools

Embedding Data Inserting Spreadsheet data and charts