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

Computer Education at the Science Museum of Minnesota: Class Series Details

Class Series Details

Below are the descriptions, prerequisites, schedule, and cost for the class(es) within this class series.

To register for a class, add it to your cart.


Excel

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.


Introduction

Prerequisites: Experience using a computer.

Class Topics:

  • Navigating the worksheet
  • Entering and editing data
  • Manipulating cells, columns, and rows
  • Basic formatting
  • Using formulas and functions
  • Working with AutoFill

Date Time Location Fee  
Tue, Jan 8, 2019 8:00am - 11:45am St. Paul $149.00
Mon, Jan 14, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Jan 30, 2019 8:00am - 11:45am St. Paul $149.00
Thu, Feb 7, 2019 8:00am - 11:45am St. Paul $149.00
Tue, Feb 19, 2019 8:00am - 11:45am St. Paul $149.00
Tue, Feb 26, 2019 8:00am - 11:45am St. Paul $149.00
Thu, Mar 7, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Mar 13, 2019 8:00am - 11:45am St. Paul $149.00
Thu, Mar 21, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Apr 3, 2019 8:00am - 11:45am St. Paul $149.00
Mon, Apr 8, 2019 8:00am - 11:45am St. Paul $149.00


Intermediate

Prerequisites: Excel Introduction or experience developing spreadsheets from scratch, creating formulas, working with functions, and knowledge of the AutoFill tool.

Class Topics:

  • Advanced formatting
  • Basic styles
  • Using multiple worksheets
  • IF statements
  • 3-D cell referencing

Date Time Location Fee  
Tue, Dec 18, 2018 1:00pm - 4:45pm St. Paul *
Tue, Jan 8, 2019 1:00pm - 4:45pm St. Paul $149.00
Mon, Jan 14, 2019 1:00pm - 4:45pm St. Paul $149.00
Wed, Jan 30, 2019 1:00pm - 4:45pm St. Paul $149.00
Thu, Feb 7, 2019 1:00pm - 4:45pm St. Paul $149.00
Tue, Feb 19, 2019 1:00pm - 4:45pm St. Paul $149.00
Tue, Feb 26, 2019 1:00pm - 4:45pm St. Paul $149.00
Thu, Mar 7, 2019 1:00pm - 4:45pm St. Paul $149.00
Wed, Mar 13, 2019 1:00pm - 4:45pm St. Paul $149.00
Thu, Mar 21, 2019 1:00pm - 4:45pm St. Paul $149.00
Wed, Apr 3, 2019 1:00pm - 4:45pm St. Paul $149.00
Mon, Apr 8, 2019 1:00pm - 4:45pm St. Paul $149.00


Advanced

Prerequisites: Excel Introduction and Intermediate or equivalent experience.

Class Topics:

  • Customizing the program
  • Advanced linking
  • Consolidating data
  • Outlining
  • Protecting your work

Date Time Location Fee  
Thu, Jan 10, 2019 8:00am - 11:45am St. Paul $159.00
Mon, Feb 4, 2019 8:00am - 11:45am St. Paul $159.00
Mon, Mar 11, 2019 8:00am - 11:45am St. Paul $159.00
Tue, Apr 16, 2019 8:00am - 11:45am St. Paul $159.00


Charting

Prerequisites: Excel Introduction or equivalent experience.

Class Topics:

  • Making the following types of charts: area, line, bar, column, pie
  • Adjusting data: axis and scale
  • Editing text: fonts, sizes, and color
  • Placing charts in other programs

Date Time Location Fee  
Wed, Dec 19, 2018 8:00am - 11:45am St. Paul $149.00
Thu, Jan 24, 2019 1:00pm - 4:45pm St. Paul $149.00
Wed, Feb 20, 2019 8:00am - 11:45am St. Paul $149.00
Thu, Mar 28, 2019 8:00am - 11:45am St. Paul $149.00


PivotTables & Database Features

Prerequisites: Excel Introduction and Intermediate or equivalent experience.

Class Topics:

  • Creating and editing lists
  • Sorting lists
  • Extracting data
  • PivotTables
  • VLOOKUP

Date Time Location Fee  
Wed, Dec 19, 2018 1:00pm - 4:45pm St. Paul $149.00
Thu, Jan 10, 2019 1:00pm - 4:45pm St. Paul $149.00
Thu, Jan 31, 2019 1:00pm - 4:45pm St. Paul $149.00
Mon, Feb 11, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Feb 20, 2019 1:00pm - 4:45pm St. Paul $149.00
Tue, Mar 19, 2019 8:00am - 11:45am St. Paul $149.00
Thu, Mar 28, 2019 1:00pm - 4:45pm St. Paul $149.00
Wed, Apr 10, 2019 8:00am - 11:45am St. Paul $149.00


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

Date Time Location Fee  
Wed, Feb 13, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Mar 20, 2019 8:00am - 11:45am St. Paul $149.00
Wed, Apr 17, 2019 8:00am - 11:45am St. Paul $149.00


Macros

Prerequisites: Excel Introduction and Intermediate or equivalent experience.

Class Topics:

  • Macro concepts, commands, and tools
  • Recording and writing macros
  • Documenting macros
  • Adding macros to menus and buttons
  • Command macros & user-defined macros

Date Time Location Fee  
Mon, Feb 4, 2019 1:00pm - 4:45pm St. Paul $159.00
Mon, Mar 11, 2019 1:00pm - 4:45pm St. Paul $159.00
Tue, Apr 16, 2019 1:00pm - 4:45pm St. Paul $159.00