Modern Data Handling: Leveraging Power Query in Excel

Oct 28 2024

9:00 AM - 9:45 AM MT

Edu Session Room 2

Power Query is the most important change to Excel in decades. Its job is called ETL – short for Extract, Transform, and Load. This allows us to pull data from any file, database, or other source, and clean it in preparation for our analysis. If you’ve spent significant time copying and pasting information together, updating it when new data comes out, and ‘fixing it up’ to be used, this tool will be a gamechanger.

Topics include:

  • Extracting data from Excel, CSV, and other file types
  • Compiling data from multiple files in seconds
  • Combining related data faster and easier than VLOOKUP
  • Automating repetitive data handling


Knack Training

- President

© Diversified Communications. All rights reserved.