Course description

This course is a continuation of MATH E-4. The course introduces more sophisticated spreadsheet tools for building mathematical models and analyzing data. Whereas MATH E-4 focuses on the basics of spreadsheets, this course covers more advanced topics including applications in statistics, finance, and physics; ranges and array-valued functions; queries, lookups, offsets, matches, indexing, and filters; user interface elements like dropdowns; dashboards for large data sets; specialized built-in functions; and, time allowing, custom built-in functions coded using the script editor.

Instructor

  • Director of Engineering, Mathematics Consortium Working Group
Enroll now.
Learn More