Microsoft Excel: Hands-On Learning Labs [MO-210 Exam Prep]

Name: Microsoft Excel: Hands-On Learning Labs [MO-210 Exam Prep]
Rating: 4.1 (6 reviews)

Prepare for the Microsoft Office Specialist Excel exam by configuring tables, formulas, charts and managing workbooks.

Created byHow To Network

Last updated 3/2025

English

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

Course content

6 sections • 102 lectures • 12h 25m total length

Getting Access to Microsoft Excel 3658:40
Import Data From Text Files9:08
Import Data From Online Sources10:14
Search For Data Within A Workbook7:38
Navigate To Named Cells, Ranges, Or Workbook Elements7:13
Navigate To Named Cells, Ranges, Or Workbook Elements 28:30
Insert And Remove Hyperlinks12:40
Modify Page Setup11:56
Modify Page Setup 28:17
Modify Page Setup 38:13
Adjust Row Height And Column Width10:13
Customize Headers And Footers10:29
Customize Headers And Footers 27:35
Customize Options And Views7:07
Customize Options And Views 27:53
Manage The Quick Access Toolbar5:05
Manage The Quick Access Toolbar 26:49
Display And Modify Worksheets In Different Views6:19
Display And Modify Worksheets In Different Views 26:59
Freeze Worksheet Rows And Columns6:31
Change Window Views9:29
Modify Built-In Workbook Properties8:30
Modify Built-In Workbook Properties 25:31
Modify Built-In Workbook Properties 39:33
Display Formulas5:54
Set A Print Area5:43
Save And Export Workbooks In Alternative File Formats5:02
Configure Print Settings9:29
Inspect Workbooks And Correct Issues9:08
Manage Comments And Notes8:39

Paste Data by Using Special Paste Options5:19
Paste Data by Using Special Paste Options 26:02
Paste Data by Using Special Paste Options 36:26
Fill cells by using Auto Fill6:58
Insert and delete multiple columns or rows5:25
Insert and delete cells5:02
Generate Numeric Data by Using RANDBETWEEN() and SEQUENCE()6:29
Generate Numeric Data by Using RANDBETWEEN() and SEQUENCE() 27:48
Merge and Unmerge Cells6:41
Modify Cell Alignment, Orientation, and Indentation9:02
Format Cells by Using Format Painter6:58
Wrap Text Within Cells5:47
Apply Number Formats7:14
Apply Number Formats 27:36
Apply Cell Formats From the Format Cells Dialog Box9:28
Apply Cell Styles7:43
Apply Cell Styles 28:12
Clear Cell Formatting6:56
Format Multiple Worksheets by Grouping6:27
Define a Named Range5:55
Reference a Named Range5:34
Insert Sparklines6:10
Insert Sparklines 29:10
Apply Built-in Conditional Formatting13:25
Apply Built-in Conditional Formatting 28:09
Apply Built-in Conditional Formatting 35:29
Apply Built-in Conditional Formatting 47:36
Apply Built-in Conditional Formatting 58:55
Remove Conditional Formatting5:33
Remove Conditional Formatting 25:05

Insert Relative, Absolute, And Mixed References7:37
Insert Relative, Absolute, And Mixed References 26:59
Use Structured References In Formulas6:42
Use Structured References In Formulas 26:07
Perform Calculations By Using The Average(), Max(), Min(), And Sum() Functions7:09
Perform Calculations By Using The Average(), Max(), Min(), And Sum() Functions 26:27
Count Cells By Using The Count(), Counta(), And Countblank() Functions6:40
Count Cells By Using The Count(), Counta(), And Countblank() Functions 27:02
Perform Conditional Operations By Using The If() Function9:02
Perform Conditional Operations By Using The If() Function 29:38
Sort Data By Using The Sort() Function7:41
Get Unique Values By Using The Unique() Function6:27
Format Text By Using Right(), Left(), And Mid() Functions8:04
Format Text By Using Upper(), Lower(), And Len() Functions5:05
Format Text By Using Upper(), Lower(), And Len() Functions 25:12
Format Text By Using The Concat() And Textjoin() Functions5:26

Create Charts7:03
Create Charts 28:28
Create Charts 35:16
Create Chart Sheets6:32
Add Data Series To Charts5:46
Add Data Series To Charts 26:33
Switch Between Rows And Columns In Source Data6:50
Add And Modify Chart Elements6:49
Add And Modify Chart Elements 25:42
Add And Modify Chart Elements 35:38
Apply Chart Layouts5:37
Apply Chart Layouts 25:30
Apply Chart Styles5:18
Apply Chart Styles 26:03
Add Alternative Text To Charts For Accessibility6:56

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

Microsoft Excel: Hands-On Learning Labs [MO-210 Exam Prep]

What you'll learn

Explore related topics

Course content

Manage Worksheets and Workbooks30 lectures • 4hr 4min

Manage Data Cells and Ranges30 lectures • 3hr 33min

Manage Tables and Table Data10 lectures • 56min

Perform Operations by Using Formulas and Functions16 lectures • 1hr 51min

Charts15 lectures • 1hr 34min

Practical Exam and Bonus Downloadable Exam1 lecture • 27min

Requirements

Description

Who this course is for: