South Central College

The Center for Business and Industry at South Central College is the preferred provider of education, training and consulting services that support each client’s unique goals.

Excel Special Features: Get & Transform aka Power Query
#: LVON-1073   ID: 226   Section: 0610  
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.

Aout 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.

Bring to Class:
  • Computer with Microsoft Excel (2016 or newer recommended), webcam, microphone, and high-speed internet
  • Your experience will be enhanced if you have 2 monitors but it is not required.
  • Zoom connection information and Excel working files to download will be emailed several days prior to the class date.
  • We request that participants utilize the video feature during the training session so the instructor can monitor your experience.
  

 

Day(s):
Th 
Time:
1:00 PM
Sessions:
1
Cost:
$99.00 * If registered by 5/27/2021
Registration Cutoff Date:
6/3/2021
Dates & Times:
6/10/2021   1:00PM - 5:00PM Online