About this Course

This certification course provides a complete training solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Excel 2010 Expert Accreditation. This is an Expert accreditation in addition to the lower level MOS Microsoft Excel 2010 Specialist accreditation which is NOT a prerequisite of the Expert exam. It is aimed at delegates usually as part of the MOS Master Certification track or those simply seeking to attain a higher level accreditation in Microsoft Excel 2010.

It concentrates on getting delegates from knowledgeable to 'exam ready' in a 2 day course. The course is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills and practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.

Please note this is the Expert level: one of two levels of exam available for Microsoft Excel 2010 (Specialist and Expert). MOS exams are also available for Word, PowerPoint, Outlook and Access 2010.

Included Are:

  • 2-days Instructor Led Training using MOS Official Courseware
  • MOS Practice Exam Voucher
  • MOS Exam Voucher
  • Free Exam Re-take (where required)

During the 2 day course you will cover the following topics to prepare you for exam 77-888: Microsoft Office Excel 2010 Expert. During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day two.

Essential Excel Keyboard Shortcuts

Essential Microsoft Excel Shortcuts

In this article we list some of the top Microsoft Excel shortcuts you should know, helping you navigate Excel more easily. Read the full article

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA


There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London


    International House

  • Manchester


    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

Sharing and Maintaining Workbooks

Apply workbook settings, properties, and data options

  • Setting advanced properties, saving a workbook as a template, and importing and exporting XML data

Apply protection and sharing properties to workbooks and worksheets

  • Protecting the current sheet, protecting the workbook structure, restricting permissions, and requiring a password to open a workbook

Maintain shared workbooks

  • Merging workbooks and setting Track Changes options

Applying Formulas and Functions

Audit formulas

  • Tracing formula precedents, dependents, and errors, locating invalid data or formulas, and correcting errors in formulas

Manipulate formula options

  • Setting iterative calculation options and enabling or disabling automatic workbook calculation

Perform data summary tasks

  • Using an array formula and using a SUMIFS function

Apply functions in formulas

  • Finding and correcting errors in functions, applying arrays to functions, and using Statistical, Date and Time, Financial, Text, and Cube functions

Presenting Data Visually

Apply advanced chart features

  • Using Trend lines, Dual axes, chart templates, and Sparklines

Apply data analysis

  • Using automated analysis tools and performing What-If analysis

Apply and manipulate PivotTables

  • Manipulating PivotTable data and using the slicer to filter and segment your PivotTable data in multiple layers

Apply and manipulate PivotCharts

  • Creating, manipulating, and analysing PivotChart data

Demonstrate how to use the slicer

  • Choosing data sets from external data connections

Working with Macros and Forms

Create and manipulate macros

  • Running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access Toolbar, and applying modifications to a macro

Insert and manipulate form controls

  • Inserting form controls and setting form properties

This course has strict prerequisites - delegates should have already attended the relevant Levels 1, 2 and 3 courses or have equivalent knowledge. This course is NOT a fast track course for learning the exam material but a course for turning knowledge in to exam readiness.

Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.