Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/
Learn how to use Power Query, which is a data automation tool that allows us to import, transform, and cleanse data in Excel or Power BI. In the video I share an overview of the Power Query workflow and then go into a hands on demo. You will learn how to combine multiple CSV files, clean up the data, and automate the entire process for when you get new/updated data.
This video is an introduction for beginners. If you have tried to use Power Query, but are confused by the process or user interface, then this training is for you.
Power Query is a tool that can save you a ton of time with your work by automating common data processes like:
✔ Remove columns, rows, blanks
✔ Convert data types - text, numbers, dates
✔ Split or merge columns
✔ Sort & filter columns
✔ Add calculated columns
✔ Aggregate or summarize data
✔ Find & replace text
✔ Unpivot data to use for pivot tables
✔ Merge (join) data tables together
✔ Combine (append) data tables, sheets, and workbooks
Free Webinar on The Modern Exvel Blueprint:
excelcampus.com/blueprint-webinar
Additional Resources:
Read the companion article on an Overview of Power Query:
excelcampus.com/power-tools/power-query-overview/
Complete Guide to Installing Power Query:
excelcampus.com/install-power-query/
How to Unpivot Data with Power Query: youtu.be/Kbu5RkUo6-k
How to Fix Date Errors in Power Query: youtu.be/NZ5q5mYoFR8
00:00 Introduction
02:43 Demo
11:01 Updating and Refreshing
- How To Automate Data Tasks In Excel Using Power Query ( Download)
- Learn Excel Power Query to Automate Boring Tasks ( Download)
- How to easily automate boring Excel tasks with Power Query! ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
- Master Data Cleaning with Power Query in Excel in 9 Minutes ( Download)
- Data Cleanup in Excel with Power Query: Mastering the Ultimate Guide to Boost Your Excel Game! ( Download)
- Automate Repetitive Tasks in EXCEL (using Power Query) ( Download)
- Automate The Automation Of Boring Tasks:Save & Automate Excel Power Query Tables ( Download)
- How to use Microsoft Power Query ( Download)
- How Power Query Will Change the Way You Use Excel ( Download)
- Automate Data Tasks in Excel using Power Query ( Download)
- Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time ( Download)
- You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 ( Download)
- Automatically Move Completed Tasks to an Archive (with Excel Office Scripts & Power Automate) ( Download)
- How To Use Microsoft Power Query | Learn Excel Power Query | Automate Data Tasks | Simplilearn ( Download)
