Center for Continuing Studies

Center for Continuing Studies

We customize

We can tailor these courses to meet the needs of your business or group and offer them at the SCSU Welcome Center or a location of your choice with our portable laptop lab.

Contact: Tammy Anhalt-Warner; 320-308-4252.


Bob was a great trainer with a wealth of knowledge.  His experience and ability to relate the topics to real life was great.  


Bob BruceWe offer four levels of Microsoft Excel courses through Bob Bruce, an instructor who has trained people on Microsoft products for more than 20 years. 

Each course takes 3.5 hours. St. Cloud State provides a laptop and mouse to use for this hands on training.

For human resource professionals, each course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.

Excel 2016 Level 1:  Practical Excel

  • Getting started: Exploring the Excel 2016 environment
  • Navigating, managing worksheets, and views
  • Worksheet layout, entering and modifying Data
  • Creating formulas and using basic functions
  • Formatting cells, themes and cell styles
  • Printing worksheets

Excel 2016 Level 2: Working with Data

  • Understanding types of data
  • Filtering and sorting 
  • Excel tables
  • Advanced Formulas: logic and summarizing functions (COUNTIF, SUMIF, AVERAGEIF, VLOOKUP)
  • Pivot tables and pivot charts
  • Using the Data Model with pivot tables

Excel 2016: Get & Transform aka Power Query

Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform enables you to connect, combine, and refine data sources to meet your analysis needs. These features are also used in Power BI, and in the Power Query Add-In available for previous versions of Excel.      

You don't know this Excel!  Get & Transform will change the way you use Excel by eliminating a lot of unnecessary steps and reducing your project time by hours or even days!

  • Power Query Basics
  • Column-Level Actions
  • Table Actions
  • Importing Data from Files, Databases
  • Unpivoting
  • Common Transformations
  • Custom Columns
  • Grouping and Aggregating
  • Managing Queries
  • Reusing Query Steps
  • Merge & Append Queries
  • Practical applications
  • Replace VLOOKUP
Prerequisite:   Familiarity with VLOOKUP feature.  Experience with Pivot Tables is helpful.

Excel 2016: Getting Started with the Data Model & Power Pivot

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

  • Working with the Data Model
  • Replace VLOOKUP
  • Database Terms & Concepts
  • Linking Excel Tables to Power Pivot
  • Loading Data from Relational Databases & files
  • Building table relationships
  • Calculated columns
  • Measures
  • Basic DAX functions
  • Understanding Evaluation Contexts
  • Creating Pivot Tables from the Data Model
Prerequisite:  Frequent use with pivot tables.


Feedback from attendees

  • Bob was a great trainer with a wealth of knowledge.  His experience and ability to relate the topics to real life was great.  He kept our audience's attention in what could have been a fairly flat topic.
  • It was helpful to learn how unintimidating Excel can be.
  • Great investment of time and money.  Nice job!
  • I loved the multiple shortcuts used to save time
  • The workbook will help cement all we have learned.
  • The class was excellent!
  • The pivot tables portion was all new to me and will benefit my day to day Excel use.
  • Vlookup and pivot tables were very helpful
  • The class was very helpful and exactly what I expected.  Thank you!
  • The examples were great.  I really enjoyed the entire presentation.
  • Loved the shortcuts and new features!

Alternate registration

  • Call 320-308-4723 or 320-308-6100
  • Complete form (PDF)
  • Pay by check or invoice


Get & Transform & Data Model & Power Pivot

  • Get & Transform aka Power Query: 8-11:30 a.m. June 21, 2018
  • Getting Started with the Data Model & Power Pivot: 12:30-4 p.m., June 21, 2018
  • Both sessions: 8 a.m.-4 p.m., June 21, 2018

Early-bird registration fee applies 2 weeks prior. Registration closes 1 week prior.


Level 1 & Level 2

  • Excel 1: 8-11:30 a.m., July 26, 2018
  • Excel 2: 12:30-4 p.m., July 26, 2018
  • Excel 1 & 2: 8 a.m.-4 p.m., July 26, 2018

Early-bird registration fee applies 2 weeks prior. Registration closes 1 week prior.


Location: SCSU Welcome Center

355 Fifth Ave. S, St. Cloud, MN

Parking: Free, convenient, secure, indoor


  • $89, early bird
  • $99, regular cost
  • $75, St. Cloud State students
  • $165, both sessions