Who should take this course

Contents

• Introduction Introduction

  • Welcome

    1m
  • Who should take this course

    14s
  • Using the exercise files

    37s
  • Using the challenges

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

  • (Locked)
    Compare the different Microsoft Office Specialist certifications

    1m 35s
  • (Locked)
    Prepare for the exam

    2m 33s
  • Exam format and registration process

    3m 18s
• 2. Create and Manage Workbooks and Worksheets 2. Create and Manage Workbooks and Worksheets

  • Create worksheets and workbooks

    7m 12s
  • (Locked)
    Navigate in worksheets and workbooks

    6m 8s
  • (Locked)
    Format worksheets and workbooks

    5m 46s
  • (Locked)
    Configure page setup and headers/footers

    5m 23s
  • (Locked)
    Customize options and views for worksheets and workbooks

    7m 3s
  • (Locked)
    Configure worksheets and workbooks for distribution

    7m 10s
  • (Locked)
    Challenge: Create and manage workbooks and worksheets

    1m 56s
  • (Locked)
    Solution: Create and manage workbooks and worksheets

    8m 46s
• 3. Manage Data Cells and Ranges 3. Manage Data Cells and Ranges

  • (Locked)
    Insert data in cells and ranges

    6m
  • (Locked)
    Format cells and ranges

    7m 51s
  • (Locked)
    Summarize data with conditional formatting

    4m 31s
  • (Locked)
    Summarize and organize data

    4m 8s
  • (Locked)
    Challenge: Manage data, cells, and ranges

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

    3m 10s
• 4. Create Tables 4. Create Tables

  • Create and manage tables

    4m 22s
  • (Locked)
    Manage table styles and options

    5m 22s
  • (Locked)
    Filter and sort a table

    6m 41s
  • (Locked)
    Challenge: Create and manage tables

    30s
  • (Locked)
    Solution: Create and manage tables

    3m 14s
• 5. Perform Operations with Formulas and Functions 5. Perform Operations with Formulas and Functions

  • (Locked)
    Summarize data by using functions

    6m 17s
  • (Locked)
    Use conditional operation functions: IF and COUNTIF functions

    5m 18s
  • (Locked)
    Use conditional operation functions: SUMIF and AVERAGEIF

    4m 37s
  • (Locked)
    Format and modify text by using functions

    3m 1s
  • (Locked)
    Combine text using functions and flash fill

    4m 16s
  • (Locked)
    Challenge: Perform operations with formulas and functions

    27s
  • (Locked)
    Solution: Perform operations with formulas and functions

    7m 9s
• 6. Create Charts and Objects 6. Create Charts and Objects

  • (Locked)
    Create charts

    4m 47s
  • (Locked)
    Format charts

    5m 50s
  • (Locked)
    Insert and format objects

    5m 22s
  • (Locked)
    Challenge: Create charts and objects

    26s
  • (Locked)
    Solution: Create charts and objects

    3m 26s
• 7. Final Practice Exam 7. Final Practice Exam

  • (Locked)
    Challenge: Full-length practice exam

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

    26m 25s
• Conclusion Conclusion

  • (Locked)
    Next steps

    19s