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: myonlinetraininghub.com/introduction-to-power-query

🎓 LEARN MORE Power Query here: myonlinetraininghub.com/excel-power-query-course

Or view my comprehensive courses: 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: 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: myonlinetraininghub.com/excel-forum

POWER QUERY ADD-IN
Excel 2010 & 2013 users download the free Power Query add-in here: 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!

• How to easily automate boring Excel tasks with Power Query! ( Download)
• Learn Excel Power Query to Automate Boring Tasks ( Download)
• Automate The Automation Of Boring Tasks:Save & Automate Excel Power Query Tables ( Download)
• Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
• How To Automate Data Tasks In Excel Using Power Query ( Download)
• How to use Office Scripts and Power Automate to do Boring Excel Tasks for You ( Download)
• Efficient Data Preparation: Automating BORING Tasks with Power Query! ( Download)
• Automate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports ( Download)
• Automate Excel with Office Scripts and Power Automate ( Download)
• How to present easily automate boring Excel tasks with Power Query ( Download)
• AUTOMATE EXCEL USING CHATGPT ( Download)
• Power Query is a tool in Excel to automate data preparation procedures. snapreportschamp.com/course ( Download)
• How to Use Microsoft Power Query | Automate Boring Tasks ( Download)
• Automate Boring Excel! ( Download)
• 𝐌𝐈𝐂𝐑𝐎𝐒𝐎𝐅𝐓 𝐏𝐎𝐖𝐄𝐑 𝐐𝐔𝐄𝐑𝐘 𝟐𝟎𝟐𝟒 / 𝐋𝐞𝐚𝐫𝐧 𝐄𝐱𝐜𝐞𝐥 𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲 𝐭𝐨 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 𝐁𝐨𝐫𝐢𝐧𝐠 𝐓𝐚𝐬𝐤𝐬 ( Download)