How To Automate Data Tasks In Excel Using Power Query

Описание: Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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...

Additional Resources:

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

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

How to Unpivot Data with Power Query:    • How to Unpivot Data with Power Query in Excel  

How to Fix Date Errors in Power Query:    • 4 Ways To Fix Your Power Query Date Errors...  
00:00 Introduction
02:43 Demo
11:01 Updating and Refreshing