Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps

Contents

• Introduction Introduction

  • Prove your Excel skills with a MOS certification

    53s
  • Who should take this course?

    1m 10s
  • About the exercise files

    36s
  • About the challenges

    38s
• 1. Microsoft Office Specialist Exam Overview 1. Microsoft Office Specialist Exam Overview

  • Different kinds of Microsoft Office Specialist certifications

    2m 52s
  • (Locked)
    Prepare for the test and review learning objectives

    5m 59s
• 2. Manage Worksheets and Workbooks 2. Manage Worksheets and Workbooks

  • Import TXT data into a new or existing workbook

    4m 35s
  • (Locked)
    Import data from online sources

    4m 45s
  • (Locked)
    Search for data within a workbook

    4m 56s
  • (Locked)
    Navigate to named cells, ranges, or workbook elements

    6m 14s
  • (Locked)
    Insert and remove hyperlinks

    3m 26s
  • (Locked)
    Format worksheets and workbooks

    4m 26s
  • (Locked)
    Customize headers and footers

    4m 3s
  • (Locked)
    Manage the Quick Access Toolbar

    4m 17s
  • (Locked)
    Display and modify worksheets in different views

    6m 1s
  • (Locked)
    Modify built-in workbook properties

    2m 33s
  • (Locked)
    Inspect and export workbooks

    5m 54s
  • (Locked)
    Configure print settings

    5m 54s
  • (Locked)
    Manage comments and notes

    4m 52s
  • (Locked)
    Challenge: Manage worksheets and workbooks

    2m 30s
  • (Locked)
    Solution: Manage worksheets and workbooks

    9m 41s
• 3. Manage Data Cells and Ranges 3. Manage Data Cells and Ranges

  • Paste data using special paste options

    5m 28s
  • (Locked)
    Fill cells by using AutoFill

    4m 20s
  • (Locked)
    Insert and delete columns, rows, and cells

    3m 26s
  • (Locked)
    Format cells and ranges

    5m 28s
  • (Locked)
    Generate random and sequential data using Functions

    4m 55s
  • (Locked)
    Apply styles to cells and ranges

    7m 49s
  • (Locked)
    Define and reference named ranges

    3m 39s
  • (Locked)
    Insert sparklines

    3m 28s
  • (Locked)
    Summarize data visually with built-in conditional formatting

    3m 24s
  • (Locked)
    Challenge: Manage data, cells, and ranges

    32s
  • (Locked)
    Solution: Manage data, cells, and ranges

    4m 46s
• 4. Manage Tables and Table Data 4. Manage Tables and Table Data

  • Create and format tables

    5m 23s
  • (Locked)
    Modify tables

    3m 31s
  • (Locked)
    Filter and sort table data

    3m 50s
  • (Locked)
    Challenge: Manage tables and table data

    32s
  • (Locked)
    Solution: Manage tables and table data

    3m 18s
• 5. Perform Operations Using Formulas and Functions 5. Perform Operations Using Formulas and Functions

  • (Locked)
    Insert relative, absolute, and mixed references

    6m 3s
  • (Locked)
    Use structured references in formulas

    4m 56s
  • (Locked)
    Using the AVERAGE(), MAX(), MIN(), and SUM() functions

    2m 32s
  • (Locked)
    Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions

    2m 51s
  • (Locked)
    Perform conditional operations using the IF() function

    4m 18s
  • (Locked)
    Sort data and return unique values using the SORT() and UNIQUE() functions

    5m 5s
  • (Locked)
    Format text using the RIGHT(), LEFT(), and MID() functions

    3m 56s
  • (Locked)
    Format text using UPPER(), LOWER(), and LEN() functions

    2m 5s
  • (Locked)
    Format text using the CONCAT() and TEXTJOIN() functions

    3m 53s
  • (Locked)
    Challenge: Perform operations using formulas and functions

    34s
  • (Locked)
    Solution: Perform operations using formulas and functions

    5m 21s
• 6. Manage Charts 6. Manage Charts

  • (Locked)
    Create and modify charts

    5m 31s
  • (Locked)
    Add and modify chart elements

    4m 24s
  • (Locked)
    Format charts

    4m 30s
  • (Locked)
    Challenge: Manage charts

    32s
  • (Locked)
    Solution: Manage charts

    4m 17s
• 7. Final Practice Exam 7. Final Practice Exam

  • (Locked)
    Challenge: Full-length practice exam

    52s
  • (Locked)
    Solution: Full-length practice exam

    30m 13s