TestOut Pro Certified: Microsoft Excel®

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

TestOut Pro Certified: Microsoft Excel® provides students a state-of-the-art learning platform where they can gain practical knowledge, learn real world skills, and prove their competency within Microsoft Excel. The course objectives ensure students get a great foundation for both an associate and expert-level certification.

The course covers concepts, such as:

  • Creating Workbooks and Entering Data
  • Formatting Cells
  • Formulas and Functions
  • Printing Workbooks
  • Displaying Data in Tables and Charts
  • Cell and Workbook Referencing
  • Preparing Workbooks for Collaboration
  • Flash Fill and Advanced Fill Series Options
  • Troubleshooting Formulas
  • Date and Time Functions
  • Creating Simple Macros
  • PivotTables and PivotCharts

Show More

What Will You Learn?

  • Creating Workbooks and Entering Data
  • Formatting Cells
  • Formulas and Functions
  • Printing Workbooks
  • Displaying Data in Tables and Charts
  • Cell and Workbook Referencing
  • Preparing Workbooks for Collaboration
  • Flash Fill and Advanced Fill Series Options
  • Troubleshooting Formulas
  • Date and Time Functions
  • Creating Simple Macros
  • PivotTables and PivotCharts

Course Content

Course Overview

Common Office Features

Excel Basics

Formulas and Functions

Simple Data Analysis

MO-200 (Excel Associate) Practice Exams

Advanced Workbook Options and Settings

Advanced Data Formatting

Advanced Formulas and Macros

Advanced Charts and Tables

MO-201 (Excel Expert) Practice Exams

TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?