For best performance, please enable Javascript in your browser settings.

Computer Education at the Science Museum of Minnesota: Class Description and Prerequisites

Class Description and Prerequisites

Below is the class description, prerequisites, and schedule. To register for this class, add it to your cart.

To return to All classes, click on the All Classes link on the left or above in the breadcrumb trail.


Use Excel to better collect, organize, and utilize your data. Excel quickly and simply calculates totals, finds averages, creates charts, and more.

Note: Topics taught in these classes apply to versions 2010, 2013, 2016, and 365.

Functions: Beyond the Basics

Prerequisites: Excel Introduction and Intermediate or equivalent experience. Also requires experience building formulas with basic functions, using AutoFill and absolute/relative cell addressing.

Class Topics:

  • Using functions for sophisticated summing, averaging, and counting
  • Advanced uses of VLOOKUP, HLOOKUP, INDEX and MATCH functions
  • Cleaning up data using text functions

Jump to: Go to descriptions and schedules for the whole Class SeriesFull Series Description & ScheduleGo to the class schedule list without descriptionsAll Classes Schedule list
Date Time Location Fee  
Wed, Mar 20, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Apr 17, 2019 8:00am - 11:45am St. Paul $149.00