ECDL Advanced

Course

In Sunderland and Middlesbrough

£ 600 + VAT

Description

  • Type

    Course

  • Level

    Advanced

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

Middlesbrough (Cleveland)
Royal Middlehaven House, 21 Gosford Street, TS2 1BB

Start date

On request
Sunderland (Tyne and Wear)
See map
34 West Sunniside, SR1 1BU

Start date

On request

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Teachers and trainers (1)

Max Liversidge

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

£ 600 + VAT