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

Contents

• Introduction Introduction

  • Prove your Excel skills with a MOS certification

    57s
  • Who should take this course?

    1m 15s
  • About the exercise files

    34s
  • About the challenges

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

  • Different kinds of Microsoft Office Specialist certifications

    1m 48s
  • (Locked)
    Prepare for the test and review learning objectives

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

  • Import TXT or CSV data into a new workbook

    3m 22s
  • (Locked)
    Import TXT or CSV data into an existing workbook

    3m 7s
  • (Locked)
    Search for data within a workbook

    2m 36s
  • (Locked)
    Navigate data with named ranges and hyperlinks

    5m 27s
  • (Locked)
    Format worksheets and workbooks

    5m 1s
  • (Locked)
    Customize headers and footers

    4m 37s
  • (Locked)
    Display and modify content in different views

    5m
  • (Locked)
    Modify basic workbook properties

    2m 33s
  • (Locked)
    Customize the Quick Access Toolbar

    3m 55s
  • (Locked)
    Inspect and export workbooks

    6m 33s
  • (Locked)
    Configure print settings

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

    1m 10s
  • (Locked)
    Solution: Manage worksheets and workbooks

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

  • Paste data using special paste options

    6m 28s
  • (Locked)
    Fills cells by using AutoFill

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

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

    5m 39s
  • (Locked)
    Apply styles to cells and ranges

    6m 44s
  • (Locked)
    Define and reference named ranges

    5m 18s
  • (Locked)
    Insert sparklines

    5m 35s
  • (Locked)
    Summarize data visually with built-in conditional formatting

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

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

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

  • Create and format tables

    3m 23s
  • (Locked)
    Modify tables

    4m 19s
  • (Locked)
    Filter and sort table data

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

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

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

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

    8m 7s
  • (Locked)
    Reference named ranges and named tables in formulas

    3m 35s
  • (Locked)
    Using the AVERAGE(), MAX(), MIN(), and SUM() functions

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

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

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

    2m 36s
  • (Locked)
    Format text using UPPER(), LOWER() and LEN() functions

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

    4m 42s
  • (Locked)
    Challenge: Perform operations using formulas and functions

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

    4m 55s
• 6. Manage Charts 6. Manage Charts

  • Create charts

    3m 40s
  • (Locked)
    Modify charts

    2m 45s
  • (Locked)
    Add and modify chart elements

    6m 32s
  • (Locked)
    Format charts

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

    30s
  • (Locked)
    Solution: Manage charts

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

  • (Locked)
    Challenge: Full-length practice exam

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

    25m 26s
• Conclusion Conclusion

  • (Locked)
    Next steps

    22s