Sign up for our Excel webinar, times added weekly: https://www.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:

https://www.excelcampus.com/blueprint-webinar

Additional Resources:

Read the companion article on an Overview of Power Query:
https://www.excelcampus.com/power-tools/power-query-overview/

Complete Guide to Installing Power Query:
https://www.excelcampus.com/install-power-query/

How to Unpivot Data with Power Query: https://youtu.be/Kbu5RkUo6-k

How to Fix Date Errors in Power Query: https://youtu.be/NZ5q5mYoFR8
00:00 Introduction
02:43 Demo
11:01 Updating and Refreshing