MO-200 Excel Associate (Office 2019) Courses

77-727 Microsoft Excel Core

(Office 2016) Courses

What the 77-727 Exam Measures

This exam covers the ability to create and edit a workbook with multiple sheets and use graphic elements to represent data visually.

Candidates are expected to demonstrate the correct application of the principal features of Excel and complete tasks independently.

Requirements include the ability to utilize graphic elements to visually represent data, produce professional-quality documents such as budgets, financial statements, performance charts, invoices, and data-entry logs.

This exam measures the students competency in these fundamental areas of Excel 2016

Create and Manage Workbooks
Manage Data Cells and Ranges
Create and Manage Tables
Summarise Data and use Conditional Formatting
Create Charts and Objects

Click the button below to download the official 77-727 skills as measured by Microsoft in the exam.

Download 77-727 Skills Measured

MOS University Courses

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

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

The Practice Exams and Video Solutions course will ensure that you are familiar with the standard and style of the Project Tasks in the 77-727 Exam.

Be 100% Confident of Your Success at the 1st Attempt

77-727 Microsoft Excel Core (Office 2016) Complete Techniques

MO-200 Microsoft Excel Associate

(Office 2019)

Complete Techniques

Buy Complete Techniques - $47

Learning Objectives

	Be confident in your preparation to pass the 77-727 Microsoft Certified Excel 2016 Core Exam.
	Be secure in your skills in the use of Microsoft Excel 2016 for everyday Business Use.
	Understand the way that project tasks are posed in the 77-727 Certification exam.
	Obtain independent proof of your skills and ensure potential Employers of your competence in Microsoft Excel 2016.

Who Should Take These Courses?

	This course is suited to anyone wishing to pass the 77-727 Exam.
	The Course specifically includes lectures designed for Excel Beginners.
	Existing users of Excel who want to have access to the type of project tasks which will ensure they will pass the Microsoft Office Specialist Associate Certification in Excel 2016.
	Graduates seeking to gain professional qualifications.
	Intermediate users who want to obtain certification in Core Excel.

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-727 Microsoft Excel 2016 Complete Techniques Course Content

Introduction

Introduction - What is MOS Certification?
How the Exam is Conducted

Try It Yourself Exercises

Introducing the Excel User Interface

Excel User Interface

Essential Navigation Skills

Entering Information

Create and Manage Worksheets and Workbooks

Create Worksheets and Workbooks

Navigate in Worksheets and Workbooks

Format Worksheets and Workbooks

Customise Options and Views for Worksheets and Workbooks

Configure Worksheets and Workbooks for Distibution

Manage Data Cells and Ranges

Insert Data in Cells and Ranges
Format Cells and Ranges
Summarise and Organise Data

Create Tables

Create and Manage Tables

Manage Table Styles and Options
Filter and Sort a Table

Perform Operations with Formulas and Functions

Summairse Data by using Functions

Perform Conditional Operations by using Functions

Format and Modify Text by using Functions

Create Charts and Objects

Create Charts

Format Charts

Insert and Format Objects

Sample Course Videos

Import Data from Text Files in Excel 2016

Insert Sparklines in Excel 2016

Buy Complete Techniques- $47

77-727 Microsoft Excel 2016 Practice Exams and Video Solutions

Buy Practice Exams - $47

77-727 Practice Tests Learning Objectives

	Be confident in your preparation to pass the 77-727 Microsoft Certified Core Excel 2016 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?

	This course is best suited to students who feel that they're ready to sit the 77-727 exam and want to ensure they pass with the highest possible mark.
	Students who would like to test their capabilities in Excel before sitting the 77-727 Certification Exam.
	Test your knowledge and check your timing to ensure you ace the exam.

Buy Practice Exams - $47

77-727 Microsoft Excel 2016 Practice Tests

Course Introduction

Course Introduction - What is MOS Certification?
How the Exam is Conducted
Course Structure and the Best Approach to Completing the Practice Exams

77-727 - Practice Exam 1

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.

Project 1 - Pilots and Passengers Solution

Project 2 - Income Analysis Solution

Project 3 - Sales Analysis Solution

Project 4 - Pilot Performance Solution

Project 5 - Monthly Merchandise Solution

Project 6 - Training Sales Solution

77-727 - Practice Exam 2

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.

Project 1 - Marketing Plan Solution

Project 2 - Revenue & Maintenance Solution

Project 3 - Flights Solution

Project 4 - Monthly Revenue Solution

Project 5 - Staff Solution

Project 6 - Extended Flights Solution

Project 7 - Bands Solution

77-727 Practice Exam 3

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.

Project 1 - Income Analysis Solution

Project 2 - Sales Analysis Solution

Project 3 - Car Sales Solution

Project 4 - Warehouse Inventory Solution

Project 5 - Luggage Rules Solution

Project 6 - Project Tracker Solution

Project 7 - Expense Trends Budget Solution

Student Resources

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

Zipped Practice Exams
Zipped Student Resource Files

PDF of All Project Tasks

PDF of Microsoft Objective Domain

Sample Course Videos

Exam 1 Project 2 Solution

Exam 2 Project 5 Solution

Buy Practice Exams - $47

Special Offer: Two Course Bundle - $68

This bundle includes both the Complete Techniques and Practical Exams Courses

Buy Two Course Bundle - $68

Student Reviews

5 Star Review from BPMN 2.0 using Micosoft Visio student

77-727 Microsoft Core Excel 2016

Complete Techniques

I've been using Excel for work for years, but there are plenty of little things that I'd never heard of covered in this course which I'm finding useful already in my job.

This course explains the requirements of the Certification process very well and I'm expecting to get the exam first time.

There are techniques in the exam schedule which were completely new to me, but the video lectures explain everything really clearly.