Skip to main content
Adobe training, UX Courses, and Photoshop Classes at AGI
Secondary
  • Why AGI
  • About
  • Contact
  • Locations
  • All classes
  • Cart
  • Log in
Search
Search
Main menu
  • Classes & Workshops
    • Classes & Workshops
    • Column 1
      • Adobe Courses
      • Photoshop
      • InDesign
      • Illustrator
      • Premiere Pro
      • After Effects
      • Animate
      • Acrobat
      • Captivate
      • Creative Cloud
      • AI Classes
      • Chat GPT
      • Copilot
      • Claude AI
      • Gemini
      • Animation
      • Motion Graphics
      • After Effects
      • Animate
      • Blender
      • Cinema 4D
      • Maya
      • Digital Marketing
      • Google Analytics
      • Google Tag Manager
      • HTML Email
      • Digital Marketing Certificate
      • Elearning
      • Captivate
      • Camtasia
    • Column 2
      • Figma
      • Figma Introduction
      • Advanced Figma
      • Figma Design Systems
      • Figma Bootcamp
      • Graphic Design Courses
      • Graphic Design Course
      • AI Graphic Design Course
      • Graphic Design Certificate
      • Graphic Design for High School Students
      • Canva
      • Data Visualization
      • Office Skills
      • Excel
      • Power BI
      • PowerPoint
      • Keynote
      • Access
      • Teams
      • Google Docs
      • Presentation Design
      • PowerPoint Design
      • Keynote Presentation Design
      • Tableau
    • Column 3
      • UX Courses
      • UX Design
      • UX Research
      • Information Architecture
      • Rapid Prototyping
      • UX for Mobile & Touch
      • Figma
      • UX Certification
      • UX Design Certificate
      • Design Thinking
      • Video Editing Courses
      • Video Production
      • Premiere Pro
      • After Effects
      • DaVinci Resolve
      • Final Cut
      • Video Editing for High School Students
      • Web Accessibility
      • Web Accessibility
      • Section 508
      • Accessibility for Designers
      • InDesign Accessibility
      • MS Office Accessibility
    • Column 4
      • Web Design
      • WordPress Classes
      • HTML
      • CSS
      • Responsive Web Design
      • Web Design Certificate
      • Web Graphics
      • Web Design for High School Students
      • Web Development
      • Agile
      • CSS
      • HTML
      • JavaScript
      • Python
      • WordPress
      • 3D Design
      • 3DS Max
      • After Effects
      • Blender
      • Cinema 4D
      • Maya
      • Motion Graphics
      • Sketchup
      • See All Classes
  • Online Training
    • Online Training
    • Column 1
      • Adobe Classes
      • Photoshop
      • InDesign
      • Illustrator
      • Premiere Pro
      • After Effects
      • Animate
      • Acrobat
      • Captivate
      • XD
      • Creative Cloud
      • All Adobe
      • Digital Marketing
      • HTML Email
      • Google Analytics
      • Google Tag Manager
      • Digital Marketing Certificate
    • Column 2
      • Elearning
      • Captivate
      • Camtasia
      • Graphic Design
      • Graphic Design Course
      • Graphic Design Certificate
      • Design Thinking
      • Office Skills
      • PowerPoint
      • Keynote
      • Excel
      • Access
      • Google Docs
      • Presentation Design
      • PowerPoint Design
      • Keynote Presentation Design
    • Column 3
      • UX Courses
      • UX Design
      • Information Architecture
      • Rapid Prototyping
      • UX for Phone & Touch
      • Figma
      • UX Certification
      • UX Design Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • DaVinci Resolve
      • Final Cut
      • Web Accessibility
      • Web Accessibility
      • Section 508
    • Column 4
      • Web Design
      • Web Design Certificate
      • WordPress
      • HTML
      • CSS
      • Responsive Web Design
      • Web Graphics
      • Web Development
      • JavaScript
      • HTML
      • CSS
      • Drupal
      • WordPress
      • CAD & 3D Design
      • Sketchup
      • 3DS
      • Maya
      • See All Classes
  • Certificate Programs
    • Certificate Programs
    • Column 1
      • AI Certificate
      • Graphic Design Certificate
      • Video Editing Certificate
      • Digital Marketing Certificate
    • Column 2
      • UX Design Certificate
      • Web Design Certificate
      • Web Development Certificate
    • Column 3
      • Photoshop Certificate
      • All Certificate Programs
  • Adobe Training
    • Adobe Training
    • Column 1
      • Photoshop
      • InDesign
      • Illustrator
      • Animate
      • Acrobat
    • Column 2
      • Premiere Pro
      • After Effects
      • XD
      • Captivate
      • Connect
    • Column 3
      • Creative Cloud
      • Adobe Express
      • Dreamweaver
      • AEM Forms
      • InCopy
      • All Adobe Classes
      • See All Classes
  • Corporate Training

  • Why AGI
  • About
  • Contact
  • Locations
  • All classes
  • Cart
  • Log in
Breadcrumb
  1. Home
  2. Excel Classes
  3. Microsoft Excel Classes Online
  4. Power Query Course Online June 1, 2027
See how live online training works in this brief video.

See how live online training works in this brief video.

Learn more about Online classes

All Excel classes include

free retakes of courses Free retake

Curriculum provided Detailed curriculum

Live instructor Live instructor

flexible rescheduling Flexible rescheduling

flexible rescheduling Certificate of Completion

small class Small class sizes

course recording Course recording

Power Query Course Online June 1, 2027

Power Query Course

Tue, Jun 01 2027
10:00 am to 5:00 pm
Online Training

$295.00

Register
See other dates for this Power Query Course

Learn Power Query for use in Excel and Power BI. In this hands-on course, discover how to connect data from files, folders, and the web, then clean, reshape, and combine it into analysis-ready tables that refresh with a single click. Build reusable queries that keep working as your data changes, load them into Excel reports or Power BI models. Understand when to use each tool.

Introduction to Power Query in Excel and Power BI

Understand what Power Query is, why it is the same engine in Excel and Power BI, and how it replaces manual, repetitive data preparation.

  • What Power Query is and why it matters
  • The data analysis process: extract, transform, load, and refresh
  • One engine in two applications: what is the same and what is different
  • Opening the Power Query Editor in Excel (Get & Transform) and in Power BI Desktop (Transform data)
  • Navigating the Power Query Editor
  • Power Query options and settings
  • How Applied Steps record and replay your work
  • Structuring source data for Power Query
  • Refreshing queries

Connecting to Data Sources

Bring data in from the files and systems you already use, and keep the connection live for future refreshes.

  • Importing from Excel workbooks and worksheets
  • Importing CSV and text files
  • Importing from a folder of files
  • Importing tables from web pages
  • Importing tables from PDF files
  • Connecting to files stored in SharePoint and OneDrive
  • Editing data source settings and changing file locations
  • Connector differences between Excel and Power BI

Cleaning and Transforming Data

Fix the common problems in raw data so it is accurate and consistent before analysis.

  • Setting and correcting data types
  • Removing, renaming, and reordering columns
  • Removing blank rows, errors, and duplicates
  • Removing top and bottom rows
  • Filtering and sorting rows
  • Trimming, cleaning, and changing the case of text
  • Splitting and merging columns
  • Splitting columns into rows
  • Replacing values and filling down blank cells
  • Extracting text, dates, and parts of dates
  • Math calculations on columns
  • Date and duration calculations
  • Adding conditional and custom columns
  • Creating columns from examples

Reshaping Report-Style Data

Turn presentation-friendly reports into analysis-ready tables.

  • Recognizing analysis-ready data versus report layouts
  • Promoting and fixing column headers
  • Removing subtotal and total rows
  • Unpivoting columns into rows
  • Pivoting rows into columns
  • Transposing tables
  • Summarizing data with Group By
  • Grouping by dates and times

Combining Data from Multiple Sources

Bring related data together from multiple tables, files, and systems into a single, consistent table.

  • Appending queries to stack similar tables
  • Combining all files in a folder into one query
  • Combining multiple sheets from a workbook
  • Handling new or renamed columns in incoming files
  • Merging queries to look up and join data
  • Merging on multiple key columns
  • Choosing join types: left outer, inner, full outer, and left and right anti joins
  • Using fuzzy matching to merge inconsistent values

Building Reliable, Reusable Queries

Organize and troubleshoot queries so they keep working as data changes and can be maintained by others.

  • Referencing vs. duplicating queries
  • Staging queries and connection-only loads
  • Viewing query dependencies
  • Organizing queries into groups
  • Deleting queries
  • Using data profiling to check column quality and distribution
  • Finding and fixing errors that break a refresh
  • Creating parameters for file paths and filter values
  • Reading and editing M code in the formula bar and Advanced Editor
  • Creating a date table with Power Query
  • Query folding basics for database sources

Power Query in Excel

Put queries to work in Excel with the right load and refresh settings, refreshable reports, and Copilot in Excel.

  • Load options: table, PivotTable, connection only, and data model
  • Refresh options: refresh on open, background refresh, and timed refresh
  • Building a refreshable PivotTable report with slicers
  • Exploring query results with Copilot in Excel
  • Reviewing and validating AI-generated results
  • Sharing workbooks that contain queries

Power Query in Power BI

Put queries to work in Power BI, from loading the model to publishing and scheduled refresh, and learn how to move work between Excel and Power BI.

  • Loading queries into the Power BI model
  • Enable load and include in report refresh settings
  • Building a quick report from query output
  • Publishing to the Power BI Service and scheduling refresh
  • When a gateway is needed for on-premises data
  • Power Query Online and dataflows: an overview
  • Moving queries from Excel to Power BI
  • Choosing when to use Excel, Power BI, or both
See all Excel classes, See all Microsoft Office classes, See all Power BI Courses
Register
See other dates for this Power Query Course

Why Excel classes at AGI are the best option for you

  • Hands-on learning: Learn Excel quickly with our proven teaching methods.
  • Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
  • Expert instructors: Our instructors are Excel experts and skilled educators.
  • Small class sizes: Receive personalized attention with 10 or fewer participants per class.
  • Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.
Footer
  • 781-376-6044
  • CONTACT US
  • SEE ALL AGI TRAINING LOCATIONS

© Copyright 2002 - 2026 American Graphics Institute