St. Cloud State University
Excel Special Features: Get & Transform aka Power Query (ended)
#: Excel   ID: 217880.1   Section: 6/10/2021  
Description:

This live online training course is offered by a collaboration of Minnesota State colleges.

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!

Excel includes a powerful 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 is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape your data as needed.

Course Topics:

  • 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. Some knowledge of Pivot Tables is helpful but not required. Those who have completed our Excel Level 1 & 2 courses are well prepared for this course.

About The Instructor: 
Bob Bruce is a Twin Cities-based Information Architect who has expert level skills in the Microsoft Office suite of products. He’s an Excel 2013 Microsoft Certified Expert. Bob has logged thousands of hours as a software trainer, and is energized by the prospect of improving student skills and knowledge.


Cancellation Policy:
A full refund minus a $25 processing fee will be issued if request is by June 3, 2021.

Day(s):
Th 
Time:
1:00 PM
Sessions:
1
Cost:
$109.00
Registration Cutoff Date:
6/3/2021
Dates & Times:
6/10/2021   1:00PM - 5:00PM