Use conditional operation functions: SUMIF and AVERAGEIF

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

  • Compare the different Microsoft Office Specialist certifications

    1m 35s
  • 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
  • Navigate in worksheets and workbooks

    6m 8s
  • Format worksheets and workbooks

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

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

    7m 3s
  • Configure worksheets and workbooks for distribution

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

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

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

  • Insert data in cells and ranges

    6m
  • Format cells and ranges

    7m 51s
  • Summarize data with conditional formatting

    4m 31s
  • Summarize and organize data

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

    27s
  • Solution: Manage data, cells, and ranges

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

  • Create and manage tables

    4m 22s
  • Manage table styles and options

    5m 22s
  • Filter and sort a table

    6m 41s
  • Challenge: Create and manage tables

    30s
  • Solution: Create and manage tables

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

  • Summarize data by using functions

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

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

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

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

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

    27s
  • Solution: Perform operations with formulas and functions

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

  • Create charts

    4m 47s
  • Format charts

    5m 50s
  • Insert and format objects

    5m 22s
  • Challenge: Create charts and objects

    26s
  • Solution: Create charts and objects

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

  • Challenge: Full-length practice exam

    39s
  • Solution: Full-length practice exam

    26m 25s
• Conclusion Conclusion

  • Next steps

    19s