# @udemy on YouTube

- **Type:** Video
- **Original URL:** https://youtube.com/watch?v=qaESbmMYA-0
- **Gondola URL:** https://gondola.cc/posts/72078181-udemy-youtube
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/f05c7d2883.jpg
- **Posted:** 2019-03-21T20:51:13.000+00:00
- **Account Owner:** Udemy (@udemy) — https://gondola.cc/udemy

## Caption

Sick of manual data cleanup? Discover how Power Query can transform, automate, and supercharge your Excel workflow! 🧠

In this fast-paced tutorial, Chris Dutton walks through connecting to a CSV, filtering large datasets, and loading clean, structured data straight into Excel. Learn to automate with applied steps, pivot your insights, and keep your data dynamic with just a few clicks.

✨ What you’ll learn:
How to use Power Query to connect and transform data
Filtering, reshaping, and automating ETL workflows
Creating reusable queries that update with one click

⏱️ Timestamps:
00:00 – Power Query Overview
00:45 – Connecting to CSV with Get & Transform
01:30 – Using the Query Editor
02:15 – Applied Steps & Data Shaping
03:30 – Filtering & Transforming Data
05:00 – Loading to Table vs. Data Model
06:20 – Editing Queries to Update Automatically
08:00 – Pivoting for Insight
09:00 – Real-Time Refresh with Modified Queries

🔗 Resources:
📘 Course: https://www.udemy.com/course/microsoft-excel-pro-tips-for-power-users
👨‍🏫 Instructor Profile: https://www.udemy.com/user/maven-analytics/
📚 Explore More Excel Courses: https://www.udemy.com/topic/excel/

👍 Found this useful? Give it a like, leave a comment, and subscribe for more!

#PowerQuery #ExcelAutomation #ETL #DataTransformation #ExcelTips

## Stats

- **Views:** 23,298
- **Likes:** 67
- **Shares:** 0
- **Comments:** 3

## Tags

exceltips, etl, excelautomation, powerquery, datatransformation

---
Copyright (c) Gondola