Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

Excel Power Query

Overview

Power Query is a data connection technology that comes with Excel that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports. This class is designed to teach Power Query from the ground up and assumes you have not used Power Query in the past. Once we have covered the foundational topics of Power Query, then we will move on to the Power Query M language (code) that is used to create queries in Power Query.

Price

$395 per Student

CPE Credits

8 CPE Credits

Who this course is for
  • New to Power Query or never been formally trained in Power Query
  • Users who utilize often the VLOOKUP and INDEX/MATCH Functions
  • People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
  • Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
  • Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
  • If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
  • IT specialists who performs Extract Transform & Load (ETL) activities for business
Duration

1 Day

Class Outline
Power Suite Overview
  • What is Power Pivot, Power Query, Power View and Power Map
  • The Power Suite Workflow
  • Power Query Examples
  • Power Pivot Examples
  • Power View Examples
Data Loading Options
  • Common Usage Patterns
  • Load to a Table
  • Load to a Pivot Table
  • Load to a Pivot Chart
  • Only Create Connection
  • Add to the Data Model
Standard Transformations
  • Basic Data Transformations
  • Text Data Transformations
  • Number Data Transformations
  • Date Data Transformations
Advanced Transformations
  • Indexes and Conditional Columns
  • Grouping and Summarizing Data
  • Transposing Data
  • Pivoting and UnPivoting Data
Merging, Appending, and Updating Queries
  • Updating Workbook Queries
  • Combining Multiple Queries
  • Appending Queries
  • Utilizing a Folder of Data Files

 

Custom Columns
  • Columns From Examples
  • Custom Columns
M Language and Advanced Query Editor Concepts
  • M Language Overview
  • Parameters in Power Query
  • Maintaining Parameters
  • Custom M Function Overview
  • Custom M Functions with Parameters
  • Custom M Functions using Advanced Editor
Query Organization and Dependencies
  • Grouping Queries
  • Query Dependency View

Excel Power Query Schedule

In-Person Classes Schedule
Date/Time Event Registration
October 21, 2021
9:00 am - 5:00 pm
Excel Power Query
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List
November 18, 2021
9:00 am - 5:00 pm
Excel Power Query
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List
December 16, 2021
9:00 am - 5:00 pm
Excel Power Query
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List

Date Location Price Registration
#_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}
Live Online Classes Schedule
Date/Time Event Registration
October 15, 2021
9:00 am - 5:00 pm
Excel Power Query Class is Full. Add Your Name to the Waiting List
November 19, 2021
9:00 am - 5:00 pm
Excel Power Query Class is Full. Add Your Name to the Waiting List
December 17, 2021
9:00 am - 5:00 pm
Excel Power Query Class is Full. Add Your Name to the Waiting List

Date Location Price Registration
#_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}

Don't see a Class Date that works for you?

Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.

Public Classes

Need to Pay via an Invoice?

No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

Contact Us

Phone

817-841-9560

Email

excel@dfwexcel.com

Office Address

5608 Malvey Ave,
Suite 14620,
Fort Worth, TX 76107

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference