Microsoft Excel Training Course

Discover More Get Started
spreadsheet-concept-exprep-colors

Excel Learning Made Simple

Our Excel Training Course goes beyond basic theory. Users learn Excel by working directly in spreadsheets, completing hands-on exercises that build real-world skills across key topics and business scenarios.
 
  • Users will engage in real-world business scenarios across multiple disciplines
  • All assignments are integrated into the ExPrep Platform to streamline grading.
  • Users will learn over 100 skills and functions in Microsoft Excel.
Course Concept

Through this course, students will engage in real-world business scenarios that will effectively teach them complex Excel skills needed in their future careers.

The course covers Basic Formulas and formatting, Conditional Highlighting Activities, Charts and Graphs, Data Cleanup, Logical and Lookup Functions, Data Validation, PivotTables, What-If Analyses and more!

Course Assignments

Basic Formulas

Learn basic Excel formulas and functions such as sum, min, average, and more while completing tasks that highlight the utility of Excel.

Conditional Highlighting

Grasp concepts like conditional formatting and highlighting for categorizing, visualizing, and analyzing data.

Charts and Graphs

Complete assignments that focus on understanding the basics of chart elements such as trendlines, data series, and more.

Data Cleanup

Learn how to clean up messy data sets by utilizing different text functions within Excel
 

Logical Functions

Build a complete marketing report by using data and logical functions such as COUNTIF(S), IFERROR, SUMIF(S), and more!

Lookup Functions

Complete assignments that center on finding missing information by using Vlookup, Index, Match, and Xlookup.

Pivot Tables

Create a report on a real-world compensation scenario from raw data. Learn to use PivotTable and What-If Analysis tools such as Goal Seek, DataTables, Calculated Fields, and more!

Schedule a Demo

Demo your own spreadsheet content on our platform live with one of our experts. 

✓  Automated Grading

✓ Carry Through Credit (CTC)

✓ Cheating Surveillance

✓ Customized Feedback

✓ LMS Integration