Microsoft Excel

Real-world data
in context 

Step-by-step written instructions
Short videos
Lots of Sample Projects

Microsoft Excel: “The Power of the Grid”
Learn how to enter data and create formulas to analyze and present complex information.  Understanding Microsoft Excel is an important middle technical skill in data analysis, as well as the related fields of data management and engineering.  Mastering Microsoft Excel is a pathway to a better job.

Lesson Demo: Excel Statistical Functions

Lesson: Excel Statistical Functions

  • Use Statistical Functions in Excel
  • Use Mean, Mode, and Median
  • Use Named Ranges in Statistical Functions
  • Define SUMIF and SUMIFS
  • Use AVERAGEIFS and MAXIFS

Video- Excel Advanced Statistical Functions

Lesson Pages- Statistical Functions for Data Analysis