Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to use Microsoft Power Query. That video is uploaded by Kevin Stratvert at 2020-11-24T03:00:01-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [0aeZX1l4JT4]
| Name | How to use Microsoft Power Query |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 24-11-2020 11:00:01 |
| Video Discription | ๐ฅ Learn Excel in just 2 hours: https://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: 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. 0aeZX1l4JT4 |
| Category | Science & Technology |
| Tags | kevin stratvert | power | power query | query | excel | power bi | powerbi | excel pq | data | transform | automate | macro | microsoft excel | tutorial | how to | help | combine | extract | analyze | pivot table | pivot | applied steps | step | steps | clean | clean data | code | excel 2019 | excel 2016 | excel 2013 | excel 2010 | record steps | data model | get | get data | import |
