Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to easily automate boring Excel tasks with Power Query!. That video is uploaded by MyOnlineTrainingHub at 2020-10-14T16:00:12-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [L4BuUzccLpo]
| Name | How to easily automate boring Excel tasks with Power Query! |
| Video Uploader | Video From MyOnlineTrainingHub |
| Upload Date | This Video Uploaded At 14-10-2020 23:00:12 |
| Video Discription | 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! L4BuUzccLpo |
| Category | Education |
| Tags | power query |
