77-727 Microsoft Excel 2016 Core Certification from Udemy

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.

What's inside

Learning objectives

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

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

Syllabus

Course Introduction

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.

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.

Learn how to create an Excel Workbook from a Template

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.

See 2.2.4 for TIY Exercise.

See 2.2.7 for TIY Exercise.

See 3.2.1 to 3.2.3 for TIY Exercises and Resources

See 3.3.4 for TIY Exercises and Resources

See 4.1.1 (Part 2) for TIY Exercises and Resources

See 4.1.3 to 4.1.5 for TIY Exercises and Resources

See 5.1.4 for TIY Exercises and Resources

See 5.2.3 & 5.2.4 for TIY Exercises and Resources

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Offers comprehensive coverage of the Microsoft Office Specialist (MOS) 77-727 exam objectives, ensuring learners are well-prepared for certification

Includes 'Try It Yourself' exercises in virtually every lecture, reinforcing learned techniques and solidifying understanding through hands-on practice

Instructors are MOS Masters and University Professors, providing expert tuition and up-to-date materials for exam preparation

Provides advice from seasoned professionals on how to approach the exam, prepare effectively, and understand the testing process

Includes practice exams and video solutions that mirror the style and standard of the actual 77-727 exam, familiarizing learners with exam format

Focuses on Microsoft Excel 2016, which may not be the most current version, so learners should verify its relevance to their needs

Reviews summary

Mos 77-727 excel 2016 core certification prep

According to learners, this course offers exemplary preparation for the Microsoft Office Specialist (MOS) 77-727 Excel 2016 Core Certification exam. Many students highlight the practical exercises and included practice exams with video solutions as particularly valuable for understanding the exam format and required skills. The course is generally found to be clear and easy to follow, making it suitable for students with varying levels of prior Excel experience. Learners feel it effectively builds confidence and provides skills relevant for professional and career development, making it a highly recommended resource for those aiming to get certified in Excel.

Appropriate for beginners and those with experience.

"Even with some prior Excel knowledge, I learned new techniques and solidified my understanding of exam objectives."

"I started as a beginner and the course guided me through all the necessary skills."

"It caters well to different proficiencies by covering basics and then going into more detail for certification."

"Useful for getting the certification regardless of your starting point."

Enhances overall Excel ability and career prospects.

"This course significantly boosted my confidence in using Excel for work tasks."

"I feel much more competent in Excel after taking this course."

"The certification proves proficiency and enhances my resume for job applications."

"Learning these core skills is directly applicable to my professional life."

Content is well-explained and easy to follow.

"The explanations are very clear and the pace is good, even for someone relatively new to Excel."

"Everything is explained in a step-by-step manner which is easy to grasp."

"I found the content logical and well-structured, building skills progressively."

"The lectures broke down complex topics into manageable parts."

Exercises and practice exams are highly useful.

"The Try It Yourself exercises are great for hands-on learning and reinforcing concepts."

"The practice exam included replicates the actual test environment very well."

"Video solutions for the practice exam tasks were incredibly helpful for understanding mistakes."

Specifically prepares learners for the MOS exam.

"I took the certification exam and scored 1000/1000. Using this course, I was completely prepared for the questions."

"This course is the perfect preparation for anyone looking to pass the 77-727 MOS Excel exam."

"It covers everything needed to pass the certification with flying colors."

"I feel confident going into the exam after completing this course and the practice tests."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in 77-727 Microsoft Excel 2016 Core Certification with these activities:

Review Excel Fundamentals

Show steps

Reinforce foundational Excel concepts to ensure a solid base for the course. This will help you grasp more advanced topics quickly.

Browse courses on Excel Fundamentals

Show steps

Review basic formulas and functions.
Practice data entry and formatting.
Familiarize yourself with the Excel interface.

Review: Microsoft Excel 2016 Step by Step

Show steps

Read this book to get a step-by-step introduction to Excel 2016. This will help you build a solid foundation and prepare for the certification exam.

View Microsoft Excel 2019 Step by Step on Amazon

Show steps

Read the introductory chapters on Excel basics.
Work through the exercises in each chapter.
Focus on chapters covering exam objectives.

Practice common Excel functions

Show steps

Practice using common Excel functions to improve proficiency. This will help you solve problems more efficiently during the course and exam.

Browse courses on SUM Function

Show steps

Complete practice exercises using SUM, AVERAGE, and IF functions.
Work through scenarios requiring COUNT and VLOOKUP functions.
Check your work against provided solutions.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Follow Excel Certification Tutorials

Show steps

Follow tutorials specifically designed for Excel certification to refine your skills. This will expose you to exam-style questions and efficient problem-solving techniques.

Show steps

Find tutorials covering the 77-727 exam objectives.
Work through the tutorials, pausing to practice each step.
Take notes on key concepts and shortcuts.

Create a Personal Budget Spreadsheet

Show steps

Create a personal budget spreadsheet to apply learned Excel skills in a practical context. This will reinforce your understanding of formulas, formatting, and data analysis.

Show steps

Gather your financial data (income, expenses).
Design a spreadsheet with categories for income and expenses.
Use formulas to calculate totals and track spending.
Format the spreadsheet for readability and clarity.

Automate a Task with Macros

Show steps

Start a project to automate a repetitive task using Excel macros. This will deepen your understanding of Excel's advanced features and improve your efficiency.

Show steps

Identify a repetitive task you perform in Excel.
Research how to automate the task using macros.
Record a macro or write VBA code to automate the task.
Test and refine the macro to ensure it works correctly.

Review: Excel 2016 Bible

Show steps

Reference this book to expand your knowledge of Excel 2016 beyond the core certification requirements. This will help you become a more proficient and versatile Excel user.

View Excel 2016 Bible on Amazon

Show steps

Browse the table of contents to identify relevant topics.
Read chapters on advanced functions and features.
Experiment with the techniques described in the book.

Career center

Learners who complete 77-727 Microsoft Excel 2016 Core Certification will develop knowledge and skills that may be useful to these careers:

Data Analyst

A data analyst uses software, including spreadsheets, to organize, analyze, and interpret data. This course provides a solid foundation in core Microsoft Excel functionality, which is essential for data manipulation, cleaning, and basic analysis tasks performed by data analysts. The course's comprehensive coverage of exam objectives will translate directly into practical skills for managing worksheets and workbooks, formatting data and using formulas to extract meaningful insight. The exercises and video solutions help build practical experience using these tools. Those wanting to become a data analyst should take this course to ensure they master the kind of hands-on spreadsheet work that is expected on the job.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial analysts rely heavily on spreadsheets for financial modeling, forecasting, and data analysis. The Microsoft Excel certification focus of this course is directly relevant because it develops crucial skills in data management, formula creation, and data presentation, all of which are essential in financial analysis. The course's approach, with its emphasis on practical exercises and exam-oriented content, helps build a robust skill set that a financial analyst would find valuable. The course includes a great deal of practice and covers many functions that a financial analyst would rely on. This is a great choice for aspiring financial analysts looking to hone their practical spreadsheet skills.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business analysts use data to identify business needs and recommend solutions, and Microsoft Excel is a primary tool for this. This course is excellent preparation because it teaches essential Excel skills including worksheet management, data summarization, and the use of functions. The course gives thorough training in these areas, which are critical to the day-to-day activities of a business analyst. Mastering the material can make a business analyst much more effective in their role. The focused nature of the course is a boon to individuals looking to make a career in business analysis, particularly those who are not yet proficient with spreadsheets.

See salaries and explore the career path for Business Analyst

Market Research Analyst

Market research analysts use data to analyze consumer behavior and market trends, using tools like spreadsheets to organize and interpret collected data. This course helps build the skills required for the job including data manipulation, formatting, and simple statistical analysis using Excel that a market research analyst will rely on. The emphasis on practical exercises throughout the course ensures those who enroll gain valuable experience using core excel functions. This course is a reliable starting point for anyone who wishes to pursue a career in market research.

See salaries and explore the career path for Market Research Analyst

Accountant

Accountants depend heavily on spreadsheets for tasks like tracking financial transactions, creating reports, and performing reconciliations. The focus of this course on core Microsoft Excel capabilities, including data management, formula use, and formatting, makes it very beneficial for accountants. The course's comprehensive material, practice exercises, and video solutions are designed to help students gain a mastery of the tools needed for accounting work. Those hoping to enter accounting will find that the course will help them build a solid foundation in the spreadsheet skills required for success in the field.

See salaries and explore the career path for Accountant

Project Coordinator

Project coordinators often use spreadsheets to manage project timelines, budgets, and resources. This course provides the necessary skills to handle data efficiently, create insightful reports, and organize project information using Microsoft Excel. The course is a great resource for project coordinators, focusing on the exam and its objectives ensures that learners gain a practical understanding of Excel's essential functions. A project coordinator should take this course to be more effective at the work, particularly if they want to rely more on spreadsheets in their work.

See salaries and explore the career path for Project Coordinator

Administrative Assistant

Administrative assistants frequently use spreadsheets for scheduling tasks, managing data, and creating basic reports. This course is useful for administrative assistants because it provides practical, hands-on training to enhance proficiency in Excel. The course's structured approach and focus on exam objectives ensure that those taking it will build valuable skills applicable to the administrative role, including formatting, data entry and basic summarization. The course is ideal for any administrative assistant who wants to develop spreadsheet skills.

See salaries and explore the career path for Administrative Assistant

Operations Analyst

Operations analysts use spreadsheets to analyze operational data, identify inefficiencies, and make data-driven recommendations. The Microsoft Excel instruction in this course is directly applicable to the work of an operations analyst. The course emphasizes practical, hands-on exercises and covers the skills necessary for data analysis, manipulation, and reporting. The course's content is directly applicable to the needs of operations analysts, and anyone who wants to pursue this career should consider it to bolster their spreadsheet skills.

See salaries and explore the career path for Operations Analyst

Sales Analyst

Sales analysts use spreadsheets to track sales data, analyze trends, and create reports. This course provides the foundation in Microsoft Excel to develop the skills needed to fulfill this role, including data formatting and analysis, along with creating effective reports. The course offers practical exercises and video solutions to build practical skills that translate directly to the work of a sales analyst. Those interested in becoming sales analysts will find that the course's structured content helps them gain core spreadsheet competencies.

See salaries and explore the career path for Sales Analyst

Office Manager

Office managers often use spreadsheets for various tasks such as budgeting, inventory management, and reporting. This course may be useful because it covers the core Microsoft Excel skills needed to perform these tasks effectively. The practical approach taken in the course ensures that a learner can quickly build the necessary skills, and the emphasis on exam prep ensures that a student works with concrete objectives in mind. This course may be helpful to anyone looking to become an office manager.

See salaries and explore the career path for Office Manager

Research Assistant

Research assistants often use spreadsheets to organize and manage data collected for research projects. Though a research assistant's work can vary widely, basic data analysis is often required. This course may be useful for individuals in this role, as it covers the fundamentals of spreadsheet software such as data manipulation and simple analysis using Excel. The course can benefit a research assistant who wants basic competencies in spreadsheet software. This course may be helpful to those who intend to become research assistants.

See salaries and explore the career path for Research Assistant

Teacher

Teachers in various subject areas may find value in using spreadsheet software to track student progress, record grades, create reports and perform other types of administrative tasks. A course like this may help them become proficient in some of these tasks. Though it is not central to the role, the content here could improve an educators' work. In addition, a teacher may find the content here useful as part of teaching technology in the classroom. This course may be helpful to teachers, particularly those looking for ways to incorporate technology more fully into their work.

See salaries and explore the career path for Teacher

Human Resources Assistant

Human resources assistants may use spreadsheets to track employee data, manage payroll information, or create basic reports for management. This course may be useful because it provides a foundation in Microsoft Excel that would allow a human resource assistant to work more effectively with spreadsheet software. While it is not central to their role, any improvement to their spreadsheet competence could be beneficial. This course may be helpful for a human resources assistant who wishes to improve their technical skills.

See salaries and explore the career path for Human Resources Assistant

Marketing Coordinator

Marketing coordinators may find spreadsheets helpful in organizing campaign data, tracking results, and creating reports. This course may be useful to those in the field as it provides practical training in Excel, which is often helpful for marketing. The course introduces fundamental skills that can benefit a marketing coordinator. This course may be helpful to any marketing coordinator who seeks basic proficiency in spreadsheet software.

See salaries and explore the career path for Marketing Coordinator

Staffing Coordinator

Staffing coordinators sometimes use spreadsheets to manage schedules, track worker availability, and maintain records. This course may be useful because it presents training in Microsoft Excel, and that training may be helpful to a staffing coordinator in the performance of their day-to-day duties. The course may assist a staffing coordinator in improving their ability to use spreadsheets, which is a useful skill to have. This course may be helpful for staffing coordinators who want to improve their technical skills.

See salaries and explore the career path for Staffing Coordinator

77-727 Microsoft Excel 2016 Core Certification

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Mos 77-727 excel 2016 core certification prep

Activities

Career center

Reading list

Share

Similar courses