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

Course Overview

Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist (MOS). Get training for the Excel Associate certification exams for Office 365 and Office 2019.

Course Circullum

Introduction

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

1. Microsoft Office Specialist Exam Overview

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

2. 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

3. 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

4. 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

5. 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

6. Manage Charts

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

7. Final Practice Exam

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

Conclusion

Next steps

Jennifer McBee

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: