Key Features

Advanced Microsoft Excel Skill Training

10.3.8 Applied Lab: PivotCharts for Gross Profit

TestOut's state-of-the-art labs are a proven way to give students hands-on practice working with Microsoft Excel. Our labs give them the skills necessary to efficiently build spreadsheets at school and in their careers. Our labs teach basic to advanced topics which prepare students for the MOS associate and expert certifications. Replicating real world examples, these labs are designed to support teachers in the classroom and assess student's understanding as they interact with the concepts being taught. Advanced Excel skills taught in the course include:

  • Managing Workbooks
  • Collaboration
  • Advanced Fill Options
  • Data Validation
  • Advanced Conditional Formatting
  • Data Analytics
  • Troubleshooting Formulas
  • Creating Simple Macros
  • Advanced Charts
  • PivotTables
  • PivotCharts

Progressive Skill Practices

In our Microsoft Excel course, students can learn, practice, and validate Microsoft Excel skills using three different types of hands-on labs.

Challenge Lab 7.1.6 Manage Workbooks
Skills Lab 9.6.5 Create and Modify Simple Macros

MOS Exam Preparation

The course provides excellent MOS training and practice tests that prepare students to pass MOS Excel Associate and Expert exams.