Brand New
ECDL Expert is a brand new Certification issued by ECDL to holders of 4 advanced ECDL Certificates. Ireland is the first country in Europe to offer this new Certification and 21st Century the first in the West! If you have completed any of the ECDL Advanced modules at advanced level, then simply sit the remaining modules and you will qualify for an ECDL Expert Certificate - one of the highest levels of Certification available to end users of office applications

Target Group
Advanced ECDL is ideal for people interested in an advanced computer skills qualification or in having their existing computer skills tested and certified at a higher level.
This course is an advanced follow-on to the core ECDL course. It is a good step up from Core ECDL and therefore is only suitable for regular proficient users of the computer.

Why use 21st Century
21st Century are one of the first centres accredited in the West with Advanced ECDL. We have been training at this level since August 01. 21st Century have a 100% pass rate with ECDL Advanced, based on full attendance, with average marks of 90%. We are in the top ten providers of Core ECDL in Ireland with well over 1,000 persons fully accredited to date. We cater for all levels of candidates with an excellent short Preparatory ECDL course and for more experienced users we offer Advanced ECDL.

Course Overview
Advanced ECDL is an intensive programme that awards a certificate at the end of each successfully completed module. Two modules are currently available from ECDL: Advanced Word and Excel. 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 Powerpoint

On completion of all 4 modules candidates are entitled to an ECDL Expert Certificate

Duration

Course Content

• Advanced Word Processing
  · 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
  
  
• Advanced Spreadsheets
  · 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
  · 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
  
  
• Advanced Presentations
  · 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

Holding an ECDL Advanced Certificate will prove that an individual's competence with computer use is well above the basic skill level, and will help determine suitability for jobs involving computer use at a higher level. It will also increase the value to an employer of skilled, qualified staff.

Cost
€950 for all 4 Modules
Which includes €40 for each skills card (€160 for all four modules)

_________________________________________________________________________________________________________

Each Training programme will have a minimum Deposit required to confirm booking on the course. Full payment for the course is due prior to commencement of the course or on the first night of the course. Cancellation - If you cancel the course 1 week in advance we will refund your deposit. If cancellation is received less than one week in advance of the course commencing, a refund will be dependant on our ability to fill your place on the course. Please note that the ability to replace you on a course is not guaranteed and subsequently the ability to offer a refund is not guaranteed. Once you have commenced the course no refund will be available.