MO-200 Microsoft Excel 365/2019 Associate Certification

Name: MO-200 Microsoft Excel 365/2019 Associate Certification
Rating: 4.6 (2031 reviews)

Master the Excel 2019 exam with hands-on activities and tutorials. This course even has a practice exam!

Created byMichael Carter

Last updated 8/2021

English

What you'll learn

Students will learn how to pass the Microsoft Excel MO 200 Exam

Course content

7 sections • 18 lectures • 3h 4m total length

Introduction and course overview0:52
Excel Personality Assignment
Assignment: Introduce Yourself!0:17
Assignment: Introduce Yourself
It's time for taking action!
Introduce yourself to your fellow students by answering the following questions:
What is one fun fact about you?
Why are you taking this exam?
What score do you expect to achieve on this exam, (out of 1000)?
Post in the Microsoft Office Specialist Facebook Group or if you're not a member of Facebook, you can post it on the course Q&A.
Looking forward to learning more about you!

Overview Tutorial12:49
This module prepares you to get started in Excel by showing you how to create and manage worksheets and workbooks. You will learn how to import data from another file, create and navigate to named ranges, adjust row height and column width, freeze rows, and configure the different parts of a worksheet that may be printed.
Excel MO Project 1 Tutorial9:23
Excel MO Project 1 Assignment
MO-Project 2 Tutorial10:18

Overview Tutorial7:34
Up to now in this class, you might think that most of the data you used in your worksheets has been contained within a table. However, what we have been learning, up to this point, is how to create a “structured range” of data, not tables. Excel has a special relevance for a class of data that it formally calls a table. A table in Excel allows you to process, filter, and sort data more efficiently than a structured range. You will learn all about this within this module!
MO Project 4 Tutorial7:43
Format excel tables with banded rows that auto update, sort multiple columns, remove duplicates by invoice number, and convert to a structured range.

Text Functions9:25
Utilize text functions to modify names in Excel. Apply proper, upper, lower, concat, left, right, and trim with the function arguments dialog and autofill.
Summary Functions6:31
Conditional Functions11:01
Learn how to use the if, sum if, count if, and average if functions to evaluate conditions, filter by Alberta with name ranges in Excel.
Functions UPDATE!8:10
Develop mastery in MO-200 Excel 365/2019 by updating essential functions through five practical challenges, covering if, upper, count blank, concat, and absolute reference techniques.
MO Project 5 Functions Assignment

Requirements

Excel 2019

Description

The course will prepare you for the MOS Excel 2019 or the MO-200 exam by taking you through all of the major skills required. You will also be able to complete a mock MOS Excel exam. These tutorials will get straight to what you need to know for your upcoming exam, no fluff just the skills that are relevant to helping you pass the exam with confidence. The course will cover NEW Excel 2019 skills such as: managing Excel worksheet and workbooks, formatting worksheets, Excel charts and images, Excel functions, formulas, and operations, and lastly, Excel tables. The best part? You will be given a practice test to download to see if you are ready! Good luck!

Who this course is for:

Students preparing to take their MO-200 Excel exam

MO-200 Microsoft Excel 365/2019 Associate Certification

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 1min

Create and Manage Worksheets and Workbooks3 lectures • 33min

Manage Data in Cells and Ranges2 lectures • 28min

Create and Manage Tables2 lectures • 15min

Perform Operations and Functions4 lectures • 35min

Manage charts and objects3 lectures • 20min

MO-200 Practice Exam2 lectures • 52min

Requirements

Description

Who this course is for: