skip to navigation skip to content
- Select training provider - (Cambridge Digital Humanities)
Thu 7 Jan, Thu 14 Jan, ... Thu 10 Mar 2016
09:00 - 13:00

CANCELLED

Provided by: University Information Services - Digital Literacy Skills


Booking

Bookings cannot be made on this event (Event is cancelled).


Other dates:

No more events



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


Booking / availability

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

Thu 7 Jan, Thu 14 Jan, ... Thu 10 Mar 2016
CANCELLED

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
Sessions

Number of sessions: 10

# Date Time Venue Trainer
1 Thu 7 Jan 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
2 Thu 14 Jan 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
3 Thu 21 Jan 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
4 Thu 28 Jan 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
5 Thu 4 Feb 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
6 Thu 11 Feb 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
7 Thu 18 Feb 2016   09:00 - 13:00 09:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
8 Thu 25 Feb 2016   09:00 - 13:00 * 09:00 - 13:00 * University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
9 Thu 3 Mar 2016   09:00 - 13:00 * 09:00 - 13:00 * University Information Services, Roger Needham Building, Ely Training Room 2 map Lynn Foot
10 Thu 10 Mar 2016   09:00 - 13:00 * 09:00 - 13:00 * University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
* Optional session.
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

Booking / availability