Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Microsoft Certification

77-727 Microsoft Excel 2016 Core Certification

Microsoft Office Specialist - Become a Certified Microsoft Excel Specialist
Bestseller
Rating: 4.4 out of 54.4 (917 ratings)
3,442 students
Created by Dave Murphy, Ann Murphy
Last updated 3/2021
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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

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

Featured review

Farhad Hossain
Farhad Hossain
33 courses
11 reviews
Rating: 4.5 out of 54 months ago
Great course. Delivered exactly what it suppose to deliver, full syllabus training for the core excel exam. I did no give 5/5 because audio and video are not synchronized in many of the videos making it an inconvenience.

Course content

21 sections • 93 lectures • 6h 43m total length

  • What is Microsoft Office Specialist (MOS) Certification?
    Preview04:33
  • Understanding the Objective Domain
    Preview03:17
  • How is the exam be conducted and what will it be like?
    05:12
  • Try It Yourself Exercises
    01:18

  • Introducing the Excel User Interface
    08:42
  • Essential Navigation Skills
    09:31
  • Entering Information
    17:07

  • Course Exercise Workbook
    00:03
  • Student Files
    01:01

  • 1.1.1 Create a Workbook
    02:44
  • Preview05: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.1 & 1.2.2 Search & Navigate to a Named Cell, Range, or Workbook Element
    07:51
  • 1.2.2 Named Ranges
    04:25
  • 1.2.3 Insert and Remove hyperlinks
    03:57
  • Exercises Domain 1.2
    07:46

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

Instructors

Dave Murphy
University Lecturer
Dave Murphy
  • 4.5 Instructor Rating
  • 2,688 Reviews
  • 10,817 Students
  • 17 Courses

With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner.

Ann Murphy
University Lecturer
Ann Murphy
  • 4.5 Instructor Rating
  • 998 Reviews
  • 3,791 Students
  • 7 Courses

With over 25 years teaching at university level, Ann has been teaching Microsoft Office Applications to both undergraduate students and business clients for many years and has multiple MOS Certifications, in addition to being a MOS Examiner.

She has a 1st class Honors B.Sc. degree in Information Technology and a Postgraduate qualification in IT for Strategic Management.

Prior to her career as a University Lecturer, Ann owned her own consultancy company delivering business solutions and training to many varied clients.

She enjoys interacting with enthusiastic students and wants to bring her expertise to as many Udemy students as possible. 

This combination of experience from both a teaching and learning background makes Ann uniquely qualified to develop and deliver courses to Udemy students. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.