How to easily automate boring Excel tasks with Power Query!

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: https://www.myonlinetraininghub.com/introduction-to-power-query 🎓 LEARN MORE Power Query here: https://www.myonlinetraininghub.com/excel-power-query-course Or view my comprehensive courses: https://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: https://www.linkedin.com/in/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: https://www.myonlinetraininghub.com/excel-forum POWER QUERY ADD-IN Excel 2010 & 2013 users download the free Power Query add-in here: https://www.microsoft.com/en-au/download/details.aspx?id=39379 ⏲ 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!