Course Title: ECDL ADVANCED
Course Overview Advanced ECDL is an intensive programme that awards a certificate at the end of each successfully completed module. Four modules are available from ECDL: Advanced Word, Excel, Access and Powerpoint. It is not necessary to have completed the entire Core ECDL but you must have completed the four core modules in Word Processing, Spreadsheets, Databases and Presentations before sitting the advanced level. Certification Advanced ECDL Certification Word Processing Advanced ECDL Certification Spreadsheets Advanced ECDL Certification Databases Advanced ECDL Certification Presentations
On Attaining all four advanced certificate you will be issued with an ECDL expert certificate.
Course Content: Advanced Word Processing Advanced Spreadsheets Templates and Styles Tables of contents and indexes Passwords and document security Footnotes and Endnotes Captioning of illustrations and tables Sections, multiple columns and text orientation Macros, Autotext and Autocorrect functions Forms with drop-down fields and check boxes Mail Merge and Field Codes 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 Protecting a Worksheet and File Advanced Databases Advanced Presentations Field Validation, Input Masks and Lookup Relationships, Joins and Referential Integrity Append, Update, Make Table, Delete Queries Queries that use Functions and Wildcards Queries that use Arithmetic and Logical expressions Showing Duplicates, Unmatched values, and Highest and Lowest values Parameter queries that accept data input from a prompt Forms with bound and unbound controls, formulas and expressions Macros and reports Data Import and Export from/to a range of file formats Audience Analysis and Design Choices Planning and Implementation within time and attention constraints Presentation templates Backgrounds - graduated and textured fills, photographs Converting bitmaps to drawn objects Semi-transparent, shadow and 3-D effects Changing image colour depth Image effects: blurred, sharpened, stained glass, and embossed Charting techniques, including flowcharts Incorporating multimedia Macros, data linking Data import and export from/to a range of file formats Outcome On completion of this course you will: Have a more in-depth knowledge of Word and Excel with increased efficiency in the use of all four programs Be able to apply advanced features to a particular work situation. Be able to integrate Microsoft Word, Excel, Access and PowerPoint with other Microsoft Office Programs Be able to Troubleshoot advanced functions Be able to create and customise Word, Excel, Access and PowerPoint
