About this Course

By the end of this course, users should be comfortable with automating worksheet functionality, auditing worksheets, using a variety of different analysis tools, working effectively with multiple workbooks, exporting Excel data, as well as importing and exporting XML data to and from a workbook. This course is broken up into lessons. Each lesson focuses on several key topics, each of which are broken down into easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions for you to answer. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.


Lesson 1: Auditing Worksheets

Lesson 2: Working with Multiple Workbooks

Lesson 3: Automating Worksheet Functionality

Lesson 4: Analyzing and Presenting Data

Lesson 5: Analyzing Data with PivotTables, Slicers, PivotCharts  and Data Models

Lesson 6: Exporting Excel Data

Lesson 7: Importing and Exporting XML Data


This class assumes the user has completed or has an understanding of the materials covered in the second part of the Microsoft Office Excel 2016 courseware, including:

§  Creating advanced formulas

§  Analyzing data with logical and lookup functions

§  Organizing worksheet data with tables

§  Visualizing data with charts

§  Analyzing data with PivotTables, slicers, and PivotCharts

§  Inserting graphics

§  Enhancing workbooks

Exam Details

Exam 77-727: Microsoft Office 2016 Excel

Microsoft Office Specialist Excel 2016: Core Data Analysis, Manipulation, and Presentation

  1. Attend all classes to satisfy the required education requirement.
  2. Review the skills measured by the 77-727 certification exam 
  3. Read MicroTrain Excel 2016 Courseware, Level 1,2 and 3 books
  4. Complete the classroom labs
  5. Read GMetrix MOS Practice Tests Quick Start Guide and download GMetrix SMS client.
  6. Qualify for MicroTrain Exam Guarantee, within one (1) year from voucher start date, email two (2) practice exam results in the certification mode with a score of 90% or better to sts@microtrain.net,  and sit for certification exam within 30 days.  
  7. Read the  Microsoft Certification exam policies and FAQs
  8. Locate a Certiport testing center near you
  9. Create a Certiport Account and Schedule Your Exam
  10. Before exam day, save time and review the Microsoft Office Specialist exam instructions/tutorial
  11. Pass the Microsoft Office Specialist 2016 Excel exam (77-727). The certification exam must be taken within 30 days of completing the course. The 77- 727 exam is 50 minutes long and consists of 35 performance-based questions conducted in a live or simulated environment. Upon completion of the exam, you will see the overall pass/fail test results. 
  12. Upload photocopy of certification results in your theprofessional.me account. Log in to your theprofessional.me account, click Get Certified in the navigation bar, then navigate to Exam 77-727: Microsoft Office 2016 Excel and click the hyperlink next to Date, verify exam date, choose a file to upload, and record your results.

Exam Pass Guarantee

At Microtrain we are committed to your success! Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Raves & Praise

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top