Center for Continuing Studies

Excel

Bob BruceWe offer two 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 & 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.      

  • 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

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

Feedback from attendees

  • 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!

Level 1 & Level 2

  • Excel 1: 8-11:30 a.m., Thursday, Jan. 25
  • Excel 2: 12:30-4 p.m., Thursday, Jan. 25
  • Excel 1 & 2: 8 a.m.-4 p.m., Thursday, Jan. 25

Early bird registration fee by Jan. 11. Registration closes Jan. 18.

Get & Transform & Data Model & Power Pivot

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

Early bird registration fee by Feb. 8. Registrations close Feb. 15.

Location: SCSU Welcome Center

355 Fifth Ave. S, St. Cloud, MN

Parking: Free, convenient, secure, indoor

Cost:

  • $89, early bird
  • $99, regular cost
  • $75, St. Cloud State students
  • $165, both sessions
  • St. Cloud State students enter "Student" code and click "Apply Class Code" during checkout. Enter Tech ID in "Alternate Learner ID" field.

Alternate registration

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