skip to navigation skip to content
- Select training provider - (Development and Alumni Relations - Staff Learning & Development)
Instructor-led course

Provided by: University Information Services - Digital Literacy Skills


This course is not scheduled to run.



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Events available

Microsoft Office Specialist: Excel Expert 2013 (Exam 77-427 and 77-428)
PrerequisitesSpecial£


Description

Would you like to:

  • take your Excel skills further?
  • prove what you can achieve?

This instructor-led course fee based course concentrates on taking your current Excel skills further to accomplish the technical tasks listed under topics.

This course prepares you for the internationally recognised Microsoft Office Specialist Excel 2013 Expert Exam 77-427 and Microsoft Office Specialist Excel 2013 Expert Exam 77-428. The last three sessions of the course are dedicated to revision and the exam, it isn't compulsory to sit the exam but it is advisable as the qualification will reflect your expertise.

Should you wish to take an introductory course in Excel leading to a qualification before taking this course, we also offer Microsoft Office Specialist: Excel 2013 (Exam 77-420)

Excel 2013 Expert is part of the Microsoft Office certification

Target audience
  • All current Cambridge University members (departments and colleges)
  • Further details regarding eligibility criteria are available
Prerequisites
Topics covered
  • Lesson 1: Advanced Functions and Pivot Tables
  • Lesson 2: Advanced Charts, Conditional formatting, and Checking Formulas
  • Lesson 3: Filtering and Sharing Workbooks
  • Lesson 4: Custom Formatting and What-If Analysis
  • Lesson 5: Pivot Charts and Advanced Formulas
  • Lesson 6: Protecting and Configuring Workbooks

For a further breakdown in topics see Skills measured

Format

Presentation and demonstrations with practical exercises

Taught using

Excel 2013 on MCS Windows

Charging
  • All departments and colleges £245

The fee includes

  • A comprehensive textbook
  • Practice GMetrix tests
  • An exam, a re-take and exam certificate
Exam information

The course prepares you for the internationally recognised Microsoft Office Specialist Excel 2013 Expert Exam 77-427 and Microsoft Office Specialist Excel 2013 Expert Exam 77-428 which is part of the Microsoft Office certification

This exam can be taken at our Certiport exam centre.

A full list of exam topics can be viewed under Skills measured on the following Microsoft Office Specialist Excel 2013 Expert Exam 77-427 and Microsoft Office Specialist Excel 2013 Expert Exam 77-428 pages.

MS IT Academy Certification Roadmap

Notes
  • You may need to work around 3 hours per week between each class depending on your current skill level
Duration

Six half day sessions and an optional exam

Frequency

Once a year

Related courses

Events available