77-727 Microsoft Excel 2016 Core Certification
4.4 (740 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,773 students enrolled

77-727 Microsoft Excel 2016 Core Certification

Microsoft Office Specialist - Become a Certified Microsoft Excel Specialist
4.4 (740 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,773 students enrolled
Last updated 7/2020
English [Auto]
Current price: $90.99 Original price: $129.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 2 articles
  • 19 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
  • The only prerequisite is that you have access to Excel and the willingness to complete the exercises and practice tests.

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

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
Course content
Expand all 93 lectures 06:44:23
+ Introduction
3 lectures 13:02

Explains what the Microsoft Office Specialist programme is and why it is an important certification.

Preview 04:33

Explains the Objective Domain for the exam, and why it is so important that you are familiar with it and use it to monitor your progress in the course.

Preview 03:17
How is the exam be conducted and what will it be like?
+ Introducing the Microsoft Excel User Interface
3 lectures 35:20
Introducing the Excel User Interface
Essential Navigation Skills

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.

Entering Information
+ Student Exercise Files
2 lectures 01:04
Course Exercise Workbook
Student Files
+ 1.1 Create Worksheets and Workbooks
5 lectures 20:39

Learn how to create an Excel Workbook from a Template

1.1.1 Create a Workbook
1.1.2 Importing Data from a Delimited Text File
1.1.3 Add a Worksheet to an Existing Workbook
1.1.4 Copy and Move a Worksheet
Exercises Domain 1.1
+ 1.2 Navigate in Worksheets and Workbooks
4 lectures 23:59
1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
1.2.3 Insert and Remove hyperlinks
Exercises Domain 1.2
+ 1.3 Format Worksheets and Workbooks
7 lectures 30:34
1.3.1 to 1.3.3 Changing Worksheet Characteristics
1.3.4 Modify Page Setup
1.3.5 Insert and Delete Columns or Rows (and Cells)
1.3.6 Change Workbook Themes
1.3.7 Adjust Row Height and Column Width
1.3.8 Insert Headers and Footers
Exercises Domain 1.3
+ 1.4 Customise Options and Views for Worksheets and Workbooks
8 lectures 26:41
1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
1.4.3 Customise the Quick Access Toolbar
1.4.4 Change Workbook Views
1.4.5 Change Window Views
1.4.6 Modify Document Properties
1.4.7 Change Magnification by using Zoom Tools
1.4.8 Display Formulas
Exercises Domain 1.4
+ 1.5 Configure Worksheets and Workbooks for Distribution
9 lectures 22:20
1.5.1. Set a Print Area
1.5.2 Save Workbooks in Alternative File Formats
1.5.3 Print All of Part of a Workbook
1.5.4 Set Print Scaling
1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
1.5.7 Inspect a Workbook for Accessibility Issues
1.5.8 Inspect a Workbook for Compatibility Issues
Exercises 1.5
+ 2.1 Insert Data in Cells and Ranges
6 lectures 21:06
2.1.1 Replace Data
2.1.2 Cut, Copy or Paste Data
2.1.3 Paste Data by using Special Paste Options
2.1.4 Fill Cells by using Auto Fill
2.1.5 Insert and Delete Cells
Exercises Domain 2.1
+ 2.2. Format Cells and Ranges
8 lectures 29:43
2.2.1 Merge Cells
2.2.2 Modify Cell Alignment and Indentation
2.2.3 Format Cells by using Format Painter
2.2.4 Wrap Text Within Cells
2.2.5 Apply Number Formats
2.2.6 Apply Cell Formats
2.2.7 Apply Cell Styles
Exercises Domain 2.2