77-727 Microsoft Excel Certification - MOS Excel Core Exam
4.3 (621 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,461 students enrolled

77-727 Microsoft Excel Certification - MOS Excel Core Exam

Microsoft Office Specialist - Become a Certified Microsoft Excel Specialist
Bestseller
4.3 (621 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,459 students enrolled
Last updated 2/2020
English
English [Auto-generated]
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
  • 1 article
  • 18 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
Requirements
  • The only prerequisite is that you have access to Excel and the willingness to complete the exercises and practice tests.
Description

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:42:40
+ 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?
05:12
+ Introducing the Microsoft Excel User Interface
3 lectures 35:20
Introducing the Excel User Interface
08:42
Essential Navigation Skills
09:31

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
17:07
+ 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
02:44
1.1.2 Importing Data from a Delimited Text File
05:03
1.1.3 Add a Worksheet to an Existing Workbook
02:00
1.1.4 Copy and Move a Worksheet
02:59
Exercises Domain 1.1
07:53
+ 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
07:51
1.2.3 Insert and Remove hyperlinks
03:57
Exercises Domain 1.2
07:46
+ 1.3 Format Worksheets and Workbooks
7 lectures 30:34
1.3.1 to 1.3.3 Changing Worksheet Characteristics
02:11
1.3.4 Modify Page Setup
06:33
1.3.5 Insert and Delete Columns or Rows (and Cells)
05:08
1.3.6 Change Workbook Themes
01:54
1.3.7 Adjust Row Height and Column Width
02:50
1.3.8 Insert Headers and Footers
05:27
Exercises Domain 1.3
06:31
+ 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
02:19
1.4.3 Customise the Quick Access Toolbar
02:27
1.4.4 Change Workbook Views
03:16
1.4.5 Change Window Views
08:12
1.4.6 Modify Document Properties
02:28
1.4.7 Change Magnification by using Zoom Tools
01:16
1.4.8 Display Formulas
01:40
Exercises Domain 1.4
05:03
+ 1.5 Configure Worksheets and Workbooks for Distribution
9 lectures 22:20
1.5.1. Set a Print Area
01:12
1.5.2 Save Workbooks in Alternative File Formats
02:21
1.5.3 Print All of Part of a Workbook
01:23
1.5.4 Set Print Scaling
03:31
1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
02:00
1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
02:16
1.5.7 Inspect a Workbook for Accessibility Issues
03:40
1.5.8 Inspect a Workbook for Compatibility Issues
02:48
Exercises 1.5
03:09
+ 2.1 Insert Data in Cells and Ranges
6 lectures 21:06
2.1.1 Replace Data
03:01
2.1.2 Cut, Copy or Paste Data
03:50
2.1.3 Paste Data by using Special Paste Options
04:21
2.1.4 Fill Cells by using Auto Fill
02:47
2.1.5 Insert and Delete Cells
01:19
Exercises Domain 2.1
05:48
+ 2.2. Format Cells and Ranges
8 lectures 29:43
2.2.1 Merge Cells
02:02
2.2.2 Modify Cell Alignment and Indentation
01:53
2.2.3 Format Cells by using Format Painter
01:38
2.2.4 Wrap Text Within Cells
01:16
2.2.5 Apply Number Formats
06:59
2.2.6 Apply Cell Formats
06:31
2.2.7 Apply Cell Styles
02:17
Exercises Domain 2.2
07:07