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.