77-728 Excel Expert (Office 2016) Courses

What the MOS 77-728 Exam Measures

The 77-728 MOS (Microsoft Office Specialist) Excel Expert 2016 exam measures advanced skills in using Microsoft Excel 2016. Specifically, this exam is designed to assess candidates' ability to create and manage advanced workbooks and worksheets, as well as their capability to apply advanced features and functions of Excel 2016.

Candidates are expected to demonstrate their ability to apply advanced features of Excel to various scenarios.

Workbook examples include protecting and sharing workbooks, enabling and copying macros, performing logical operations using advanced functions and managing pivot tables..

Preparing for the 77-728 exam requires you to delve into advanced Excel topics. This process of studying and practicing can significantly enhance your expertise in Excel.

This exam measures the students expertise in these advanced areas of Excel

Manage Workbooks Options and Settings
Apply Custom Data Formats and Layouts
Create Advanced Formulas and Functions
Create and Modify Advanced Charts, Pivot Tables and Pivot Charts
Protect and Secure Workbooks
Import and Export Data to and from different file formats

Click the button below to download the 77-728 skills as measured by Microsoft in the exam

Download 77-728 Skills Measured

MO-200 Excel Associate (Office 2019) Courses

MOS University Courses

MOS University provides two courses designed to prepare you for success in the MOS Excel Expert Certification exam.

The Complete Techniques course will ensure your competency in all of the techniques and skills measured by Microsoft in the 77-728 Exam.

The Practical Exams and Videos course will ensure that you are familiar with the standard and style of the Project Tasks in the 77-728 Exam.

Be 100% Confident Of Your Success at the 1st Attempt.

77-728 Microsoft Excel Expert (Office 2016) Complete Techniques

77-728

Microsoft Excel Expert

(Office 2016)

Complete Techniques

Buy Complete Techniques - $47

77-728 Learning Objectives

	Be confident in your preparation to pass the MO-201 Microsoft Certified Excel Expert (Office 2016) Exam.
	Be familiar with every aspect of the Objective Domain for the 77-728 Expert Exam.
	Understand the way that project tasks are posed in the 77-728 Certification exam.
	Obtain independent proof of your skills and ensure potential Employers of your expertise in the advanced feature of Microsoft Excel 2016.

Who Should Take These Courses?

	These courses are best suited to students who want to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel (Office 2016).
	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.

MO-200 Microsoft Excel 2019

Complete Techniques

MO-200 Microsoft Excel 2019

Practice Exams

Two Course Bundle: Complete Techniques and Practice Tests

MO-200 Course Details

MO-200 Microsoft Excel 2019

Complete Techniques for the MO-200 Associate Certificate Exam

Enrol Now

Why Study with MOS University

Catering to students at all levels, these courses cover every possible aspect of the Microsoft Excel 2016 Core syllabus.

Exam preparation online sessions exploring student questions.

Learn at your own pace and be assured of our support throughout.

These courses cover all of the essential Microsoft Excel 2019 Core techniques AND provide you with the opportunity to practice using practice quetions set to the style and standard of the actual test.

Comprehensive exercise pack with complete video solutions.

This course is guaranteed to teach you all the techniques required for the MO-200 exam AND prepare you for the requirements of the exam so that you can pass the exam on your first attempt.

'Try It Yourself' exercises with virtually all lectures will ensure your understanding as the course progresses.

Buy Complete Techniques- $47

77-728 Microsoft Excel (Office 2016) Complete Techniques Course Content

77-728 Microsoft Excel (Office 2016)

Complete Techniques

Course Content

Introduction

Course Introducton
How the Exam is Conducted

ry It Yourself (TIY) Exercises

Manage Workbook Options and Settings

Manage Workbooks

Manage Workbook Review

Apply Custom Data Formats and Layouts

Apply Custom Data Formats and Validation

Apply Advanced Conditional Formatting and Filtering

Create and Modify Custom Workbook Elements

Prepare a Workbook for Internationalization

Create Advanced Formulas

Apply Functions in Formulas

Look up Data by using Functions

Apply Advanced Date and Time Functions

Troubleshoot Formulas

Define Named Ranges and Objects

Create Advanced Charts and Tables

Create Advanced Charts

Create and Manage Pivot Tables

Create and Manage Pivot Charts

Sample Course Videos

Formula Calculation Options (Excel 2016)

Conditional Formatting Rules (Excel 2016)

Buy Complete Techniques - $47

77-728 Microsoft Excel Expert (Office 2016) Practice Exams and Video Solutions

77-728

Microsoft Excel Expert

(Office 2016)

Practice Exams and Video Solutions

77-728 Practice Tests Learning Objectives

	Be confident in your preparation to pass the 77-728 Microsoft Certified Excel 2016 Expert Exam.

	Reduce exam anxiety by testing yourself in all aspects of the exam.

	Find out any areas of weakness and learn from the Solution Videos.
	Ensure that You can complete the Exam in the time required.

Are You Ready to Take these Tests?

	Students preparing for the Microsoft Certification Excel Expert (Office 2016) 77-728 Exam.
	Students who want to experience the level of the 77-728 exam standard questions.
	Students who would like to test their capabilities in Excel before sitting the 77-728 Certification Exam.
	Test your knowledge and check your timing to ensure you ace the exam.

Buy Practice Exams - $47

77-728 Microsoft Excel (Office 2016) Practice Tests

77-728

Microsoft Excel

(Office 2016)

Practice Tests

Course Introduction

Course Introduction
Course Structure and the Best Approach to Completing the Practice Exams

Special Exam Considerations

How is the Exam Conducted and What will It be Like?

77-728 Practice Exam 1 - Helpless Airlines

The Solutions for each project are available - remember to try the projects yourself before looking at the solutions.

The project test files are available as a downloadable file.

Exam 1 Project 1 Pilot and Passengers Solution

Exam 1 Project 2 Income Analysis Solution Solution

Exam 1 Project 3 Sales Analysis Solution

Exam 1 Project 4 Pilot Performance Solution

Exam 1 Project 5 Monthly Merchandise Solution

77-728 Practice Exam 2 - Event Management

The Solutions for each project are available - remember to try the projects yourself before looking at the solutions.The project test files are available as a downloadable file.

Exam 2 Project 1 Event Details Solution

Exam 2 Project 2 Advertising Budgets Solution

Exam 2 Project 3 Event Planner Solution

Exam 2 Project 4 Manager Performance Solution

Exam 2 Project 5 Equipment Solution

77-728 Practice Exam 3 - Multiple Disciplines

The Solutions for each project are available - remember to try the projects yourself before looking at the solutions.

The project test files are available as a downloadable file.

Exam 3 Project 1 Aircraft Parts Solution

Exam 3 Project 2 Allied Mortgage Lenders Solution

Exam 3 Project 3 Concert Merchandise Solution

Exam 3 Project 4 Mobile Homes Business Solution

Exam 3 Project 5 Monogram Watch Company Solution

Exam 3 Project 6 Staff Profiles Solution

CUBE Functions - Special Questions

CUBE Functions Questions

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

Zipped Version of Project Files

If you wish to download all the Course Files together, the following files are included:

Zipped Student Resource Files

Sample Course Videos

Exam 1 Project 4 Solution

Exam 3 Project 2 Solution

Buy Practice Exams - $47

Special Offer: Two Course Bundle - $68

This bundle includes both the Complete Techniques and Practical Exams Courses

Buy Excel Expert Bundle - $68

Student Reviews

5 Star Review from BPMN 2.0 using Micosoft Visio student

77-728 Microsoft Excel Expert (Office 2016)

The lectures were well presented and easy to follow. I enjoyed the pace of the course and loved the ability to be able to keep reviewing topics until I understood what was being taught.

Practice is key to understanding the various features and functions in Excel and this course provides plenty of examples and exercises to work with.

The exercises and video solutions at the end of each domain were very helpful for evaluating progress.

I would highly recommend this course to anyone considering doing the 77-728 exam.

77-728 Microsoft Excel Expert

(Office 2016)

Practical Exams and Video Solutions

Simply brilliant.....this course made the difference.

After two attempts and failure, I bought this course.

This course is a MUST for anyone taking the 77-728 exam. It's a tough test and this course will make all of the difference between success and failure.