Why each and every Excel user should use Power Query
This video will show you three ways in which Power Query is an excellent upgrade to Excel tools. This video aims at everyone who thinks Power Query is just an ETL and should only be used if you need to import data into Excel. When you realize what a boost Power Querys Fill, Merge, and Split commands can be, you should immediately start using Power Query in your everyday workflows, even if you never connect it to data outside the current workbook.
You can download all the files used in this demo here: https://excelolympics.com/wp-content/...
Links to a blog post and videos that are relevant:
Ultimate Vlookup alternative? (Part 1) (Excel Unplugged) - https://bit.ly/3I9EgLt
Ultimate Vlookup Alternative? (Part 2) (Excel Unplugged) - https://bit.ly/3A1gD57
XLOOKUP is finally here (Excel Unplugged) - https://bit.ly/3ttL6re
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the video
0:56 Fill Command in Excel and Power Query
3:23 Real life example of Fill/Down and Fill/Up Use
6:10 Split
16:06 Xlookup or Vlookup vs Merge
18:20 Anti Join
19:20 Conclusion
20:22 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe to the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek