TestOut Pro Certified: Microsoft Excel®
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
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