What you'll learn

Manage Worksheets and Workbooks
Manage Data Cells and Ranges
Manage Charts, Tables and Table Data
Perform Operations by Using Formulas and Functions
Prepare for the Microsoft MO-210 Exam

Requirements

Suitable for complete beginners. Download Excel and get started today!
Access to a home computer and internet connection.

Description

Prepare for the MO-210 certification exam by configuring and troubleshooting the most popular Excel tools and features. These real-world labs will prepare you for the hands-on exam and the real-world use of Excel in your company.This exam is aimed at getting beginners up to intermediate-level Excel users. Passing it will earn you the coveted Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.This course assumes no knowledge at all. We even show you how to access Excel for the first time if you have never used it. Labs start from the beginning, building up your knowledge, skills, and confidence until you are ready to take the exam and use Excel in the real world.In this MO-210 course, you will:Learn all about worksheets and workbooks and how to manage them.Create and format cells like a pro. Modify contents, insert Sparklines, and more.Create Excel tables from cell ranges, filter records, and apply styles.Understand how to perform operations by using formulas and functions.Create charts and add data to them.Complete beginners will feel right at home in no time as our Excel expert takes you by the hand and guides you through every aspect of Excel you need to know.The course ends with a mock exam that simulates the actual MO-210 exam. You are given a set of

Requirements

to achieve within a certain time. After that, we give you the solution and demonstrate how we achieved it.Your instructor is a highly experienced expert who has used and taught Excel for over 15 years. She uses Excel while consulting to produce reports, change management documentation, ROI information, and productivity reports for companies who want to make data-driven decisions. She shares her real-world experience with you during this course.Take this course if you just want to learn Excel for home or work, or want to earn the "Microsoft Office Specialist: Associate (Microsoft 365 Apps)" certification.

Who this course is for

Students preparing for the Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) exam
Office workers who need to use Excel
Anyone who wants to learn the most popular Excel tools and features
Homepage:

https://www.udemy.com/course/microsoft-excel-learning-labs-mo-210-exam/