Sign up for our Excel webinar, times added weekly: [ Ссылка ]
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:
[ Ссылка ]
Additional Resources:
Read the companion article on an Overview of Power Query:
[ Ссылка ]
Complete Guide to Installing Power Query:
[ Ссылка ]
How to Unpivot Data with Power Query: [ Ссылка ]
How to Fix Date Errors in Power Query: [ Ссылка ]
00:00 Introduction
02:43 Demo
11:01 Updating and Refreshing
How To Automate Data Tasks In Excel Using Power Query
Теги
excelexcel campusPower Query Overviewpower queryexcel power query trainingexcel tips and trickspower query functionspower query tutorialpower query function power bimicrosoft power querypower query explainedhow to use power queryintroduction to power querypower query for beginnersdata automation in excelget and transformget and transform data in excelpower query combine multiple excel filescombine csv files in excel