Welcome to ONLC Training Centers

Power Query in Excel Level 1 Course Outline

 (2 days)
Version 2013

Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. With Power Query, non-technical Excel users can access large corporate and internet-based databases to conduct analysis and produce reports.

Excel Versions
Power Query is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016. This course is taught using Excel 2013 software but the concepts are identical with Power Query implementations found in Excel 2010 and 2016 (or Office 365).

Target Student
This course is for individuals whose job responsibilities include creating complex Excel reports, as well as conducting advanced analytics and data science.

Excel Introduction or equivalent skills. Previous experience with database concepts is helpful but not required.

Introduction to Power Query
     Installing Power Query
     Creating a Simple Query
     Editing a Simple Query

Common Data Import Sources
     Working with CSV files
     Working with Text Files
     Working with Excel Files
     Working with other file types

Working with Data from the Web
     Scraping Data from Web Pages
     Calling a Web Service
     Finding Data Using a Power Query Online Search

Working with Folders and Multiple Files
     Working from Data from the Windows File System
     Combining Data from Multiple Files

Working with Columns
     Moving Columns
     Removing Columns
     Splitting Columns
     Merging Columns

Filtering and Sorting Rows
     Using Auto-Filter
     Using Number, Text and Date Filters
     Filting Rows by Range
     Removing Duplicate Values
     Filtering out Rows with Errors

Changing Values in a Table
     Replacing Values
     Text Transformations
     Number Transformations
     Date/Time Transformations
     Replacing Missing Values

Table Transformations
     Unpivoting Columns to Rows
     Transposing a Table
     Creating Custom Columns

Loading Data
     Loading Data into a Worksheet
     Loading Data into the Excel Data Model
     Power Query and Table Relationships
     Refreshing Queries Manually and Automatically

View outline in Word


Attend hands-on, instructor-led Power Query in Excel Level 1 training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Analytics Courses and select the one that's right for you.

Microsoft Gold Partner
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name