ECDL Advanced

This course is for anyone who wishes to achieve the ECDL Advanced qualification.

Aims

By the end of this online course you will be confident in the elements of Word, Excel, PowerPoint and/or Access needed to pass the ECDL Advanced exams.

What you will learn

The course will cover the following topics:

Word Processing – MS Word 2003
Automatic Options: Using AutoCorrect; Using AutoText; Using AutoFormat
Laying Out Text: Columns; Creating section breaks; Deleting section breaks
Styles and Templates: Templates; Styles; Outline view
Advanced Formatting: Special text effects; Controlling text flow; Applying borders to paragraphs; Applying shading to paragraphs; Creating footnotes and endnotes; Editing footnotes and endnotes; Creating watermarks
Advanced Editing: Tracking changes; Adding comments and highlighting text
Master and Sub Documents: Creating master and sub documents; Editing master and sub documents
Tables: Creating and editing tables; Sorting data in tables; Simple calculations in tables
Charts and Worksheets: Creating charts; Moving, resizing and deleting charts; Editing charts and worksheets
Graphics and Drawing: Inserting graphics; Creating a simple drawing; Grouping and ordering shapes; Wrapping text around objects; WordArt; Adding captions
Text Boxes: Creating text boxes; Formatting and linking text boxes
Forms: Creating a form; Setting form field properties; Protecting and using forms
Fields and References: Inserting and updating fields; Creating an index and marking index entries; Editing an index; Creating a table of contents; Creating cross references; Creating and using bookmarks
Macros: Recording a macro; Copying a macro; Assigning a macro to a toolbar
Mail Merge: Mail merge: the theory; Creating a mail merge data document; Carrying out a mail merge; Selecting and sorting data for a mail merge
Printing and Protecting Documents: Printing documents; Protecting documents.
Spreadsheets – MS Excel 2003
Editing: Range names; Formatting cells; Conditional formatting; Importing data; Freezing and hiding rows and columns; Subtotals; Data tables; Protecting your work
Sorting and Linking: Sorting; Filters; Linking worksheets and workbooks; Linking with Word
Templates and Charts: Templates; Chart graphics; Chart options
Functions: Date and time functions; Mathematical functions; Statistical functions; Text functions; Financial functions
More Functions: Lookup and reference functions; Logical functions; Database functions
Analysis: Pivot tables; Scenarios; Auditing a worksheet
Special Tools: Macros; Assigning a macro to a button.

Presentations – MS PowerPoint 2003
Starting Up: Advanced background formatting; Creating templates
Charts: Creating a chart; Editing charts; Working with flowcharts
Bells and Whistles: Sounds and movies; Working with animation effects; Adding slide transitions
Timesavers: Using format painter; Hyperlinks; Working with macros
Preparing Images: Using special image effects; Further image changes
Working with Pictures: Applying fill effects to objects; 3D, shadow and other effects; Rotating and ordering objects; Positioning images; Converting pictures
Importing and Linking: Importing slides from another presentation; Importing text from Word; Linking data; Saving slides as images
Before the Show: Using set up show; Custom shows; Planning your presentation; Design tips.
Databases – MS Access 2003
Creating and Editing Tables: Creating tables; Editing tables; Creating lookups; Changing field properties
Relational Databases – One-to-Many: What are relationships?; Creating a one to many relationship; Creating main and subforms for a one to many relationship; Editing relationships
Relational Databases – One-to-One: What is a one to one relationship?; Creating a one to one relationship; Creating main and subforms for a one to one relationship
Relational Databases – Many-to-Many: What is a many to many relationship?; Creating a many to many relationship; Creating main and subforms for a many to many relationship; Editing a subform
Action Queries: Delete queries; Update queries; Make table queries; Append queries; Find duplicates query
Advanced Forms: Adding bound controls; Adding a bound object frame; Using unbound controls to format your form; Command buttons; Unbound object frames; Tab controls; Controls which give the user a choice; Creating calculations on a form; Setting the tab order; Form headers and footers
Advanced Reports: Grouping data on a report; Creating summaries on a report; Creating calculations on a report; Using functions on a report; Headers and footers on a report
Macros: Creating and running a macro; Assigning a macro
Importing and Exporting Data: Importing data; Exporting data.

How the online course works

The online modules are structured as follows:

How it works

Here you can find out about how our lessons are structured, the style of training we use, and guidance on some of the features you will find in our lessons.

Course materials

Here you will find the manual and the demo files you need to complete the lessons.

Complete the pre-course assessors

Here you can choose a pre-course assessor to assess which lessons you need to take. The pre-course assessors can be taken in any order you wish.

Start lessons

Here you will find the full list of lessons for that module.

Your learning plan

Here you will find lessons that have been added to a structured plan for you based on the results of the pre-course assessors. You can also manually add and remove lessons from this plan.

Next step

Once you have completed this course you will be ready to complete your ECDL Advanced exams.