I can't emphasize just how good a job you do presenting this information. Everything about this is perfect, the pacing, the attention to details and thoroughness, the progression, the actual use and story of it, diagrams.. Plenty I haven't touched on. Thank You so much for sharing this, you must have improved a great many lives. I'm so happy I don't have to feel the life draining out of me like so many other videos out there!
@ExcelCampus
3 жыл бұрын
Glad you enjoyed it! Thanks! 😊
@smam60
Жыл бұрын
"feel the life draining out of me!" 😁👍. Yep-same here but you described it perfectly!
@fanp1188
Жыл бұрын
Others say it and I wholeheartedly agree - spend a few minutes in Excel Campus and you'll get the basics that are clear are easy to remember. When someone learns or retains something 'easily' it's in part down to the teacher Really knowing the subject. Thank you 🎉
@ExcelCampus
Жыл бұрын
Wow! Thank for your kind words @fanp1188 ! 😀
@smam60
Жыл бұрын
Awesome job consolidating all this info into fifteen minutes! If someone is experienced with Excel they really don't need a three hour introduction to understand what Power Query is. Too much information is overwhelming, which keeps us from even trying. After watching this I finally "get it" and am ready to try this the next time I clean up data. Thank you so much!
@jenniferwoodard837
3 жыл бұрын
Thank you for including the "why" and not just steps! It makes things easier to understand and apply in different situations. As an educator that's one of my pet-peeves, and you do a fabulous job. I wish I'd found your video first, and I look forward to seeing more videos.
@debraindxb
3 жыл бұрын
Ditto. I am a data analyst with a master's degree in Education. Jon has hit all the important instructional bits to make his instruction successful.
@keira7360
2 жыл бұрын
Omg can’t believe I finally found you I’ve watched 5 vids so far and everything is just so extraordinary, super simple to understand. You’re the best instructor I’ve ever seen in my 29yrs of living
@tariq313313
4 жыл бұрын
Excellent presentation. Your English Speaking is understandably clear and pleasant to non-English persons.
@esthersuh3388
2 жыл бұрын
Surely Iwould become "EXCEL HERO" with your excellent instructions and videos. Thank you trillions!
@raymondpang4138
4 жыл бұрын
Having seen videos on PowerQuery presented by other people, I have learned a lot from you, as I like the way you organized & presented your material, which made it easier for me to understand.
@ps7424
4 жыл бұрын
100% agree. really good presenter
@maksms
2 жыл бұрын
This was such an extraordinary video which made me understand the very basics of power query. I also appreciate your communication which is crystal clear, no repetitions and great with your subject matter. More than everything I really appreciate creating such educational videos which help people like us to get knowledge free of cost. Thank you so much.
@brucesun4148
4 жыл бұрын
Thanks for sharing! Excel has evolved into a such powerful data tool ! It’s basically becoming an agile version of a mixture of power BI, Access, and traditional excel !
@ExcelCampus
4 жыл бұрын
Thanks Bruce! Yes, great point about the evolution of Excel. I love it! 👍
@christianofernandes7682
3 жыл бұрын
We are blessed with people like you
@peteallennh
Жыл бұрын
Brilliant. This was perfectly presented. I have done the same thing over and over again. I never knew the refresh option works like that. I can’t wait to improve my workflow to do this. Thank you!
@ExcelCampus
Жыл бұрын
Great to hear that, Pete! 😀
@RaviKumarCreativeCorner
2 жыл бұрын
wow, excellent. i used think that it is very hard to learn excel but after watching your videos, i have learned so much. Thank you
@oldrunnerstepx2638
Жыл бұрын
Jon, this video is a crystal-clear explanation and demonstration of a very powerful Excel feature. Very impressed by the quality of this video, have now subscribed as the Power Pivot and Pivot Tables parts look interesting too. I already use Pivot Tables but I'm sure your video will fill in any gaps on my knowledge.
@2bczar4u
2 ай бұрын
The 'why' was long overdue. Excellent presentation as always. A waaaaaaaay back I didn't connect with the removal of columns in the process steps as it was never explained. It took a bit and then the lights went on, lol. I don't use PQ as much as I should, more because I am so rushed in what I need to get done and have a hard time squeezing in the extra timing time and practice. However, as time marches on it becomes easier and easier to use the product. Thank you.
@tracywilliams61
Ай бұрын
You have an excellent way of explaining /training. I’ve learned so much in the first two videos I watched today and can’t wait to put them in practice
@jchung5066
3 жыл бұрын
i follow you and ExcelIsFun! you guys are my heroes!!!
@Zandor434
3 жыл бұрын
This is great. i watched hours of videos on this topic months ago and battled through many of the ins and outs you described. Your video summarizes the business reasons behind this type of analysis so well. Thank you for taking the time to present this in such a digestible manner. I'll be taking your webinar at the first opportunity.
@niruramananthan3524
4 жыл бұрын
You have made such a difficult Excel topic easy to understand. thank you
@RAEN74
2 жыл бұрын
amazing as always!!! thanks for all your assistance over the years
@markanthony7078
2 жыл бұрын
Thank you soo soo much Jon for this free webinar and lectures you do. You are Amazing and I cannot wait to enroll on one of your programs fairy soon. Your teaching is to the point. This video really helped me on a difficult rushed project today. See you on one of your courses very soon, From UK.
@BenDieselBasicAutomotive
Жыл бұрын
Thank you for simplifying a very complex topic.....
@ExcelCampus
Жыл бұрын
You're welcome, Ben! :)
@samk.970
3 жыл бұрын
The most insightful Power Query intro. Thanks Jon for the share, keep them coming.
@dorcasnjeri9335
2 жыл бұрын
Very, very informative. Thank you
@jiexi144
4 жыл бұрын
Very clear explanation, easy for beginner to start with.
@canshocked2579
3 жыл бұрын
Very professionally presented.
@edgarmachado6008
3 жыл бұрын
Very well done. Clean presentation. Succinct, clear, easy to follow, and understand.
@madhavdhungel6211
2 жыл бұрын
Great, its really valuable presentation for skills enhancement. Thank you very Much
@WeekendMuse
4 жыл бұрын
One of the best videos introducing to Excel Power Query. Well done.
@ExcelCampus
4 жыл бұрын
Glad you liked it! 😀
@livvyramsden2747
3 жыл бұрын
Great presentation. Logical steps and easy to undertstand
@abomohnd9004
4 жыл бұрын
Short ,smart and to the point Thanks ☺️
@ExcelCampus
4 жыл бұрын
Thank you Abo! 🙌
@hichamsouleimani1920
4 жыл бұрын
Concise demonstration. Thank you.
@abdullahalnaiem3501
2 жыл бұрын
You are the best. I am naiem from Bangladesh.
@wpfavicon6776
3 жыл бұрын
Great and amazing tutorial. John!
@poweruser5391
4 жыл бұрын
Really got engage with the way you explain your videos. Very organize and precise information. Kudos!
@ExcelCampus
4 жыл бұрын
Glad you like them! 😊
@sedarathnadcd
2 жыл бұрын
Thank You, It is really a important
@conradhaynes4672
2 жыл бұрын
An absolutely superb presentation, thank you.
@danielvasquez2034
4 жыл бұрын
great video! power query is a major time saver
@wayneedmondson1065
4 жыл бұрын
Hi Jon.. excellent overview of the power of Power Query. Thanks for the video! Thumbs up!!
@esbi1124
4 жыл бұрын
Really good and clear as usual. Thanks a lot.
@benjamindale6989
3 жыл бұрын
Very concise, simple and informative. Great video!
@AlbrechtJ
2 жыл бұрын
Thanks for this helpful tutorial.
@guitar007
4 жыл бұрын
Thanks man, very clear presentation and very helpful !
@mypalbill
3 жыл бұрын
Excellent session and tutorial, thanks!
@dodettesky2587
3 жыл бұрын
Amazing tool and amazing presentation! Very easy to follow.
@manteeful
3 жыл бұрын
Great Tutor. Amazing Presentation.
@charlesmangezi9564
2 жыл бұрын
thanks, fantastic work
@joielou6544
2 жыл бұрын
Your videos are excellent!!!
@marshallhosel1247
2 жыл бұрын
Useful tutorial. Thank you!
@enochopolot333
4 жыл бұрын
Very clear and concise presentation. I'm eager to give it a go. Thanks again.
@luciaderatmiroff1173
4 жыл бұрын
I love your videos. Explanations are understandable and to the point. I am an older follower, do a lot of stats for non-profits as volunteer, and I work on Mac OS. Sometimes it is difficult to apply your videos, but I will try with this one because it will save me tons of time! Thanks.
@ExcelCampus
4 жыл бұрын
Thanks Lucia! I appreciate your support. In regards to Power Query on the Mac, it is not fully available yet for the Mac version of Excel. However, Microsoft is working on making it available and currently in phase 1 of the project. This means you can only refresh queries on the Mac. You cannot create or edit them yet. Here is an article that explains more (techcommunity.microsoft.com/t5/excel-blog/get-amp-transform-power-query-in-excel-for-mac-phase-1/ba-p/876840) One workaround is to install a virtualization app like Parallels (www.parallels.com/) on your Mac. This will allow you to run Windows on your Mac and install the Windows version of Excel. If you have an Office 365 subscription then the Windows version of Office will just count as one of your users. You will then be able to use all "power" tools including Power Query, Power Pivot, Power BI and full VBA. I hope that helps. Thanks again and have a nice day! 🙂
@ec4ever9
4 жыл бұрын
@@ExcelCampus Thanks for the question Lucia and thanks for your response Jon. I've been sitting on my Mac for days trying to figure out how to Get & Transform and apparently it's not available yet. You both saved me some time and maybe a couple headaches.
@HSfox
3 жыл бұрын
This is great!! Thanks :D I feel like I've spent soo much time cleaning data and never cared for power query :( I was dumb to think that
@gaetanomaximus8650
2 жыл бұрын
Awesome, thanks!
@cq1026
3 ай бұрын
Super helpful - thank you!
@leoace9903
3 жыл бұрын
Thank you, you are my excel hero! 😘
@SonofthewindsInc
4 жыл бұрын
I will be using this in ,multi data disciplines. Thank you... more power at my work place!
@SolidSnake009
4 жыл бұрын
Excellent and effective presentation. Thank you!
@ExcelCampus
4 жыл бұрын
You're very welcome! 😊
@famousboyboy7426
4 жыл бұрын
Great video
@丁昌
5 ай бұрын
excellent teaching
@ajvalerio7377
4 жыл бұрын
This is the most helpful tutorial I found on the net. Very easy to follow. Thank you very much!
@Juan-Hdez
Жыл бұрын
Very useful. Thank you!
@sofianalhammouti4890
4 жыл бұрын
Your presentation is amazing!!
@abiashyt3604
4 жыл бұрын
Thanks for tutorial.Its really helpful
@a3akfmobile
4 жыл бұрын
Many many thanks. New and beneficiary to me.
@sonjavangaale8373
3 жыл бұрын
Excellent thank you for this presentation.
@eilleensabino-laughlin7067
2 жыл бұрын
This is awesome! So happy I found your page 😀
@michaeltobiko
2 жыл бұрын
Thank you for sharing this 🙏
@trueaccounting3308
4 жыл бұрын
Awesome. I love your detailed expression and they are easy to learn.
@ExcelCampus
4 жыл бұрын
Glad you love them! Thank you!
@BirdsallDave
3 жыл бұрын
Nice video, thanks! So, I'm a long-time SQL user, but I am trying to put together an Excel spreadsheet without an SQL database behind it for some folks who don't have access to an SQL database. I have a few simple tables that I want to join together, and use like an SQL materialized view. I've played with putting each table in a sheet, then using Power Query to join them in a new sheet. This works fairly well. And I find that indeed if I change data in the source tables and hit "Refresh All", the joined data updates nicely. Next thing I tried was saving the Excel workbook, exiting Excel, then opening the workbook again. Then I wanted to repeat the exercise: update one of the source tables, then hit "Refresh All" to see the joined data automagically updated. This doesn't work, though; Excel complains about connections. So here's my question: Can one make re-establishing connections automatic, so that there aren't any extra steps when reopening the workbook?
@ExcelxlNl
4 жыл бұрын
An awesome introduction tutorial and a very good explanation. Thank you!
@ExcelCampus
4 жыл бұрын
Thanks! :-)
@LP-sy3md
3 жыл бұрын
Very well explained! You make everything sounds so simple!
@amospan14
14 күн бұрын
I appreciate this lesson!
@ExcelCampus
13 күн бұрын
Glad to hear that! 😀
@lindsaywilliams2727
4 жыл бұрын
Excellent introduction - Thanks Jon
@ExcelCampus
4 жыл бұрын
Thank you Lindsay! I appreciate your support! 🙌
@abdessamedghettas7167
2 жыл бұрын
Just great video many Thanks.
@orelshema
4 жыл бұрын
Excellent Guide!
@sahiguru4913
3 жыл бұрын
Well explained and presented.
@SteamPunk4Life
3 жыл бұрын
Thanks, John for the awesome tutorial.
@asddsa8203
4 жыл бұрын
Darn, I could have saved a lot of time on friday if I watched this video earlier!
@RenRen007
4 жыл бұрын
Effing same! Lil
@GusGuitarPD
4 жыл бұрын
Awesome video. Thank you so much!
@sijuvarghese5469
3 жыл бұрын
Thank you.
@devenderpratap7987
4 жыл бұрын
Wonderful presentations Jon!. I learned a lot from this
@toby-tobias3651
3 жыл бұрын
Amazing video content John, learning a lot from you! Thanks
@Abbasshaha
4 жыл бұрын
excellent presentation
@AJ-alt
3 жыл бұрын
Great video! What Id like to know is when you close the sheet where you merge the files, where does it go or is it something that you can save as an Excel sheet? 2. You show how to combine the results in one sheet, what if I want the Applied Steps to be applied on individual sheet because the report should be separate instead of merge reports. This is for my daily and weekly reports. Thanks!
@anabusso7065
4 жыл бұрын
,excellent!
@Leo-yz5gf
4 жыл бұрын
Thank you so much. Clear and concise, among the best tutorial i could find!
@ScotTheGr8
2 жыл бұрын
So helpful!!!!
@mahansor8295
3 жыл бұрын
Thanks 👍
@andyan1830
3 жыл бұрын
man, this is poweful! Great Vid!!
@ArushiNegi-pc6xi
3 жыл бұрын
Great video!. Please share sample data to practice.
@devenderpratap7987
4 жыл бұрын
This put me into this wonderful concept during the lockdown time where we hardly had any software loaded in our laptop. This is awesome and magic bullet. But, tell me weather it can handle calculated columns
@CW-si7ib
4 жыл бұрын
very good tutorial! thank you
@ExcelCampus
4 жыл бұрын
Glad you like it! :)
@Mohammedshafi-Msk
4 жыл бұрын
wow! it is unbelievable
@kristinamelnichenko5775
3 жыл бұрын
Awesome, thank you!
@felipelandim2881
4 жыл бұрын
Very very interesting.
@mikeschwegler3509
4 жыл бұрын
Thank you! This was great!
@36chethan
4 жыл бұрын
We can also right click on date column and select change type and select using locale.. select date from drop-down and change to us or your country type no need to add column and again delete date column btw i got to know the alternative.. l like this
@saifullahkowshir
3 жыл бұрын
Thank you,
@knguyen9371
4 жыл бұрын
Thank you so much Jon. Very appreciated your knowledge sharing 👏
Пікірлер: 281