Рет қаралды 1,551,874
Learn how Power Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button!
🔻 DOWNLOAD files for this lesson here: www.myonlinetraininghub.com/i...
🎓 LEARN MORE Power Query here: www.myonlinetraininghub.com/e...
Or view my comprehensive courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
POWER QUERY ADD-IN
Excel 2010 & 2013 users download the free Power Query add-in here: www.microsoft.com/en-au/downl...
⏲ TIMESTAMPS
0:00 What is Power Query
0:27 Where to find Power Query
1:14 Why should you use Power Query
3:44 Power Query example - get files from a folder
6:04 Power Query Editor - cleaning the data
13:37 Close & Load Options
14:27 Building PivotTables from Power Query data
15:37 Updating with new data with one click!