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
