🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@makainoe53852 жыл бұрын
I know it is pretty randomly asking but do anyone know a good website to watch newly released series online?
@RrwebservicesIndia Жыл бұрын
Hey Kevin, watched a video couple of days back and was tempted to watch something again and here I landed. Your face has a brand value :) Silly Question - Which version of MS Excel has this Analyze Data feature?
@mdtaylor22743 жыл бұрын
You're ridiculously good at everything you do. I can't thank you enough for the value you add to the viewing community. Thanks a million Kevin!
@naveedwantt28462 жыл бұрын
Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@minabekheet4076 Жыл бұрын
" Ridiculously good" strong phrase
@TylerStanczak3 жыл бұрын
Pivot tables have been such a game changer to analyze data with ease. Thanks for sharing these helpful tips :)
@kanurajsingh7409 Жыл бұрын
this video is a game changer for me to upgrade myself from beginner to advanced on pivot tables. In just 16 minutes of video, you easily explained so many useful tools like slicer, timeline, pivot chart, sorting, grouping etc. Thanks dude. Gave thumbs up to the video
@sandrahanson91133 жыл бұрын
Setting up default pivot table layouts. Kevin you are my hero!
@cycleSCUBA2 жыл бұрын
Wasn't aware of the Analyse Data option first, and the dufferent data views it gives in addition to PT's. Thanks so much for this 👍
@iKnowledgeSchool2 жыл бұрын
Analyze data is one of the best tips, totally agree
@SavageGothamChess3 жыл бұрын
I really enjoyed this tutorial. Love that section where you c overed how to customize a raw lable. The smile on your face brightens many peoples' days including me. Thanks for the tutorial.
@JustBlankNoInfo3 жыл бұрын
Congrats on 200 subs Hovindu! All the best to you to reach 1000 soon!
@AaronWesson4 ай бұрын
I have been using Pivot tables for years, and through this video, I have learned a few more things. Thank you!
@crescenzocommunications42902 жыл бұрын
Kevin, your videos are the best out there! Thank you so much for your insights and expertise! One request is using pivot tables to analyze survey data. I know the general principles are the same, but I'd be interested in seeing how you organize and group survey data to get the most intuitive reports and visualizations. Again, thank you!
@naveedwantt28462 жыл бұрын
Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me
@sonyamorton75733 жыл бұрын
Awesome tips for Pivot Tables. Adding a calculated column is going to change my game! THANKS😊
@andy_kng2 жыл бұрын
Wow, amazing video. I've used Pivot tables for years and I'm blown away. Thank you
@ZoarkadoZenos3 жыл бұрын
I didn't know the existence of slicer till now. OMG, you are a lifesaver and a timesaver!
@yquintana56733 жыл бұрын
Thank you for this! I often forget how to build a pivot table and now I can save this video for next time.
@nigelfreeman61923 жыл бұрын
This video couldn’t have come at a better time. Thanks great instructional video 👍
@niiikhiiil3 жыл бұрын
Amazing! This is like Power Bi reports on budget! I know its an exaggeration but most needs are fulfilled by pivots. Thanks Kevin. I have learnt a lot about Microsoft products from you than anyone else. That too in short time.
@jitkaobrien28133 жыл бұрын
Hi Kevin, I am so glad I discovered your videos. I started watching yesterday and back today, already learnt so much. Thank you.
@MissZia2 жыл бұрын
Thank you Kevin. I am learning all tricks and tips from your videos. You are calm, making it so easy to understand the steps.
@toryrusso5203 жыл бұрын
Kevin, Thanks again. I find these Excel Pivots & PowerBi videos so useful. I learn something new. Keep these coming!!
@annemariemare94582 жыл бұрын
Kevin this was amazing! Been using Pivots forever and learned a few new nifty things! Thanks!
@silversolver78093 жыл бұрын
That is a great video Kevin! I've been using pivots for over a decade and learned a lot, thank you :)
@adinacameliacernea9953 жыл бұрын
Thank you Kevin! This has been so helpful. Your videos are great to watch, understand and very informative.
@marcellef83023 жыл бұрын
Wow, this is fantastic! Thank you, Kevin 😁👍
@JustBlankNoInfo3 жыл бұрын
I have learnt this in my school! This is just an awesome Brush Up Session!
@LearnExcelwithRafi Жыл бұрын
From my professional career, Kevin video help me a lot. Thank you Kevin . You are my inspiration. I have been following you with my another Id since 1year. Now i also trying to share my knowledge through youtube like you.
@chrisguerrero5571 Жыл бұрын
Kevin just got a promotion from me!!! He’s my executive educator!! THANK YOU!!!
@romelevangelista16973 жыл бұрын
Hi Kevin. I share the same with others, love your signature intro. Been a fanatic follower of your uploads on YT even before you left Microsoft. You really raise the bar of learning and tutorials..direct..intuitive.. no nonsense! Keep it coming bro :-). Thank you
@naveedwantt28462 жыл бұрын
Hey, can u please help me with this question... Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@tmyanh19933 жыл бұрын
Great. Your tips help me a lot when working with a lot of tables. Now I learned a lot.
@gajabathiarjuntg23903 жыл бұрын
Great video Kevin. This is detailed view on Pivot Tables. Thanks Kevin 😀
@franksaieva4952014 Жыл бұрын
Hi Kevin, thank you for your presentations. Always clear and concise - very much appreciated. Always learn a huge amount
@LisaGoddard1173 жыл бұрын
Thanks Kevin. Another superbly informative video. I’ve always loved playing with pivot tables to analyse data but I didn’t know you could do half of this. Just sent the video to my work email to watch again tomorrow when I am at work. Have found loads of your videos useful over lockdown and this is another one I will add to my favourites.
@naveedwantt28462 жыл бұрын
Hey, can u please help me with this question... Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@LisaGoddard1172 жыл бұрын
@@naveedwantt2846 do your 20 columns include the Agent Name and Team? If not I’m include columns for those in your data and then you can filter in a pivot table by team or by Agent. And then add a pivot chart per team or per of per manager to a dashboard page
@markfox53493 жыл бұрын
glad I found you Kevin. I am learning so much from your videos. Thank you!! You are so smart!!
@leenu63163 жыл бұрын
Wow, thanks Kevin for sharing this tutorial.
@helenhu51203 жыл бұрын
Thank you so much, Kevin. I consider myself a pivot table expert, but I still manage to learn something new from you! Your videos have been a great learning resource for me.
@naveedwantt28462 жыл бұрын
Hey, can u please help me with this question... Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@robdc4829 Жыл бұрын
@@naveedwantt2846 I'll take a shot.... Have two tables. One table has 22 columns - Call#, Agent#, Call_Parameter 1-20. Second table has 3 columns. Agent#, TL_Name, Mgr_Name. Relate the two tables using PowerPivot. Connect them using Agent# fields. Then, do a pivot table on the combined tables in PowerPivot to show you whatever you wish!
@jotech5951 Жыл бұрын
@@robdc4829 we kinda think alike.
@richboy38602 жыл бұрын
13:34 - Kevin’s video is so amazing that even if I were a vindictively strict English teacher grading an exam for Kevin, I would happily give him a full score for replacing subtotal with subtitle 😊
@jacobnduya7982 жыл бұрын
thank you so much i like your teaching i get little knowledge of MS excel in collage now am learning it my self without any pressure and real i can repeat it as more as i nee. Thank you so much
@bonnienzyoka3 жыл бұрын
Great tutorial. Saved me a lot of time trying to figure out how to navigate Excel
@unknownuser107023 жыл бұрын
These are such great tips I never knew! Thank you, Kevin!
@jana_123jana2 ай бұрын
Thank you for the video! Very informative😊 👍
@bluebee293 жыл бұрын
Kevin, I like how you say "Todaaayyyy, I'm gonna show you how..." It's your signature intro by now 😁
@marshallhosel12473 жыл бұрын
I find your tutorials engaging and helpful refreshers as an experienced excel user. Thank you, keep up the great work!
@naveedwantt28462 жыл бұрын
Hey, can u please help me with this question... Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@catherinepeng46643 жыл бұрын
I start my new job next week and I'll be using a lot of Excel. Thankyou so much for this this is helpful!!
@robertk7484 Жыл бұрын
Nicely done! great detail and thorough coverage of these tips in an accessible manner.
@jazbinsek3 жыл бұрын
Nice and powerful tips Kevin! Thanks a lot!
@TheBtrivedi3 жыл бұрын
Thank you, new learnings for me are Slicer and Timeline
@irwankurniawan17373 жыл бұрын
Very useful tips. Thanks for putting them together!
@SalimKhoury-dj5on Жыл бұрын
HI Kevin, I have gone through the majority of your videos, they are great, I like the way you present and you cut the presentation, you do it great, you do it very professionally Bravo
@ca.lakshminarayanreddyjamb42173 жыл бұрын
Awesome Kevin. I learned a lot from this. Good work. Big Thanks.
@valenmolina3 жыл бұрын
Great video Kev, super interesting and useful. Thanks!
@zendya2 жыл бұрын
Thanks for this video. Wonderful tips.
@donnafletcher53863 жыл бұрын
Another good teaching lesson. Thanks, Kevin.
@ChristianNiebres3 жыл бұрын
Awesome!!! You deserve million subs Kevin. Thank you for your tutorials. Watching from 🇵🇭
@davidfamilydoctor9430 Жыл бұрын
Very helpful. Many thanks
@gracietwumasi5784 Жыл бұрын
Great tips Kevin 👌 can't thank you enough for making my excel life easier 😀
@rotethongvanit2 жыл бұрын
Thanks Kevin, some are new to me and they're very useful.
@odymamavlogs34092 жыл бұрын
So helpful. Thanks Kevin!!!
@vishalrawat5093 жыл бұрын
Really love your videos kevin plzz bring more content on power bi and excel regularly specially a detailed course on power bi about an hour hour or 2 hours course
@shyleshkr71563 жыл бұрын
hi Kevin you are amazing and you made my day thanks for the wonderful explanation and the shortcuts on Pivot tables
@ruimateus79225 ай бұрын
Thanks for the video. Very useful.
@MiraMira-gt1gd Жыл бұрын
What an awesome tutorial. Thank you.
@jordankelly11633 жыл бұрын
This was so helpful and fun thank you.
@sevincquliyeva55072 жыл бұрын
This video is very helpfull. Thank you so much.
@redwilson66043 жыл бұрын
Love how he says "Today" 😻 So cute ❤️
@Mylysoleil3 жыл бұрын
You are the best thank you so much i really needed to learn and. I followed your. Videos so far its been a great tool at work.
@k.k3260 Жыл бұрын
Thank you for sharing this video 🙏
@CaribouDataScience2 жыл бұрын
Thanks that was helpful.
@youugoo222 жыл бұрын
Great tips. Thanks 🙏
@bobgong78323 жыл бұрын
Great video, I learned a few new pivot table tricks. For future vids, can you please include the version of the MS app you are using? The Excel version I am using does not have the Analyze Data button on the Home tab of the ribbon. Thank you!
@jinggao68752 жыл бұрын
Thank you so much for sharing
@hugyourdata15492 жыл бұрын
Thanks Kevin! Great job.
@elizabethofori11653 жыл бұрын
Kevin, thanks a million.
@SivaKumar-rt8ct3 жыл бұрын
Fantastic ! Thank you !
@Saidousku Жыл бұрын
this tips are just WOW! You're the best
@vitruvian_man3 жыл бұрын
Awesome! Thanks Kevin.
@ashwinikumar230211 ай бұрын
Kevin... your videos are so helpful and just superb...
@marrlfox3 жыл бұрын
Great quality of video and content, as usual, Kevin!
@debrajoyner23198 ай бұрын
Thank you Kevin. Great information.
@patrickuzowara61402 жыл бұрын
Hello Kevin, thank you so very much for these Tips. Awesome!
@muhammadnurhakimmohdderis42013 жыл бұрын
U are one of my favorite mentor...
@junejaundoo38272 жыл бұрын
So helpful, thank you!
@niranjan90752 жыл бұрын
યતિ
@michaellee96092 жыл бұрын
love it! You are the best!
@haolanfu72063 жыл бұрын
That's so helpful! thank you!
@crmudaliyar3 жыл бұрын
I’m learning a lot of things from your channel Thanks buddy
@mohankumar-lc3pm Жыл бұрын
Wow amazing tips ..... Its really helpful in my day in and out work.... Thanks lot for your video.....
@techpalla Жыл бұрын
Kevin you did a good job at explaining pivot tables. I have never used it and will join your club. Thanks. 😅
@annacalgarian99953 жыл бұрын
Very helpful! Thanks very much!
@hassanalianees55302 жыл бұрын
V V Nice. Brilliant. Thanks Kevin
@neerajbhagat41233 жыл бұрын
Very useful tricks Kevin, another useful video. Thanks
@chrispaiva3 жыл бұрын
Another awsome content. Thanks Kevin.
@correaveleza1 Жыл бұрын
Thanks you, I am so happy I found you!!!
@ivad.1341 Жыл бұрын
So inspiring and informative, thank you 🙂
@muneer03133 жыл бұрын
Hi Kevin Thank you for The most helpful tricks and tisp