Microsoft Excel

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

Video- Excel Advanced Statistical Functions

Lesson Pages- Statistical Functions for Data Analysis