Using actual mobility data, this course teaches concepts from the Excel 2019, Excel MO200 and Excel MO201 Certification Exams
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
