Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

77-727 Microsoft Excel 2016 Core Certification

Name: 77-727 Microsoft Excel 2016 Core Certification
Rating: 4.7 (1597 reviews)

Prepare with confidence for the 77-727! Includes complete exercise book, individual lecture exercises and practice exam!

Created byDave Murphy, Ann Murphy

Last updated 4/2023

English

English [Auto],

What you'll learn

How to successfully pass the 77-727 Microsoft Certified Exam in Core Excel and become a Microsoft Office Specialist
Be confident and competent in your use of Microsoft Excel for everyday business use
Be ready to begin to study to become a certified Microsoft Office Specialist
Guarantee potential Employers of your competence in Microsoft Excel

Course content

21 sections • 98 lectures • 7h 29m total length

Course Introduction4:44
Primarily for your convenience, we have provided a 'Course Exercise Book' which contains all of the course exercises in one place together with a zipped file containing all of the resource files required to complete the exercises, 'Student Resources for Course Exercise Book'. If you download the zip file and open it you will be able to save the resource files to a location of your choice.
Note however, that since all of the exercises, together with their required resources are also provided within the detail of each section of the course, there is no need to print down the complete book or unzip the resources should you prefer not to.
If you have any difficulty accessing the resources please let us know directly.
Note that if you are registered as a 'Udemy for Business' student make sure to check out our 77-727 Practice Exams and Video Solutions course which will provide you with additional practice opportunities.
How the exam is conducted5:55
Register with Certiport to take the 2016 Excel exam at an authorized center or remotely; the project-based test includes 5–7 projects and 35 tasks in 50 minutes, no multiple choice.
Try It Yourself Exercises1:18

Introducing the Excel User Interface8:42
Explore the Microsoft Excel user interface, including the ribbon, the file tab, and the quick access toolbar, and learn how to save work using save as and the save icon.
Essential Navigation Skills9:31
Entering Information17:07
This is an unusually long lecture so take it in small bit size pieces. I normally don't allow lectures to go beyond 5 minutes. I've designed it for beginners but there may be some techniques that you are unaware of, even if you are used to Excel.

1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, or Workbook Element7:51
1.2.2 Named Ranges4:25
1.2.3 Insert and Remove hyperlinks3:57
Discover how to insert and remove hyperlinks in Excel using the insert tab or right-click, linking to websites, files, or workbook locations, with screen tips and editing options.
Exercises Domain 1.27:46
Learn core Excel 2016 techniques in domain 1.2. Execute find and select, conditional formatting, comments, hyperlinks, data validation, go to special, and replace operations.

1.3.1 to 1.3.3 Changing Worksheet Characteristics2:11
1.3.4 Modify Page Setup6:33
1.3.5 Insert and Delete Columns or Rows (and Cells)5:08
Insert and delete rows, columns, and cells in worksheets using right-click or the home tab. See how these actions shift data and update formulas.
1.3.6 Change Workbook Themes1:54
Learn to change workbook themes in Excel by applying built-in or custom color and font themes via the page layout tab, with preview window and saved custom themes.
1.3.7 Adjust Row Height and Column Width2:50
1.3.8 Insert Headers and Footers5:27
Learn to insert headers and footers in Excel using the page layout tools, adding page numbers, date, and descriptive headings for a professional, per-sheet printout.
Exercises Domain 1.36:31
Apply formatting and layout techniques in Excel by adjusting themes, margins, headers and footers, page size and orientation, tab colors, and inserting columns with autofit to present data clearly.

1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows2:19
1.4.3 Customise the Quick Access Toolbar2:27
1.4.4 Change Workbook Views3:16
1.4.5 Change Window Views8:12
Explore the view tab and windows group to view multiple workbooks, arrange windows (tiled, horizontal, vertical, cascade), split panes, freeze top row or leftmost column, and hide or unhide worksheets.
1.4.6 Modify Document Properties2:28
Explore how Excel workbooks store metadata as document properties in the backstage dialog with five tabs, and customize the title, author, and custom properties to organize and sort workbooks.
1.4.7 Change Magnification by using Zoom Tools1:16
1.4.8 Display Formulas1:40
Exercises Domain 1.45:03
Explore essential Excel 2016 techniques like splitting and freezing panes, hiding and unhiding columns, page layout and page break preview, custom views, and adjusting document properties.

1.5.1. Set a Print Area1:12
1.5.2 Save Workbooks in Alternative File Formats2:21
1.5.3 Print All of Part of a Workbook1:23
1.5.4 Set Print Scaling3:31
Master print scaling in Excel by using scale to fit options to control pages wide and tall, including fit all columns, fit all rows, or a custom percentage.
1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets2:00
Configure print titles to repeat selected rows or columns on every page, using the page layout tab to ensure headers stay visible in printouts.
1.5.6 Inspect a Workbook for Hidden Properties or Personal Information2:16
1.5.7 Inspect a Workbook for Accessibility Issues3:40
Learn to inspect Excel workbooks for accessibility by adding alt text to images, using descriptive sheet names and headings, using range names and hyperlinks, and checking accessibility in backstage view.
1.5.8 Inspect a Workbook for Compatibility Issues2:48
Exercises 1.53:09

Seminar Series - Manage Worksheets & Workbooks31:05
This is a recording of the first in a series of 5 seminars aimed at preparing students for the Microsoft Excel Associate (MO-200) & Core (77-727) exams. Check out the Bonus Lecture (last section of the course) for details on the seminar series and how you can access all 5 seminars. In this seminar we focused on the Manage Worksheets & Workbooks section of the Skills Measured by Microsoft.

2.1.1 Replace Data3:01
2.1.2 Cut, Copy or Paste Data3:50
2.1.3 Paste Data by using Special Paste Options4:21
2.1.4 Fill Cells by using Auto Fill2:47
Learn to use autofill to complete months and years by recognizing patterns, drag the fill handle, and apply flash fill for names, with formulas replicated across cells.
2.1.5 Insert and Delete Cells1:19
Learn how inserting or deleting cells affects the worksheet in Excel 2016 by selecting a cell or range, then shifting cells and adding or removing rows or columns.
Exercises Domain 2.15:48
Format a monthly revenue worksheet by autofilling months, merging the title, using paste special values and transpose, and creating a named range monthly_revenue with sparkline and flash fill features.

2.2.1 Merge Cells2:02
See 2.2.4 for TIY Exercise.
2.2.2 Modify Cell Alignment and Indentation1:53
See 2.2.4 for TIY Exercise.
2.2.3 Format Cells by using Format Painter1:38
See 2.2.4 for TIY Exercise.
2.2.4 Wrap Text Within Cells1:16
2.2.5 Apply Number Formats6:59
Explore how to apply and preview Excel number formats to control the display of numbers, currency, accounting, dates, times, percentages, fractions, scientific, special, and custom formats.
2.2.6 Apply Cell Formats6:31
See 2.2.7 for TIY Exercise.
2.2.7 Apply Cell Styles2:17
Exercises Domain 2.27:07

Requirements

The only prerequisite is that you have access to Excel 2016 in a Windows environment and the willingness to complete the exercises and practice tests.
Please note that MOS exams are all Windows based. This course uses Excel in a Windows environment. Apple Mac users should note that there are differences between the Windows and Mac versions of Excel which are not covered in this course or in the exam.

Description

Important Note February 2026

Please note that the Microsoft Excel 2016 Certification exams will be discontinued in June 2026.
The Microsoft Office Specialist (MOS) 2016 certification exams, which include the 77-727 (Microsoft Excel 2016) exam, are scheduled to retire on June 30, 2026.

Key details regarding this retirement:

Availability: After June 30, 2026, the 77-727 exam will no longer be available for testing.
Replacement: Candidates are advised to transition to the Microsoft Office 2019 (MO-200) or Microsoft 365 Apps (MO-210) certification exams.
Context: This is part of a broader retirement of the MOS 2016 suite by Microsoft and Certiport.

It is highly recommended to complete this certification before this date if you are currently preparing for it.

New! Udemy for Business Students

Please note that our course entitled 77-727 Excel 2016 Core Practice Tests and Video Solutions is now available to supplement your learning path to success in the 77-727 Certification exam. This course has an additional two practice exams together with video solutions to allow you to ensure your certification at the first attempt. Just search for 77-727 and you should see it listed.

NEW! Complete 77-727 Practice Exam and Video Solutions Added (March 2023)

The course now includes a Practice Exam and Video Solution. The exam has 7 individual projects with 5 or 6 tasks per project. Video solutions are provided for every task. As MOS Examiners and University Lecturers we really know what is required to pass at the 1st attempt. These practice exam projects are set to the standard and style of the exam and will ensure that you are completely familiar with the style and terminology used in the actual 77-727 exam.

Reviews Update 1 - Student scores 1000/1000 in exam!

"I like having multiple project tasks to be able to complete/practice; with a good variety in questions. Its also extremely helpful to my learning to then to be able to watch the video solutions after. Update: I took the certification exam and scored 1000/1000!!! Using this course, I was completely prepared for the questions. Definitely recommend."

Reviews Update 2 - Student wins UK & Ireland MOS Excel Championship. Qualifies for World Championship!

One of our students has completed against 30,000 other competitors to win the UK & Ireland MOS Championship in Excel. She will now go on to compete in the World Championship in November. This is a major achievement and we are proud to have been part of this students preparation and success!

The above level of achievement doesn't happen without effort and the correct preparation. Our instructors REALLY know what is required if you are to succeed in your MOS exam at the 1st attempt. Don't risk your exam fees! MOS University will make sure that you have the best possible chance to obtain these valuable certifications. Our expert instructors are all MOS Masters and University Professors with many years experience in preparing students to take MOS exams. Up to date materials, expert tuition, focused exercises and sample exam questions will all ensure that your pathway to success is assured.

Microsoft Certification in Core Excel (MOS 77-727)

This course will prepare you for the Microsoft Office Specialist Exam 77-727. Developed by University Lecturers who are also MOS Masters, Microsoft Certified Professionals and MOS examiners, no course on Udemy or any other educational platform can surpass this content. With over 90 lectures covering every possible aspect of the 77-727 syllabus, you can be 100% certain that your knowledge of the skills required to succeed will be excellent. In addition to an explanation of every required certification technique, the course provides an overview of the exam, the objective requirements set by Microsoft, tips on how to prepare and what to expect on the day of the test. It includes a comprehensive bank of test exercises which reflect the style of questions asked in the 77-727 Microsoft Core Excel exam. Virtually every lecture has a special set of exercises called 'Try It Yourself' which allow you to make sure you've understood the techniques demonstrated in the lecture.

Become a Microsoft Office Specialist and Enhance Your Career

No prior knowledge required
Start from scratch and get Microsoft to certify your skills in this hugely important technical skill
Understand the requirements of the 77-727 Certification Exam
Learn how to correctly prepare for the test
Get advice from seasoned professionals who know how to pass the exam

Core Excel with the MOS 77-727 Exam

This course is suitable for people at all levels of proficiency in Microsoft Excel. If you are new to the subject, then the course will lead you step by step through every single technique which is tested in the 77-727 exam. If you are already proficient in the use of Excel to some extent, then this course will help you to understand what is required in order to obtain a valuable certification in the subject.

Every element of the objective domain (Microsoft Syllabus) for the 77-727 exam is comprehensively covered, together with exercises designed to ensure that you know the style and types of questions which you are required to answer in the exam.

When you pass the 77-727 exam, Microsoft issue you with the MOS, or Microsoft Office Specialist certification status, in core Excel. Obtaining this certification provides tangible evidence that you are proficient in your use of Microsoft Excel and your LinkedIn profile will be automatically adjusted by Microsoft to reflect this achievement.

If you follow and complete the course and exercises you will really optimise your chances of gaining that qualification, you will enhance your status in your existing job and boost your job prospects in the marketplace.

Content and Overview

Suitable for beginners or for anyone who has a reasonable knowledge of Microsoft Excel, this course is aimed at you obtaining certification status from Microsoft by passing the 77-727 exam. Rather than simply provide sample questions, the course explains how the exam is structured, the way that the questions should be approached and how to study successfully to pass. The course also includes invaluable advice on the best way to prepare and what to expect from the testing process.

Who this course is for:

Students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel
Existing users of Excel who want to learn how to pass the 77-727 exam and obtain official certification for their skills.
Existing users of Excel who want to have access to the type of exercises which will ensure they will pass the Microsoft Office Specialist certification in Core Excel 2016
Graduates seeking to gain professional qualifications

77-727 Microsoft Excel 2016 Core Certification

What you'll learn

Explore related topics

Course content

Course Introduction3 lectures • 12min

Introducing the Microsoft Excel User Interface3 lectures • 35min

1.1 Create Worksheets and Workbooks5 lectures • 21min

1.2 Navigate in Worksheets and Workbooks4 lectures • 24min

1.3 Format Worksheets and Workbooks7 lectures • 31min

1.4 Customise Options and Views for Worksheets and Workbooks8 lectures • 27min

1.5 Configure Worksheets and Workbooks for Distribution9 lectures • 22min

Manage Worksheets & Workbooks Exam Seminar1 lecture • 31min

2.1 Insert Data in Cells and Ranges6 lectures • 21min

2.2. Format Cells and Ranges8 lectures • 30min

Requirements

Description

Who this course is for: