77-728 Microsoft Excel 2016 Expert Certification
4.3 (360 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,707 students enrolled

77-728 Microsoft Excel 2016 Expert Certification

77-728 Microsoft Certified Excel Expert - includes lectures, test exercises and video solutions.
4.3 (360 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,707 students enrolled
Created by Dave Murphy
Last updated 7/2020
Current price: $125.99 Original price: $179.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 40 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be fully prepared to take the 77-728 MOS exam in Excel Expert
  • Be familiar with every aspect of the Objective domain for the 77-728 exam
  • Be expert in the advanced use of Microsoft Excel 2016
  • Be ready to pass the 77-728 exam
  • Some knowledge of Microsoft Excel 2016 is assumed. Access to a PC using Windows and a copy of Microsoft Excel 2016 is required.
  • Time to complete the lectures and exercises.

Some recent messages and reviews.....

From Amanda

"I studied Lynda and took the Excel Expert Exam and made a 389. I regrouped and bought Dave's study material, including the practice exams. I learned so much more material that wasn't covered on Lynda through Dave's videos. I took the exam three weeks after studying Dave's tutorials and passed the exam with a 795."

From Christie


Thanks for the great course! I easily passed the Excel Expert exam a couple weeks ago thanks to the materials covered in your course! The lectures were easy to understand and all of the content from your course very relevant in preparing for the exam.



From Aicha

" I just passed the test today with 769 !! :) Just can't be happier. The course is really well structured and helpful especially the exercises at the end of each objective !! Thanks Dave , You did a great Job"

From Branislav

"Very specific and targeted topics. I believe it a must for all who attempt the exam."

From Taylor

I can't post it here but I will show my badge earned in the facebook group. I've been studying for roughly a month, with basic data entry experience, and a BCIS course I took in highschool. Needless to say I wasn't very well versed in excel to begin with, and now im an Excel Expert. Im always skeptical about what I buy and strive to recommend as little as possible to friends and family through fear of worth. But this course here is incredible and I can't thank Dave enough for the time and effort he put into it. I'm a bit of a talker to, and Dave was able to get back to me with answers regarding questions I had about the Exam in a very timely manner. Regards, Taylor"

Become a Microsoft Certified Excel Expert

Our Students Understand Value

This course will prepare you to take the 77-728 Excel Expert certification exam from Microsoft. Every aspect of the 77-728 exam is covered in detail, together with exercises and solutions. Delivered by a University professor with many years experience in teaching Excel to undergraduate students, and who is also a Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will enhance your chances of obtaining this valuable qualification. Prove your skills by obtaining independent certification from Microsoft.

This certification is highly regarded by employers because it is independent proof that you have the skills to become productive straight away. That saves a lot of time and effort on the employers part and that value that very highly indeed! The messages and reviews speak for themselves. Our mission is to make you succeed in passing the 77-728. You can do it with our help!

Who this course is for:
  • Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2016.
  • Students who have abilities in Excel and want to achieve independent recognition for those abilities
  • Students who have passed the 77-727 Core Excel exam and want to progress to the next level
  • Experts in Excel who would like to get their expertise recognised officially
Course content
Expand all 75 lectures 09:06:39
+ Introduction
3 lectures 12:11

This lecture is extremely important because you need to understand what it is that you must know in order to pass the 77-728 exam. Make sure you print down the accompanying pdf file.

Preview 03:16
How is the exam be conducted and what will it be like?
+ 1.1 Manage Workbooks
6 lectures 32:51

This lecture describes how to create a workbook template.

1.1.1 Save a Workbook as a Template

If you are new to Macros in Excel then it would be best for you to review Lecture 2.3.4 first.

Having completed this lecture you should make sure you know how to copy a macro by using the file provided as a resource and copying the macro to a new workbook.

1.1.2 Copy Macros between Workbooks

Linking and consolidating workbooks

1.1.3 Reference Data in Another Workbook

Structured references are formulas which reference table names. 

1.1.4 Reference Data by using Structured References
1.1.5 Enable Macros in a Workbook

How to manage and display hidden Excel commands

1.1.6 Display Hidden Ribbon Tabs
+ 1.2 Manage Workbook Review
6 lectures 34:04
1.2.1 Restrict Editing

Essential methods for protecting worksheets

1.2.2 Protect a Worksheet

Describes the optional setting for Calculation of Formulas

1.2.3 Configure Formula Calculation Options

You can opt to protect just the structure of a workbook

1.2.4 Protect Workbook Structure

How to manage and track changes to shared workbooks

1.2.5 Manage Workbook Versions

Adding password protection at a number of levels can ensure the security of your workbooks

1.2.6 Encrypt a Workbook with a Password
+ Objective Domain 1 - Exercises & Solutions
1 lecture 22:22
Domain Objective 1: Manage Workbook Options and Settings - Exercises & Solutions
+ 2.1 Apply Custom Data Formats and Validation
3 lectures 34:47

Learn how to create custom formats. Quite a lot in this lecture. Use the Try It Yourself exercise to test your understanding.

2.1.1 Create Custom Number Formats
2.1.2 Populate Cells by using Advanced Fill Series Options
2.1.3 Configure Data Validation
+ 2.2 Apply Advanced Conditional Formatting and Filtering
3 lectures 12:28
2.2.1 Create Custom Conditional Formatting Rules
2.2.2 Create Conditional Formatting Rules that use Formulas
2.2.3 Manage Conditional Formatting Rules
+ 2.3 Create and Modify Custom Workbook Elements
8 lectures 01:07:40
2.3.1 Create Custom Colour Formats
2.3.2 Create and Modify Cell Styles
2.3.3 Create and Modify Custom Themes

Part I of the lecture on creating and modifying macros

2.3.4 (Part I) Create and Modify Simple Macros
2.3.4 (Part II) Create and Modify Simple Macros
2.3.5 (Part II) Insert and Configure Form Controls
2.3.5 (Part III) Insert and Configure Form Controls
+ 2.4 Prepare a Workbook for Internationalisation
2 lectures 13:20
2.4.1 and 2.4.2 Display Data in Multiple International Formats
2.4.3 Manage Multiple Options for +Body and +Heading Fonts
+ Domain Objective 2 - Exercises & Solutions
1 lecture 21:48
Domain Objective 2 Apply Custom Data Formats and Layouts - Exercises & Solutions
+ 3.1 Apply Functions in Formulas
3 lectures 17:21

Logical Functions of AND, OR and NOT

3.1.1 Perform Logical Operations by using AND, OR, and NOT Functions

Using Nested Functions to create complex formulas

3.1.2 Perform Logical Operations by using Nested Functions

SUMIF, AVERAGEIFS and COUNTIFS allow for powerful multi conditional formulas

3.1.3 Perform Statistical Operations by using SUMIFS, AVERAGEIFS, and COUNTIFS