🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.
👋 Additional resources:
- Sample files: 1drv.ms/u/s!AmxrofZZlZ-whKZQTEiA4iLu-WPiaQ?e=AkAtOi
- Download Power Query for Excel 2010 or 2013: microsoft.com/en-au/download/details.aspx?id=39379
⌚ Timestamps
00:00 Introduction
00:59 Sample data
2:14 How to get Power Query
2:31 Get data
3:35 Combine data
5:26 Main Power Query interface
7:00 Transform data
11:21 Applied steps
12:06 Close & Load
12:33 Data imported into Excel
13:34 Insert pivot table & chart
14:46 Importing additional data
16:00 Wrap up
📃 Watch related playlists and videos
- Pivot Table tutorial: youtu.be/m0wI61ahfLc
- Excel: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Power BI: youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe
🚩 Connect with me on social:
- LinkedIn: linkedin.com/in/kevinstratvert/
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
- How to use Microsoft Power Query ( Download)
- How Power Query Will Change the Way You Use Excel ( Download)
- Learn Excel Power Query to Automate Boring Tasks ( Download)
- How to use Power Query - Microsoft Excel Tutorial ( Download)
- Excel Power Query Course: Power Query Tutorial for Beginners ( Download)
- Excel Tutorial - Using POWER QUERY ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
- What is Power Query ( Download)
- Master Excel 2024: Advanced Data Analysis with Power Query, Unique & Filter Functions ( Download)
- How to easily automate boring Excel tasks with Power Query! ( Download)
- Power Query - Beginner to PRO Masterclass in 30 minutes ( Download)
- You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 ( Download)
- Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!) ( Download)
- How to use Power Query in Power BI | Microsoft Power BI for Beginners ( Download)
- Advanced Excel Power Query | Introduction | Explained in 4 Minutes | Tutorialspoint ( Download)
