MOS Excel Expert 2016 Microsoft Certification Exam 77-728

  • Overview
  • Curriculum
  • Instructor
  • Review

About This Course

40 Lectures, 10 Projects, 52 Assignments with video solutions

----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.


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

Course Curriculum

1 Lectures

1 Lectures

1 Lectures

Instructor

Profile photo of TEST4U Testing, Training, Evaluation Platform
TEST4U Testing, Training, Evaluation Platform

TEST4U is a Testing, Training and Assessment platform, where the user is assessed by performing Real Working Conditions tasks.   Training with TEST4U is interactive, which ensures the best possible result, with the least possible effort. The way TEST4U works is by cooperating with the actual, installed applications. In simple words, it sets the conditions for training on in-application (or Live-in-the-App)...

Review
4.9 course rating
4K ratings
ui-avatar of Sharon Fitzgerald
Sharon F.
5.0
1 year ago

All concepts are well explained: the instructor offers related exercises for reinforcement, then demonstrates the outcome of the example.

  • Helpful
  • Not helpful
ui-avatar of Cole Sprous
Cole S.
5.0
2 years ago

Everything was ok with the course. Content, assignments and instructor responsiveness. I certainly feel comfortable purchasing from this instructor again.

  • Helpful
  • Not helpful
ui-avatar of MIGUEL ANGEL RAMIREZ MUÑOZ
Miguel A. R. M.
5.0
3 years ago

Excelente curso

  • Helpful
  • Not helpful
ui-avatar of Nikos Gonis
Nikos G.
5.0
3 years ago

Excellent course, very helpful exercises in order to prepare you for the exams. Thank you!

  • Helpful
  • Not helpful
ui-avatar of Shem Vijay Kumar
Shem V. K.
5.0
3 years ago

Very good set of training & testing modules & questions..Definitely my skill level has gone up after taking this course..Thanks a lot.

  • Helpful
  • Not helpful
ui-avatar of Payam Sarwar
Payam S.
5.0
4 years ago

This course covered all the important aspects required to accomplish MOS excel expert 2016 exam

  • Helpful
  • Not helpful
ui-avatar of Norman Monteiro
Norman M.
5.0
4 years ago

It helped catch all those features I do not use but will likely be in the exam. Kudos on a job very well done.

  • Helpful
  • Not helpful
ui-avatar of Liby Brooks
Liby B.
5.0
4 years ago

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.

  • Helpful
  • Not helpful
ui-avatar of Angela Giuffrida
Angela G.
5.0
4 years ago

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.

  • Helpful
  • Not helpful
ui-avatar of Cindy Cain
Cindy C.
5.0
4 years ago

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.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses