Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Course details

Demonstrate your knowledge of Excel 2019 by becoming a Microsoft Office Specialist (MOS). Get training to prepare for the Excel Associate certification exams for Office 365 and Office 2019. This course, created by Microsoft Certified Instructor and MOS Master Jennifer McBee, helps you prepare for the five main areas of focus for the Excel Associate Office 365 and Office 2019 exams: managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, performing operations with formulas and functions, and managing charts. The course includes an overview of the MOS certification program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.

Learning objectives
Importing data
Formatting worksheets and workbooks
Exporting workbooks
Pasting data
Modifying columns, rows, and cells
Formatting cells
Conditional formatting
Creating tables
Filtering and sorting table data
Using references
Performing calculations with functions
Formatting text with functions
Creating charts
Taking the practice exam

Concepts

Introduction

Prove your Excel skills with a MOS certification
Who should take this course
About the exercise files
About the challenges

Microsoft Office Specialist Exam Overview

Different kinds of Microsoft Office Specialist certifications
Prepare for the test and review learning objectives

Manage Worksheets and Workbooks

Import TXT or CSV data into a new workbook
Import TXT or CSV data into an existing workbook
Search for data within a workbook
Navigate data with named ranges and hyperlinks
Format worksheets and workbooks
Customize headers and footers
Display and modify content in different views
Modify basic workbook properties
Customize the Quick Access Toolbar
Inspect and export workbooks
Configure print settings
Challenge - Manage worksheets and workbooks
Solution - Manage worksheets and workbooks

Manage Data Cells and Ranges

Paste data using special paste options
Fills cells by using AutoFill
Insert and delete columns, rows, and cells
Format cells and ranges
Apply styles to cells and ranges
Define and reference named ranges
Insert sparklines
Summarize data visually with built-in conditional formatting
Challenge - Manage data, cells, and ranges
Solution - Manage data, cells, and ranges

Manage Tables and Table Data

Create and format tables
Modify tables
Filter and sort table data
Challenge - Manage tables and table data
Solution - Manage tables and table data

Perform Operations Using Formulas and Functions

Insert relative, absolute, and mixed references
Reference named ranges and named tables in formulas
Using the AVERAGE(), MAX(), MIN(), and SUM() functions
Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions
Perform conditional operations using the IF() function
Format text using the RIGHT(), LEFT(), and MID() functions
Format text using UPPER(), LOWER() and LEN() functions
Format text using the CONCAT() and TEXTJOIN() functions
Challenge - Perform operations using formulas and functions
Solution - Perform operations using formulas and functions

Manage Charts

Create charts
Modify charts
Add and modify chart elements
Format charts
Challenge - Manage charts
Solution - Manage charts

Final Practice Exam

Challenge - Full-length practice exam
Solution - Full-length practice exam

Conclusion

Next steps