77-727-77-728
Microsoft Office Excel 2016 Expert (77-727-77-728)
Prepare for the Excel Certification Exam with 100+ video tutorials and 50+ Live Lab exercises.
- Practice in 50 Hands-On Labs — nothing to install
- 10 Interactive Lessons and 44 topics mapped to the official exam objectives
- 75 Practice Test Questions
Intermediate Self-paced · 1 year access 4.7/5 (17 Reviews)
50 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
10Interactive Lessons
44Topics
50LiveLab
75Practice Test Questions
104Videos
56Flashcards
56Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
Upgrade your excel skills with this Microsoft Excel 2016 Expert certification preparatory course. Gain a deep understanding of Excel's advanced features to manage complex data analysis and reporting tasks using Microsoft Excel 2016. This training course covers the Excel expert exam objectives focusing on how to create and optimize worksheets and workbooks, manage data cells and ranges, create tables, perform operations with formulas and functions, create charts and objects, and create advanced charts and tables. By the end of this Expert 77-727 & 77-728 certification exam training course you’ll learn how to apply advanced data analysis techniques to extract meaningful insights and create professional reports.
- Ability to create, configure, review and manage multiple worksheets within a workbook
- Apply custom data formats for data consistency and accuracy
- Highlight data values or conditions with conditional formatting
- Data validation to prevent errors and maintain integrity
- Complex formulas for logical, mathematical, statistical, and financial functions
- Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH) to retrieve data
- Date and time functions for calculations and formatting
- Summarize and analyze large datasets with PivotTables and PivotCharts
- Identify trends, patterns, and outliers with data analysis tools
- Create and customize different chart types to visualize data
- Insert and customize shapes, text boxes, and objects within the worksheets
- Filter and sort data within tables
- Define named ranges and simplify formula creation to automate tasks
Target Career Roles
- Editor
- Data Analyst
- Microsoft System Administrator
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
10 Interactive Lessons · 44 topics01 Introduction 3 topics +
- Course Overview
- About 77-727 and 77-728 Exams
- Prerequisites
02 Creating and Formatting Worksheets 5 topics · 21 LiveLab +
- Creating Worksheets and Workbooks
- Navigating in Worksheets and Workbooks
- Formatting Worksheets and Workbooks
- Customizing Options and Views for Worksheets and Workbooks
- Summary
21 LiveLab in this lesson — see the labs panel →
03 Configuring and Managing Workbooks 4 topics · 4 LiveLab +
- Configuring Worksheets and Workbooks for Distribution
- Managing Workbooks
- Managing Workbook Review
- Summary
4 LiveLab in this lesson — see the labs panel →
04 Applying Custom Data Formats and Layouts 5 topics · 1 LiveLab +
- Applying Custom Data Formats and Validation
- Applying Advanced Conditional Formatting and Filtering
- Creating and Modifying Custom Workbook Elements
- Preparing a Workbook for Internationalization
- Summary
1 LiveLab in this lesson — see the labs panel →
05 Managing Data Cells and Ranges 4 topics · 5 LiveLab +
- Inserting Data in Cells and Ranges
- Formatting Cells and Ranges
- Summarizing and Organizing Data
- Summary
5 LiveLab in this lesson — see the labs panel →
06 Creating Tables 4 topics · 3 LiveLab +
- Creating and Managing Tables
- Managing Table Styles and Options
- Filtering and Sorting Tables
- Summary
3 LiveLab in this lesson — see the labs panel →
07 Performing Operations with Formulas and Functions 4 topics · 2 LiveLab +
- Summarizing Data by Using Functions
- Performing Conditional Operations by Using Functions
- Formatting and Modifying Text by Using Functions
- Summary
2 LiveLab in this lesson — see the labs panel →
08 Creating Advanced Formulas 7 topics · 7 LiveLab +
- Applying Functions in Formulas
- Looking up Data Using Functions
- Applying Advanced Date and Time Functions
- Performing Data Analysis and Business Intelligence
- Troubleshooting Formulas
- Defining Named Ranges and Objects
- Summary
7 LiveLab in this lesson — see the labs panel →
09 Creating Charts and Objects 4 topics · 6 LiveLab +
- Creating Charts and Objects
- Formatting Charts
- Inserting and Formatting Objects
- Summary
6 LiveLab in this lesson — see the labs panel →
10 Creating Advanced Charts and Tables 4 topics · 1 LiveLab +
- Creating Advanced Charts
- Creating and Managing PivotTables
- Creating and Managing PivotCharts
- Summary
1 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
50 LiveLabs- Creating a New Workbook
- Inserting a Column
- Creating a Workbook from a Template
- Printing a Workbook
- Importing Data from a File
- Copying and Pasting Contents
- Exploring the Format Task Pane
- Auto-Hiding the Ribbon
- Entering the Date and Time
- Adding Worksheets to Workbooks
- Understanding Cell References
- Changing the Workbook View
- Setting and Saving the Print Area
- Changing the Width of the Column to Automatically Fit the Contents
- Changing the Row Height to Fit Contents
- Adding Commands to a New Group
- Modifying a Worksheet
- Adding New Commands to the Quick Access Toolbar
- Hiding a Column
- Formatting Numbers
- Hiding or Unhiding the Content
- Arranging Excel Windows
- Protecting a Worksheet
- Freezing the Top Row
- Protecting a Workbook's Structure
- Changing Date Format
- Entering Text and Values
- Using Relative, Absolute, and Mixed References
- Changing the Text Color
- Using the Middle Align and Center Command
- Formatting a Heading
- Deleting and Editing the Cell Content
- Converting a Table to a Cell Range
- Changing the Table Style
- Using the UPPER Function
- Using the PROPER Function
- Using the INDEX Function
- Using the MATCH Function
- Using the DATE Function
- Using the WORKDAY Function
- Using the TODAY Function
- Creating a Data Table
- Creating Names for Cell Ranges
- Removing Gridlines and Headings
- Changing the Chart Title
- Inserting and Configuring a Shape
- Inserting SmartArt
- Inserting WordArt
- Inserting and Modifying an Image
- Creating a PivotTable Automatically
Labs run in your browser — nothing to install.
03 / Exam details
Microsoft Office Excel 2016 Expert (77-727-77-728) Details
Get certified for the Microsoft Excel certification exams with the Microsoft Office Excel 2016 Expert (77-727-77-728) course and lab. The lab provides a hands-on learning experience in a safe, online environment. The Microsoft Excel training course covers the Excel expert exam objectives and teaches you how to create and manage worksheets and workbooks; manage data cells and ranges; create tables; perform operations with formulas and functions; create charts and objects, and create advanced charts and tables.
Questions
40-60
(per exam)
Duration
50 minutes
(per exam)
Passing Score
The passing score varies from exam to exam and is provided on the score report.
(scaled score)
Exam Fee
USD 100
(per exam)
Delivered by
Certiport
(in-person or online)
Question Format
The exam consists of performance based questions and is...
single/multiple choice, performance-based
Practice Tests
75 Practice Questions
(mapped to official exam objectives)
Certification
77-727-77-728
Microsoft credential
Ready to take the exam?
Add your official 77-727-77-728 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available
Exam voucher is sold separately and not included with standard course.
04 / FAQs
Questions before you start
What is the difference between exams 77-727 and 77-728? +
Both are separate Microsoft Office Specialist (MOS) exams conducted to validate your Excel 2016 skills. Exam 77-727 is the prerequisite for Exam 77-728 so you’ll need to pass both for this certification. While Exam 77-727 tests your basic Excel skills, Exam 77-728 demonstrates advanced Excel capabilities.
Who should take this course? +
This course is especially beneficial for those from the finance, accounting, marketing, or data science backgrounds who need to work with large datasets for performing in-depth analysis.
What is the format of the MOS Expert certification exams (77-727 and 77-728)? +
This exam has a performance based format with different types of questions including multiple-choice, multiple select, fill-in-the-blank, drag and drop, and matching.
Is this advanced Excel 2016 course worth it? +
Yes, it is definitely worth your time and investment if you want to learn advanced Excel skills and techniques to improve your productivity and efficiency in data analysis and reporting.
What is the duration for the exams 77-727 and 77-728? +
Exam 77-727 has a limit of 90 minutes whereas exam 77-728 has a time limit of 110 minutes.
What is the exam fee for MOS Excel 2016 Expert certification?+
The exam fee is $100.
What are the prerequisites for this exam?+
There are no technical pre-requisites for this certification exam.
What is the exam registration fee?+
USD 100
Where do I take the exam?+
What is the format of the exam?+
The exam consists of performance based questions and is conducted in a live or simulated environment. MOS 2013 presents the candidate with a project to build tasks and steps that build on each other.
How many questions are asked in the exam?+
The exam contains 40-60 questions.
What is the duration of the exam?+
50 minutes
What is the passing score?+
The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?+
Microsoft Office Specialist (MOS) exam retake policy
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
- If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
- A two-day waiting period will be imposed between each subsequent exam retake.
- There is no annual limit on the number of attempts on the same exam.
- If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification?+
For life
Where can I find more information about this exam?+
Learn Next Level Excel Skills
To perform data analysis, reporting, and business intelligence.
- 1 year of full access
- 50 LiveLab included
- Certificate of completion
No credit card required