Power Query: Why/When Should You Use It?
Vložit
- čas přidán 19. 07. 2024
- What are the benefits of using Power Query? And how can it help you?
** LINKS **
► LEARN POWER QUERY FOR 80% OFF THIS BLACK FRIDAY: www.excelcampus.com/power-que...
► Download the workbook: www.excelcampus.com/power-too...
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) www.excelcampus.com/blueprint ~
-
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus trainings, and weekly Excel tips: www.excelcampus.com/newsletter/
-- Why Power Query?
In this video, we cover when to use Power Query, why this powerful Excel feature can save you time and money, and help with your career advancement. Power Query is one of our favorite tools to use in Excel, and in this video, we'll cover why.
**********
EXCEL-FRIENDLY ACCESSORIES WE USE: LOGITECH KEYBOARD
Check out all the tech we use and recommend at www.excelcampus.com/store
**********
~ Related Content ~
- Power Query Overview - Automate Data Tasks in Excel & Power BI: • How To Automate Data T...
- How to Combine Excel Tables or Worksheets with Power Query: • How To Combine Excel T...
#MicrosoftExcel #MSExcel #CZcamsForLearning #piecharts #charts
Related videos:
Power Query Overview • How To Automate Data T...
How to combine Excel tables and worksheets with Power Query • How To Combine Excel T...
00:00 Introduction
00:58 Benefits of Power Query
03:36 Power Query Process
05:33 Conclusions
Is a very powerful tool indeed. I use it everyday. Congrats for the video
You and @MyOnlineTraining Mynda Treacy are the Gurus of EXCEL and beyond, amazing contribution!
Power Query Is Pretty Powerful Especially When You Learn DAX And M CODE!Good Luck With The Course...Thank You Jon :)
I completely agree. Thanks Darryl! 🙂
Any suggestion on where I can find good videos for DAX?
Love the white computer!!
Looks good Jon! Good luck with the launch!!
Thanks Wayne! 👍
Thank you for all your videos! 😊
I appreciate your support, Rhea! 😊
Good job as always, you inspire me in the creation of spreadsheets for gambling. Keep doing the good job
Can't wait 💪🏽
Thanks Orel! 🙂
hello! do you sample video on how to make inventory system using VB? thank you!
Super 👌💘😘💘
Thanks Vijay! 😊
The biggest problem with PowerQuery is that it can not load a file from a OneDrive folder. It's been years and Microsoft hasn't fixed this problem. I have to keep telling my accounting folks to run their reports from a regular network drive. Otherwise, it's the most powerful tool that Microsoft has provided for Excel. I have automated some process flows that load in about 9 external files, merge, group, merge again, and do a lot of other processing.
I feel macro is easier. What's the advantage of power query vs macro if both tasks can be achieved by either?
❤️❤️❤️❤️❤️❤️(Very Nice Videos)💝💝💝💝💝💯💯💯💯💝💝💝💝💝💝💝💝💝❤️❤️❤️❤️❤️❤️❤️
Also noted a bunch of Mac's in your stock footage. Power Query does not exist in Excel for Mac.
Hey Trevor, Good news! Power Query is available on the Mac version of Excel. Here is a video where I show it. czcams.com/video/lPEDULKhgRM/video.html
The features are still limited but continue to roll out.
@@ExcelCampus That is good news! Not sure why it's taken them 12 years to start working on it and why it's still missing so many features. Seems like the main code base should be the same and it's just UI updates to add the editor. Until it's feature complete, I probably wouldn't recommend anyone use it in a mixed OS environment since passing them an Excel file from a Windows machine probably wouldn't work. At least, connection only queries are a must. Thanks for letting us know though that it's coming...