The MOS Excel 2016 Course (Desktop / Office 365) is designed to give students an essential understanding of the Microsoft Excel software environment and aims to give students the ability to complete tasks independently in preparation for their Microsoft Office Specialist exam. You will how to demonstrate the correct application of the principle features of Excel 2016, how to create and edit a workbook with multiple sheets, and how to use a graphic element to represent data visually.

Designated as approved course materials for the Microsoft Office Specialist program, this course will help students prepare for the MOS Core Excel 2016 exam (77-727: Core Data Analysis, Manipulation, and Presentation) and can also be used as a learning resource for the MOS Expert Excel exam (77-728: Interpreting Data for Insights).

The course consists of the following items:

MOS Microsoft Excel 2016 - Part 1 Book (Desktop / Office 365):

This course book is intended to cover the standard functions of Microsoft Office Excel 2016 that are necessary to create and work with spreadsheets.

  • Lesson 1: Getting Started with Microsoft Office Excel 2016
  • Lesson 2: Performing Calculations
  • Lesson 3: Modifying a Worksheet
  • Lesson 4: Formatting a Worksheet
  • Lesson 5: Printing Workbooks
  • Lesson 6: Managing Workbooks

On successful completion of this course book, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse important data.


  • Get started with Microsoft Office Excel 2016.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

MOS Microsoft Excel 2016 – Part 2 Book:

This course book builds on the foundational knowledge and skills and covers some of the higher-level functionality in Excel which is designed to analyse and present data.

  • Lesson 1: Working with Functions
  • Lesson 2: Working with Lists
  • Lesson 3: Analysing Data
  • Lesson 4: Visualising Data with Charts
  • Lesson 5: Using PivotTables and PivotCharts

Upon successful completion of this course book, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.


  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and PivotCharts.

MOS Microsoft Excel 2016 – Part 3 Book:

This course book covers some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

  • Lesson 1: Working with Multiple Worksheets and Workbooks
  • Lesson 2: Using Lookup Functions and Formula Auditing
  • Lesson 3: Sharing and Protecting Workbooks
  • Lesson 4: Automating Workbook Functionality
  • Lesson 5: Creating Sparklines and Mapping Data
  • Lesson 6: Forecasting Data


On successful completion of this course book students will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create sparklines and map data.
  • Forecast data.

Student Exercise Files:

Once enrolled students will receive a support email giving them access to their student files and to PowerPoint presentations relevant to the content of each unit. These files are also available through a student page and can be sent on disk on request.

GMetrix Exam Preparation Software:

The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

Overview of Test features:

  • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
  • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
  • All tests have both a testing and a training mode providing step-by-step help on each question.
  • Progress at own pace, save test to resume later, return to skipped questions.
  • Detailed, printable score report highlighting areas requiring further review.

Please Note: You will need a version of Microsoft Office 2016 to be able to use the GMetrix software package.


There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2016 to complete the course.

Course Duration & Support:

Students may register at any time. The courses are designed as self-study courses but if you have any problems you can email our email support. As the course is self-study you can complete in as little or as long a time as you prefer, and we do not impose a cut-off date for study.

APPLE MAC USERS: We recommend this course is completed on a PC with the Windows Operating System. The course can be run on an Apple Macs using software such as Boot Camp, Parallels Desktop 7, VMware fusion or CrossOver Mac although we cannot support any issues that may occur with PC-Based software running on a Mac.


Assessment is in the form of MOS Examinations. MOS 2016 Examinations are project-based simulations which are designed to offer real world exercises to appraise a student's understanding of using Microsoft Office.


MOS Excel 2016 CourseOn completion of this course students can apply for the Microsoft Office Specialist Excel 2016 77-727 Exam and the Microsoft Office Specialist Excel 2016 Expert 77-728 Exam.

Examinations must be sat at a registered Certiport Testing Centre. Exam vouchers (Valid for 12 Months) can be purchased from via our website for £75.00. We usually advise buying a voucher when you are ready to sit your test, although you can add this to your order when you purchase your course.

Students can locate testing centres and schedule appointments on the Certiport Website by following the Test Candidates > Locate a Testing Centre links.

Please Note: Exam Centre's will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.

View Testimonials
Submit a Testimonial