MOS Excel Expert 2016 Microsoft Certification Exam 77-728

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.