713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 

Microsoft® Office Excel: Get & Transform (PowerQuery)

Training Course Content (1 Day)

Course Objective: In this class, we will delve into the benefits and features provided using Power Query. We will examine the options available within the ribbon, as well as explore and demonstrate importing, filtering, transforming, and merging data using Power Query or Get and Transform.

Prerequisites: To ensure your success, we recommend that you first take Excel Level 1, Level 2, and In-Depth PivotTables, or have equivalent knowledge and skills - such as knowledge of advanced features and functions.

Contact us to discuss if this class is right for you.

Lesson 1: Explore the Power Query/Get & Transform

  • Power Query in Excel 2013 vs Get & Transform
  • Identify Data Source Types Available for Import
Lesson 2: Connect to and Load Data using Power Query
  • Connect to a Data Source
  • Create Queries from Excel, Access, a Website, Folder and More
  • Use Query Editor to View Data
  • Data Load Options and Query Navigation Panel

Lesson 3: Transform and Shape Data using Columns

  • Column Options in Query Editor
  • View and Modify Query Steps
  • Sort and Filter Data in Query Editor
  • Transform Date using Number, Date & Time, and Structured Columns
  • Pivot a Column

Lesson 4: Group Data, Append and Merge

  • Append Data from Two Queries
  • Merge Two Queries Together
  • Group Data in a Column
  • Manage the Queries Pane in Excel

Lesson 5: Aggregate Data and Analyze Data

  • Use Query Editor to Aggregate Data from a Column
  • Introduction to the Data Model
  • Analyze Query Data in a Pivot Table

Additional Power BI Courses:


Excel 365 Training Course Outlines

Excel 365 Core Features & Functions:

Excel 365 LV 1: Fundamentals of Excel
Excel 365 LV 2: Intermediate Functions & Features
Excel 365 LV 3: Advanced Tools &
Collaboration Features

Excel 365 LV 4: Advanced Functions

Excel 365 New Functions & Features:

Excel 365: New Functions & Formulas
Excel 365: New Features

Excel VBA Macros:

Excel 365 LV 5: Introduction To VBA Macros
Excel 365 LV 6: Advanced VBA Macros
 

Excel In-Depth Essentials:

Excel In-Depth: Charting Essentials
Excel In-Depth: PivotTable Essentials
Excel In-Depth: Advanced Excel Keyboarding

Excel Power Tools:

Excel Get & Transform (PowerQuery)
Excel PowerPivot Part 1
Excel PowerPivot Part 2

 

 

 
   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |