ECDL Advanced
Course
In Sunderland and Middlesbrough
Description
-
Type
Course
-
Level
Advanced
-
Location
-
Class hours
120h
Expert knowledge of Microsoft Office suite - office 2003 or 2007. Suitable for: Advanced PC Application users
Important information
Documents
- Course Data Sheet
Facilities
Location
Start date
Start date
Start date
About this course
You do not have to have passed the ECDL before sitting an Advanced Level course, but it is a significant advantage to the learner to have completed ECDL prior to starting on Advanced ECDL.
Reviews
Teachers and trainers (1)
Max Liversidge
Microsoft Master Instructor
Course programme
The Advanced ECDL has four independent courses - Word Processing, Spreadsheets, Databases and Presentations. They each can be studied independantly and you do not have to have passed the ECDL before sitting an Advanced Level course.
Each subject will take about 40 hours to study, and has one practical exam, which you can sit in one of our Centres.
Syllabus Word Processing
- Text Effects, Using AutoCorrect and AutoFormat, Paragraph Editing, Creating and Modifying Styles, Printing Selected Text and Pages, Adding/Deleting Section Breaks, Controlling Column Layout
- Manipulating Data in Tables, Manipulating Text Boxes, Adding Borders and Shading
- Creating and Editing Drawings, Watermarks
- Footnotes and Endnotes, Creating a Table of Contents, Cross Referencing, Creating an Index
- Creating and Modifying Templates, Collaborative Editing, Password Protection, Master Documents
- Working with Field Codes, Creating and Editing Forms, Mail Merge, Working with Spreadsheets
- Macros
Spreadsheets
- Freezing Panes, Conditional Formatting, Paste Special, Worksheet and Workbook Protection
- Cell Comments, Names, Creating and Using Templates, Display Formulas, Formulas that Produce Errors
- Custom Number Formats, Using Scenarios, Linking Cells, Sheets and Books
- Sorting Data, Filtering Lists, Pivot Tables, Advanced Functions
- Formatting and Modifying Charts, Data Tables
- Using Macros, Auditing
- Importing Data
Databases
- Creating a New Database, Using Wildcards in Queries, Performing Queries
- Applying Relationships, Applying Joins, Referential Integrity, Querying Multiple Tables
- Lookup Fields, Default Values, Setting a Mandatory Field, Validation Rules/Text, Input Masks
- Using Forms with Subforms, Calculated Fields, Command Buttons, Combo Boxes, Other Form Controls
- Creating and Printing Reports, Grouped Reports, Importing and Exporting Data
- Using Action Queries, Using Query Wizards
- Creating and Using Macros
Presentations
- Design Considerations, Colour Scheme and Effects, Creating and Using Templates
- Inserting Text and Slides, Drawing Objects, Rotating and Flipping Objects, Editing and Cropping Images
- Combination Charts, Editing and Animating Charts
- Creating and Amending Flowcharts
- Inserting Sounds and Movies, Animation Sequences, Action Buttons, Custom Shows, Slide Transitions and Timings
- Linking Text, Chart, Worksheet Range, Modifying Linked Data, Embedding Objects
- Recording and Running a Macro, Assigning a Macro
ECDL Advanced