About the exercise files

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
  • 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
  • Import TXT or CSV data into an existing workbook

    3m 7s
  • Search for data within a workbook

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

    5m 27s
  • Format worksheets and workbooks

    5m 1s
  • Customize headers and footers

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

    5m
  • Modify basic workbook properties

    2m 33s
  • Customize the Quick Access Toolbar

    3m 55s
  • Inspect and export workbooks

    6m 33s
  • Configure print settings

    4m 15s
  • Challenge: Manage worksheets and workbooks

    1m 10s
  • 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
  • Fills cells by using AutoFill

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

    3m 15s
  • Format cells and ranges

    5m 39s
  • Apply styles to cells and ranges

    6m 44s
  • Define and reference named ranges

    5m 18s
  • Insert sparklines

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

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

    27s
  • 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
  • Modify tables

    4m 19s
  • Filter and sort table data

    4m 4s
  • Challenge: Manage tables and table data

    29s
  • Solution: Manage tables and table data

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

  • Insert relative, absolute, and mixed references

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

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

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

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

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

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

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

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

    28s
  • Solution: Perform operations using formulas and functions

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

  • Create charts

    3m 40s
  • Modify charts

    2m 45s
  • Add and modify chart elements

    6m 32s
  • Format charts

    3m 4s
  • Challenge: Manage charts

    30s
  • Solution: Manage charts

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

  • Challenge: Full-length practice exam

    30s
  • Solution: Full-length practice exam

    25m 26s
• Conclusion Conclusion

  • Next steps

    22s