How to use Microsoft Power Query
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: https://1drv.ms/u/s!AmxrofZZlZ-whKZQTEiA4iLu-WPiaQ?e=AkAtOi
- Download Power Query for Excel 2010 or 2013: https://www.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: https://youtu.be/m0wI61ahfLc
- Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe
🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://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 канала Kevin Stratvert
👋 Additional resources:
- Sample files: https://1drv.ms/u/s!AmxrofZZlZ-whKZQTEiA4iLu-WPiaQ?e=AkAtOi
- Download Power Query for Excel 2010 or 2013: https://www.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: https://youtu.be/m0wI61ahfLc
- Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe
🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://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 канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Power BI Tutorial for Beginners - Basics and BeyondExcel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract RecordsHow to use Power Pivot in Microsoft ExcelHow to use Microsoft Power BIDon't Use Excel Filters! Use This Incredible Excel Formula Instead ...50 Ultimate Excel Tips and Tricks for 2020How to Create Macros in Excel TutorialHow to Combine Excel Tables or Worksheets with Power QueryHow to use Microsoft Power AppsPower Query Unpivot - fix 4 common data layouts (incl. workbook)Excel Power Query Course: Power Query Tutorial for BeginnersTop 20 Microsoft Outlook Tips & TricksHow to easily automate boring Excel tasks with Power Query!🤖 How to use Microsoft Power Automate Desktop - Full tutorialHow to use Microsoft Access - Beginner TutorialHow to Merge Tables with Power Query: VLOOKUP AlternativePower BI Beginner TutorialTop 20 Microsoft Excel Tips & TricksHow to use Microsoft ListsSecrets to Building Excel Dashboards in Under 15 Minutes!