Excel 2016 (MOS) 77-727 Exam from Udemy

What's inside

Learning objectives

How to successfully pass the 77-727 microsoft certified exam in core excel and become a microsoft office specialist
The language used on the exam and how to spot keywords

A variety of industry-standard excel skills
How to complete tasks correctly and efficiently during a timed exam

How to successfully pass the 77-727 microsoft certified exam in core excel and become a microsoft office specialist
The language used on the exam and how to spot keywords
A variety of industry-standard excel skills
How to complete tasks correctly and efficiently during a timed exam

Syllabus

Introduction

Assignment: Introduce Yourself!

Exam Skills Overview

Excel Personality Assignment

Students will be able to: Insert text from other files and Format both worksheets and workbooks in Excel

Create and Manage Worksheets and Workbooks Tutorial

Project 1 Tutorial

Project 2 Tutorial

Students will be able to summarize data, format cells and ranges, and also insert data by the end of this section.

Manage Data in Cells and Ranges

Project 3 Tutorial

Students will be able to create and manage table styles and options. As well as how to sort and filter table data.

Create and Manage Tables Tutorial

Project 4 Tutorial

Students will be able to summarize data by using functions, perform conditional operations with functions, and use text functions.

Perform Operations and Functions Tutorial

Text Functions

Functions that summarize data

Conditional Functions

UPDATE: New Functions!

Students will be able to create and edit charts, format graphic elements, and insert and format objects,

Charts and Objects Tutorial

Charts and Objects Project Solution

UPDATE: New Chart Tasks

To complete a practice exam that is similar to the real Excel 77-727 exam.

UPDATE: New Practice Exam!

This final tutorial will give you a preview of some of the tasks you will be asked to demonstrate. There are 7 projects in all!

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Prepares learners to pass the Microsoft Office Specialist (MOS) Excel 2016 exam, demonstrating proficiency in a widely used software

Includes a practice exam that simulates the real Excel 77-727 exam, allowing learners to assess their readiness and identify areas for improvement

Covers managing worksheets and workbooks, formatting, charts, images, functions, formulas, operations, and tables, which are all core skills assessed in the MOS Excel exam

Focuses on skills relevant to passing the exam, which helps learners efficiently prepare without extraneous information

Uses Excel 2016, which may be an older version of the software, so learners should verify if this version aligns with their needs and certification goals

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 Excel 2016 (MOS) 77-727 Exam with these activities:

Review Basic Excel Functions

Show steps

Refresh your understanding of basic Excel functions to build a solid foundation for more complex operations covered in the course.

Browse courses on SUM Function

Show steps

Identify the most common Excel functions.
Practice using these functions with sample data.
Review the syntax and purpose of each function.

Review 'Microsoft Excel 2016 Step by Step'

Show steps

Supplement your learning with a structured guide to Excel 2016, reinforcing key concepts and skills.

View Microsoft Excel 2019 Step by Step on Amazon

Show steps

Read the chapters relevant to the course syllabus.
Complete the practice exercises in the book.
Review the key concepts and techniques covered.

Practice Formatting Worksheets

Show steps

Reinforce your ability to format worksheets efficiently, a key skill for the MOS exam.

Show steps

Create a worksheet with sample data.
Apply various formatting options to the worksheet.
Repeat with different datasets and formatting challenges.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Review 'Excel Formulas and Functions'

Show steps

Enhance your understanding of Excel formulas and functions, a critical component of the MOS exam.

View Microsoft Excel Formulas and Functions (Office... on Amazon

Show steps

Read the chapters on functions covered in the course.
Practice using the functions with different datasets.
Experiment with combining functions to create complex formulas.

Create a Cheat Sheet of Excel Functions

Show steps

Solidify your knowledge of Excel functions by creating a cheat sheet for quick reference.

Show steps

Compile a list of essential Excel functions.
Write a brief description of each function's purpose.
Include examples of how to use each function.
Organize the cheat sheet for easy navigation.

Explore Advanced Charting Techniques

Show steps

Deepen your understanding of Excel charts by following tutorials on advanced charting techniques.

Show steps

Find tutorials on creating specific chart types.
Follow the tutorials to create the charts.
Experiment with different chart options and settings.

Build a Dynamic Dashboard

Show steps

Apply your Excel skills to create a dynamic dashboard that visualizes and summarizes data effectively.

Show steps

Gather relevant data for the dashboard.
Design the layout and structure of the dashboard.
Create charts and tables to visualize the data.
Implement interactive elements, such as filters and slicers.

Career center

Learners who complete Excel 2016 (MOS) 77-727 Exam will develop knowledge and skills that may be useful to these careers:

Data Analyst

A data analyst works with large datasets to identify trends, create reports, and provide insights. This role uses tools like Excel to perform calculations, create visualizations, and present findings. This course will help build a foundation for many of the practical skills that a data analyst would use in their daily work. For example, the course covers Excel functions, formulas, operations, and tables. A prospective data analyst will be well served by their training for the 77-727 Microsoft Certified Exam in Core Excel.

See salaries and explore the career path for Data Analyst

Accountant

An accountant is responsible for managing financial records and ensuring accuracy. They use tools like Excel to organize, analyze, and report financial data. This course helps build a foundation in practical Excel skills such as formatting worksheets, working with functions and formulas, and creating tables. The skills learned in the course will be directly applicable to many of the tasks that an accountant completes such as tracking expenses, building budgets, and generating financial reports. The Microsoft Office Specialist certification shows an employer you have real-world competency.

See salaries and explore the career path for Accountant

Business Analyst

Business analysts work to improve processes and efficiency of a business by leveraging data. They are responsible for gathering data, analyzing business requirements, and developing solutions. This career often requires strong skills in data analysis, which is why Excel is a commonly used tool. The work in this course, including managing worksheets, formatting data, and using functions and formulas, is directly applicable to many of the daily tasks that a business analyst would perform. Preparing for the MOS Excel exam will enhance the knowledge base of a business analyst.

See salaries and explore the career path for Business Analyst

Budget Analyst

A budget analyst is responsible for developing and managing budgets. They prepare reports for organizations to improve financial planning. Excel is a common tool in financial modeling and budget development. The Excel training provided in this course will be helpful for a budget analyst. The skills taught including calculations, worksheets, workbooks, and tables will be directly applicable to this role. The Microsoft Office Specialist certification helps demonstrate knowledge.

See salaries and explore the career path for Budget Analyst

Operations Analyst

An operations analyst assesses business operations, identifies areas for improvement, and suggests solutions. Often, these professionals analyze large data sets in Excel. This course is helpful to build Excel skills necessary to succeed as an operations analyst. Working with Excel worksheets, functions, formulas and performing data operations are valuable skills. The course teaches how to create and manage tables that may also be useful.

See salaries and explore the career path for Operations Analyst

Financial Analyst

A financial analyst assesses financial data to advise on investments, budgeting, and financial planning. Excel is a vital tool for financial analysts to build models, track data, and create reports. This course may be helpful for building skills in Excel such as worksheet management, data formatting, and using functions and formulas. The Microsoft Certified Exam in Core Excel training included in this course will demonstrate to employers that you have a solid foundation.

See salaries and explore the career path for Financial Analyst

Sales Analyst

A sales analyst examines sales data to identify trends, assess performance, and inform strategic decisions. Excel is a tool used in this role to organize sales figures, create reports, and build visualizations. This course may be helpful in developing Excel skills necessary for sales analysis, such as data formatting, creating tables, and using formulas. The practice exam included in this course can be a good way to assess Excel skills.

See salaries and explore the career path for Sales Analyst

Market Research Analyst

A market research analyst studies consumer behavior to advise businesses on product development, marketing strategies, and pricing. This role involves analyzing large datasets using software like Excel. This course may help a market research analyst by building proficiency in Excel functions, tables, and data manipulation. The practice exam included in this course may be particularly useful for preparing for the kinds of data analysis they would have to do in this role.

See salaries and explore the career path for Market Research Analyst

Project Analyst

A project analyst assists project managers in planning, coordinating, and executing projects. This role often uses Excel to track timelines, manage budgets, and generate reports. This course may be helpful by developing Excel skills useful for a project analyst. The work in this course will help build a project analyst's ability to manage data better. The MOS certification training may also come in handy.

See salaries and explore the career path for Project Analyst

Inventory Specialist

An inventory specialist manages the stock of goods and materials. They use tools like Excel to track inventory, analyze trends, and maintain accurate records. This course may provide a foundation in the use of Excel. The training in worksheets, tables, and data management may be helpful for an inventory specialist. The Microsoft Office Specialist certification in core Excel shows a level of competence that will make a candidate stand out.

See salaries and explore the career path for Inventory Specialist

Administrative Assistant

An administrative assistant provides support to an office by managing records, organizing data, and assisting in report generation. Excel is commonly used to manage data and generate reports. This course helps build a strong foundation in the use of Excel. The training in managing worksheets, formatting data, and using basic functions and formulas makes this a good starting point for an administrative assistant. The MOS Excel exam preparation is great for improving daily productivity.

See salaries and explore the career path for Administrative Assistant

Research Assistant

A research assistant supports research projects by collecting, organizing, and analyzing data. Excel is a tool frequently used by research assistants for data entry, cleaning, and basic statistical analysis. This course will help build a solid foundation in Excel. The material on worksheets, data formatting, and using functions will be useful in daily tasks. Skills learned in this course will be directly applicable to the work of a research assistant who uses Excel.

See salaries and explore the career path for Research Assistant

Project Coordinator

A project coordinator assists project managers by tracking project timelines, resources, and budgets. They may use Excel to input, organize, and analyze project data. This course may be useful by developing data management skills. The ability to format worksheets, create tables, and use basic functions in Excel may be valuable to these project management professionals. The training in this course for the MOS Excel exam will instill a deeper understanding of the software.

See salaries and explore the career path for Project Coordinator

Logistics Coordinator

A logistics coordinator manages the flow of goods and materials. This role often involves using Excel to track inventory, manage shipments, and create reports. This course can provide the Excel skills needed to succeed in this role, such as creating tables, using functions, and manipulating data. The practice tests in this course may be helpful in building more confidence with Excel.

See salaries and explore the career path for Logistics Coordinator

Statistician

A statistician collects, analyzes, and interprets data to solve problems and provide insights to organizations. Statisticians often use Excel for statistical analysis. This course may provide a helpful foundation in using functions in Excel. The material on working with worksheets and workbooks also is helpful for a statistician. While a statistician may often use other, more sophisticated software packages, proficiency in Excel helps build a foundation for data analysis.

See salaries and explore the career path for Statistician

Excel 2016 (MOS) 77-727 Exam

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses