77-728 Complete Techniques for the MOS Excel Expert Exam
4.2 (309 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,569 students enrolled

77-728 Complete Techniques for the MOS Excel Expert Exam

77-728 Microsoft Certified Excel Expert - includes lectures, test exercises and video solutions.
Bestseller
4.2 (310 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,569 students enrolled
Created by Dave Murphy
Last updated 3/2020
English
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
  • 31 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
Requirements
  • 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.
Description

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

"Dave,

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.

Cheers!

Christie"

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 76 lectures 09:04:01
+ 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?
06:06
+ 1.1 Manage Workbooks
5 lectures 25:32

This lecture describes how to create a workbook template.

1.1.1 Save a Workbook as a Template
03:00

Review 2.3.4 before this lecture

1.1.2 Copy Macros between Workbooks
04:01

Linking and consolidating workbooks

1.1.3 Reference Data in Another Workbook
08:08

Structured references are formulas which reference table names. 

1.1.4 Reference Data by using Structured References
08:26

How to manage and display hidden Excel commands

1.1.6 Display Hidden Ribbon Tabs
01:57
+ 1.2 Manage Workbook Review
6 lectures 30:03

How to define and manage Shared Workbooks

1.2.1 Restrict Editing
07:24

Essential methods for protecting worksheets

1.2.2 Protect a Worksheet
10:04

Describes the optional setting for Calculation of Formulas

1.2.3 Configure Formula Calculation Options
02:33

You can opt to protect just the structure of a workbook

1.2.4 Protect Workbook Structure
01:14

How to manage and track changes to shared workbooks

1.2.5 Manage Workbook Versions
06:12

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

1.2.6 Encrypt a Workbook with a Password
02:36
+ Objective Domain 1 - Exercises & Solutions
1 lecture 22:22
Domain Objective 1: Manage Workbook Options and Settings - Exercises & Solutions
22:22
+ 2.1 Apply Custom Data Formats and Validation
5 lectures 43:29
2.1.1 (Part I) Create Custom Number Formats
07:12
2.1.1 (Part II) Create Custom Number Formats
08:54
2.1.2 Populate Cells by using Advanced Fill Series Options
10:50
2.1.2 (Part II) Issues with AutoFill using Dates
06:26
2.1.3 Configure Data Validation
10:07
+ 2.2 Apply Advanced Conditional Formatting and Filtering
3 lectures 12:28
2.2.1 Create Custom Conditional Formatting Rules
05:09
2.2.2 Create Conditional Formatting Rules that use Formulas
03:23
2.2.3 Manage Conditional Formatting Rules
03:56
+ 2.3 Create and Modify Custom Workbook Elements
8 lectures 01:07:40
2.3.1 Create Custom Colour Formats
03:15
2.3.2 Create and Modify Cell Styles
08:44
2.3.3 Create and Modify Custom Themes
07:54

Part I of the lecture on creating and modifying macros

2.3.4 (Part I) Create and Modify Simple Macros
06:49
2.3.4 (Part II) Create and Modify Simple Macros
08:15
2.3.5 (Part II) Insert and Configure Form Controls
12:20
2.3.5 (Part III) Insert and Configure Form Controls
08:22
+ 2.4 Prepare a Workbook for Internationalisation
2 lectures 13:20
2.4.1 and 2.4.2 Display Data in Multiple International Formats
10:33
2.4.3 Manage Multiple Options for +Body and +Heading Fonts
02:47
+ Domain Objective 2 - Exercises & Solutions
1 lecture 21:48
Domain Objective 2 Apply Custom Data Formats and Layouts - Exercises & Solutions
21:48
+ 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
05:55

Using Nested Functions to create complex formulas

3.1.2 Perform Logical Operations by using Nested Functions
06:44

SUMIF, AVERAGEIFS and COUNTIFS allow for powerful multi conditional formulas

3.1.3 Perform Statistical Operations by using SUMIFS, AVERAGEIFS, and COUNTIFS
04:42