Learn Power Query in just 10 minutes to merge multiples Excel files, clean up data, and analyse it.
🔥Take our Power BI for Business Analytics course: careerprinciples.com/courses/power-bi-for-business-analytics
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/643016e36c3e6e7d2a97f028
LEARN:
🔥Power BI for Business Analytics: careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: careerprinciples.com/courses
PowerQuery is one of the most powerful tools that you can use for Excel and Power BI. In this tutorial, we teach you how to use it from scratch. First, we learn how to import multiple excel files into one for further analysis. Then, we learn how to clean up data in Power Query which is much faster than Excel. Finally, once the data is clean up, we upload it onto excel for further analysis using Pivot Tables. We also see how adding new data affects the analysis.
SOCIALS:
🎬 My Company YouTube Channel: youtube.com/@careerprinciples
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑💻 LinkedIn - linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:22 - Combining Multiple Excel Files
2:08 - Cleaning up the Data
6:28 - Analysing the Data with Pivot Tables
7:25 - Adding more Data
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
- Learn Excel Power Query to Automate Boring Tasks ( Download)
- How to easily automate boring Excel tasks with Power Query! ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
- How Power Query Will Change the Way You Use Excel ( Download)
- 𝐌𝐈𝐂𝐑𝐎𝐒𝐎𝐅𝐓 𝐏𝐎𝐖𝐄𝐑 𝐐𝐔𝐄𝐑𝐘 𝟐𝟎𝟐𝟒 / 𝐋𝐞𝐚𝐫𝐧 𝐄𝐱𝐜𝐞𝐥 𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲 𝐭𝐨 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 𝐁𝐨𝐫𝐢𝐧𝐠 𝐓𝐚𝐬𝐤𝐬 ( Download)
- How to use Microsoft Power Query ( Download)
- Automate The Automation Of Boring Tasks:Save & Automate Excel Power Query Tables ( Download)
- How to Use Microsoft Power Query | Automate Boring Tasks ( Download)
- You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 ( Download)
- How to use Power Query - Microsoft Excel Tutorial ( Download)
- Learn Excel VBA to Automate Anything ( Download)
- How to use Office Scripts and Power Automate to do Boring Excel Tasks for You ( Download)
- Learn Excel Power Query to Automate Boring Tasks | Amazing Trick for Using on Database | (Part-1) ( Download)
- Why EVERY Excel User Needs Power Query & Power Pivot ( Download)
- I don't use PIVOT tables anymore... I use this other thing instead! ( Download)
