Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

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

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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.

Syllabus

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

Taught by

Jennifer McBee

Reviews

4.7 rating at LinkedIn Learning based on 707 ratings

Start your review of Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019 and Office 365

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.