MOS Excel Expert 2016 Microsoft Certification Exam 77-728

40 Lectures, 10 Projects, 52 Assignments with video solutions

4.70 (83 reviews)
Udemy
platform
English
language
Microsoft
category
726
students
5 hours
content
Mar 2021
last update
$89.99
regular price

What you will learn

By completion of the course, the students will be well prepared to take the MOS 77-728 exam

Description

----UPDATED January 2021----

Featured questions in the Q & A section of the course


---- UPDATED  June 2019 ----

Added additional project assignments


---- UPDATED March 2019 ----

Added additional assignments


The TEST4U MOS Excel Expert 2016 Microsoft Certification Exam 77-728 Course

The TEST4U team realized that there is a need for a complete hands-on Training system for the 77-728 exam, so we created the MOS Excel Expert 2016 Microsoft Certification Exam 77-728 course. It is targeted to people, who want to succeed in the 77-728 exam.


The Course at a glance

In this course you will find:

  • 52 assignments properly categorized

  • 52 distinct files for each of the above assignments

  • 52 solution videos for every assignment

  • 10 project questions similar to the ones you will face in the exam

  • 40 lectures explaining certain interesting subjects of the MOS 77-728 syllabus

  • 2 lectures explaining the examination process and the structure of the multi-project question



The Course in detail


52 assignments properly categorized

In this course you will practice on the following categories:

1. Manage Workbook Options and Settings

2. Apply Custom Data Formats and Layouts

3. Create Advanced Formulas

4. Create Advanced Charts and Tables

5. Financial Functions

6. Features present in Excel 2016 Pro

7. Projects


52 distinct files for each of the above assignments

Each and every assignment comes with its distinct file(s) that are necessary to answer the assignment


52 solution videos for every assignment

All assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.


10 project questions similar to the ones you will face in the exam

Since the release of Office 2016, Microsoft introduced a new kind of examination. This examination consists of multiple project questions. We have included 10 such project questions in this course


Fast feedback from our instructors

We give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.


Content

Introduction

How to submit an assignment

Manage Workbook Options and Settings

Copy Macros Between Workbooks
Protect a Worksheet

Apply Custom Data Formats and Layouts

Removing a custom number format
Apply Advanced Conditional Formatting using a formula
Work with Form Controls
Use the Accessibility Checker

Create Advanced Formulas

The SUMIFS Function
The AVERAGEIFS Function
The COUNTIFS Function
The INDEX Function
The MATCH Function
The OFFSET Function
The VLOOKUP Function
The HLOOKUP Function
Advanced Lookup Formulas I (VLOOKUP-MATCH, VLOOKUP-HLOOKUP)
Advanced Lookup Formulas II (OFFSET-MATCH-MATCH)
Advanced Lookup Formulas III (INDEX-MATCH, INDEX-MATCH-MATCH)
Goal Seek
The TRANSPOSE Function

Create Advanced Charts and Tables

Pivot Tables
Calculated Fields and Items
Pivot Charts
Slicers
CUBE Functions

Financial Functions

Introduction to Financial Functions
The Functions PMT, IPMT, PPMT
The Functions PV, FV, NPER, RATE
The Functions NPV, XNPV
The Functions IRR, MIRR, XIRR
The Functions DOLLARFR, DOLLARDE
The Functions YIELD, YIELDDISC, YIELDMAT
The Functions DISC, RECEIVED, INTRATE
The Functions PRICE, PRICEMAT, PRICEDISC
The Functions ACCRINT, ACCRINTM
The Functions COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
The Functions DURATION, MDURATION
The Functions SLN, SYD, DB, DDB, VDB
The Functions TBILLEQ, TBILLPRICE, TBILLYIELD

Features present in Excel 2016 Pro

Power Pivot
Power Pivot Hierarchies

Multi-Project Question (as seen in the exam)

MOS 2016 exam procedure
MOS 2016 Multi-project questions description

Multi-Project Question 2 (as seen in the exam)

Epilogue

What is TEST4U?
Epilogue
BONUS Content

Screenshots

MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Screenshot_01MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Screenshot_02MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Screenshot_03MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Screenshot_04

Reviews

Cole
October 5, 2022
Everything was ok with the course. Content, assignments and instructor responsiveness. I certainly feel comfortable purchasing from this instructor again.
Shem
November 20, 2021
Very good set of training & testing modules & questions..Definitely my skill level has gone up after taking this course..Thanks a lot.
Norman
January 30, 2021
It helped catch all those features I do not use but will likely be in the exam. Kudos on a job very well done.
Liby
January 22, 2021
I have relied on TEST4U in the past, and each time I realize the volume of the work that lies behind this automated (extra) software. The key for an effortless achievent lies there! Trust me and look no further, because there is no need.
Angela
December 15, 2020
I have been trying to gather useful information on how to prepare for the test and pass it the first time. There is plenty of uncategorized material out there, which means that you need to spend too much time assessing and categorizing, before you actually start training. And then what? How will you be sure that you have trained enough? Well, this is why you need to rely on a trusted source, such as this one, follow the curriculum and look no further. Recommended course.
Cindy
November 12, 2020
I have been using Excel for many years and I thought that preparing for a Certificate would be a piece of a cake. During this course I realized that there was a lot of things that I wasn’t aware of and that I had to gain more skills than I originally believed. Thankfully, the course included lots of training material in order to help someone be as prepares as supposed to.
Fred
November 11, 2020
Office 2016 and 2019 are practically the same, with minor changes. My exam would be on 2016, so I enrolled in this course to be able to practice on the same version and environment. Having taken the exam, I can confirm that the questions are of the same level of difficulty, and, in fact, very similar to the real ones, the interface is the same and the syllabus has been completely covered.
Gahee
April 7, 2020
i tried to redeem the serial code but it keeps saying that my name has not found in the database when i typed my name exactly the same in Udemy... also it took like solid 5 mins to finish searching. i do think this course is effective and i do wanna try but i need help.
Andrea
March 28, 2020
Initially I had issues accessing test4u but it was resolved. However I never figured out how to use test4u to do the assignments for this class. Test4u is really good and you can learn from hands on. I would say the course is worth just for that but much improvement is needed. Also we only get 5 hours on test4u with this course . I wish we got at least 3 times as much. Again test4u is a great tool to learn.
Alex
January 6, 2020
this course is very helpful for my studies for expert exam. I already know the material/objective domain of this exam, and I'm just using this course to prep for the exam, mainly practicing the test questions. The test4u app questions are of a proper level that this exam will have and the test4u qstns really allow you to target and master each concept. The questions are asked from various angles, which is preparing me more by helping me to improve my efficiency/speed/confidence.
Silvia
December 5, 2019
Really great deal for preparing the 77-728 MOS exam. You have several tests to practice on, a lot of video with theory and exercises explained, with instant feedback and 5 hours to spend on TEST4U Software to practice with even more tests. Highly recommended for passing the exam with a success.
Shana
January 27, 2019
Very short and hard to understand with the accent. Was expecting more in depth knowledge, not a brief overview that I could have picked up, free from YouTube etc.
Lee
August 31, 2018
Great course and great preparation for the exam. The lectures have Just enough content to cover the exam syllabus, and they don't get bogged down in excess detail. There could have been more content on cube functions, but the course creators have said they will add this to the course. There is plenty of chance to practice the skills the exams tests on and the companion software is very good preparation for the exam. There were a few teething problems in installing and using the companion testing software, but these were resolved helpfully with a genuine concern for quality and service.

Charts

Price

MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Price chart

Rating

MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Ratings chart

Enrollment distribution

MOS Excel Expert 2016 Microsoft Certification Exam 77-728 - Distribution chart
1781356
udemy ID
7/4/2018
course created date
7/1/2019
course indexed date
Bot
course submited by