🧙‍♂️ Pivot Table Excel Tips & Tricks

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn the top 14 best pivot table tips and tricks in Microsoft Excel. For example, use natural language to create pivot tables, get automatic insights on your data using ML, use multiple tables as sources, add calculated fields, quickly filter data with slicers & timelines, build dashboards, and many more. These are sure to take your analysis skills with pivottables to the next level. And most importantly, you'll be able to answer business questions even faster.
👋 Additional resources
- Sample data to follow along: 1drv.ms/x/s!AmxrofZZlZ-whLkz3...
- How to use Pivot Tables Tutorial for Beginners: • Pivot Table Excel Tuto...
- How to use Power Pivot in Excel: • How to use Power Pivot...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:34 Natural language pivot table
2:37 Click values for details
3:18 Pivot table with multiple sheets
5:39 Field layout & sorting options
6:28 Calculated fields
7:30 Sort values
7:57 Show value as
9:14 Summarize values
10:16 Slicer
11:37 Timeline
12:25 Pivot charts
13:08 Pivot table layouts
14:46 Grouping
15:16 Customize row labels
16:44 Wrap up
📃 Watch related playlists and videos
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Discord: / discord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my KZbin channel
kzbin.info?...
🎬 Want to watch again? Navigate back to my KZbin channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: 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.
#stratvert

[@KevinStratvert]

🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@makainoe5385]

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?

[@TylerStanczak]

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

[@mdtaylor2274]

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!

[@naveedwantt2846]

‌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

[@sandrahanson9113]

Setting up default pivot table layouts. Kevin you are my hero!

[@AaronWesson]

I have been using Pivot tables for years, and through this video, I have learned a few more things. Thank you!

[@andy_kng]

Wow, amazing video. I've used Pivot tables for years and I'm blown away. Thank you

[@nigelfreeman6192]

This video couldn’t have come at a better time. Thanks great instructional video 👍

[@sonyamorton7573]

Awesome tips for Pivot Tables. Adding a calculated column is going to change my game! THANKS😊

[@SavageGothamChess]

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.

[@DarkDudesAI]

Congrats on 200 subs Hovindu! All the best to you to reach 1000 soon!

[@niiikhiiil]

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.

[@jitkaobrien2813]

Hi Kevin, I am so glad I discovered your videos. I started watching yesterday and back today, already learnt so much. Thank you.

[@ZoarkadoZenos]

I didn't know the existence of slicer till now. OMG, you are a lifesaver and a timesaver!

[@toryrusso520]

Kevin, Thanks again. I find these Excel Pivots & PowerBi videos so useful. I learn something new. Keep these coming!!

[@crescenzocommunications4290]

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!

[@naveedwantt2846]

‌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

[@yquintana5673]

Thank you for this! I often forget how to build a pivot table and now I can save this video for next time.

[@MissZia]

Thank you Kevin. I am learning all tricks and tips from your videos. You are calm, making it so easy to understand the steps.

[@annemariemare9458]

Kevin this was amazing! Been using Pivots forever and learned a few new nifty things! Thanks!

[@romelevangelista1697]

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

[@naveedwantt2846]

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!

[@silversolver7809]

That is a great video Kevin! I've been using pivots for over a decade and learned a lot, thank you :)

[@marcellef8302]

Wow, this is fantastic! Thank you, Kevin 😁👍

[@gajabathiarjuntg2390]

Great video Kevin. This is detailed view on Pivot Tables. Thanks Kevin 😀

[@markfox5349]

glad I found you Kevin. I am learning so much from your videos. Thank you!! You are so smart!!

[@adinacameliacernea995]

Thank you Kevin! This has been so helpful. Your videos are great to watch, understand and very informative.

[@franksaieva4952014]

Hi Kevin, thank you for your presentations. Always clear and concise - very much appreciated. Always learn a huge amount

[@leenu6316]

Wow, thanks Kevin for sharing this tutorial.

[@DarkDudesAI]

I have learnt this in my school! This is just an awesome Brush Up Session!

[@cycleSCUBA]

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 👍

[@iKnowledgeSchool]

Analyze data is one of the best tips, totally agree

[@LisaGoddard117]

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.

[@naveedwantt2846]

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!

[@LisaGoddard117]

@@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

[@tmyanh1993]

Great. Your tips help me a lot when working with a lot of tables. Now I learned a lot.

[@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.

[@richboy3860]

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 😊

[@ChristianNiebres]

Awesome!!! You deserve million subs Kevin. Thank you for your tutorials. Watching from 🇵🇭

[@robertk7484]

Nicely done! great detail and thorough coverage of these tips in an accessible manner.

[@helenhu5120]

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.

[@naveedwantt2846]

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.

[@catherinepeng4664]

I start my new job next week and I'll be using a lot of Excel. Thankyou so much for this this is helpful!!

[@gracietwumasi5784]

Great tips Kevin 👌 can't thank you enough for making my excel life easier 😀

[@chrisguerrero5571]

Kevin just got a promotion from me!!! He’s my executive educator!! THANK YOU!!!

[@bonnienzyoka]

Great tutorial. Saved me a lot of time trying to figure out how to navigate Excel

[@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

[@marshallhosel1247]

I find your tutorials engaging and helpful refreshers as an experienced excel user. Thank you, keep up the great work!

[@naveedwantt2846]

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!

[@donnafletcher5386]

Another good teaching lesson. Thanks, Kevin.

[@ca.lakshminarayanreddyjamb4217]

Awesome Kevin. I learned a lot from this. Good work. Big Thanks.

[@rotethongvanit]

Thanks Kevin, some are new to me and they're very useful.

[@unknownuser10702]

These are such great tips I never knew! Thank you, Kevin!

[@bluebee29]

Kevin, I like how you say "Todaaayyyy, I'm gonna show you how..." It's your signature intro by now 😁

[@jazbinsek]

Nice and powerful tips Kevin! Thanks a lot!

[@TheBtrivedi]

Thank you, new learnings for me are Slicer and Timeline

[@elizabethofori1165]

Kevin, thanks a million.

[@irwankurniawan1737]

Very useful tips. Thanks for putting them together!

[@odymamavlogs3409]

So helpful. Thanks Kevin!!!

[@shyleshkr7156]

hi Kevin you are amazing and you made my day thanks for the wonderful explanation and the shortcuts on Pivot tables

[@marrlfox]

Great quality of video and content, as usual, Kevin!

[@correaveleza1]

Thanks you, I am so happy I found you!!!

[@jana_123jana]

Thank you for the video! Very informative😊 👍

[@guillermohernandezquintana3649]

Kevin, thanks so much for your helpful "Excel-pills" lesson. Short, but effective for using key functions more effectively.

[@zendya]

Thanks for this video. Wonderful tips.

[@redwilson6604]

Love how he says "Today" 😻 So cute ❤️

[@patrickuzowara6140]

Hello Kevin, thank you so very much for these Tips. Awesome!

[@muhammadnurhakimmohdderis4201]

U are one of my favorite mentor...

[@valenmolina]

Great video Kev, super interesting and useful. Thanks!

[@MiraMira-gt1gd]

What an awesome tutorial. Thank you.

[@hugyourdata1549]

Thanks Kevin! Great job.

[@vishalrawat509]

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

[@debrajoyner2319]

Thank you Kevin. Great information.

[@jacobnduya798]

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

[@k.k3260]

Thank you for sharing this video 🙏

[@Mylysoleil]

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.

[@techpalla]

Kevin you did a good job at explaining pivot tables. I have never used it and will join your club. Thanks. 😅

[@ashwinikumar2302]

Kevin... your videos are so helpful and just superb...

[@Saidousku]

this tips are just WOW! You're the best

[@neerajbhagat4123]

Very useful tricks Kevin, another useful video. Thanks

[@crmudaliyar]

I’m learning a lot of things from your channel Thanks buddy

[@andihall7104]

WOW. Just wow!!

[@ruimateus7922]

Thanks for the video. Very useful.

[@davidfamilydoctor9430]

Very helpful. Many thanks

[@sevincquliyeva5507]

This video is very helpfull. Thank you so much.

[@vitruvian_man]

Awesome! Thanks Kevin.

[@hassanalianees5530]

V V Nice. Brilliant. Thanks Kevin

[@chrispaiva]

Another awsome content. Thanks Kevin.

[@mohankumar-lc3pm]

Wow amazing tips ..... Its really helpful in my day in and out work.... Thanks lot for your video.....

[@jinggao6875]

Thank you so much for sharing

[@egyptjones]

Kevin saves the day....per usual!!!

[@SivaKumar-rt8ct]

Fantastic ! Thank you !

[@jordankelly1163]

This was so helpful and fun thank you.

[@annacalgarian9995]

Very helpful! Thanks very much!

[@youugoo22]

Great tips. Thanks 🙏

[@ONE-kf3bm]

Very informative and helpful for working professionals

[@jonk3361]

learned quite alot from this video...many thanks..a channel worth subscribing and am doing that right after this comment.

[@rameezahamad3377]

Nice video. Learnt few more new things. Thank you

[@whiskyguzzler982]

Love me some pivot tables!

[@k.c1126]

Hey ... I just saw this !!!! Thanks, Kevin!!!!

[@jacquelinevillanueva5651]

Very helpful, thank you Kevin😊

[@ivad.1341]

So inspiring and informative, thank you 🙂

[@michaellee9609]

love it! You are the best!

[@haolanfu7206]

That's so helpful! thank you!

[@muneer0313]

Hi Kevin Thank you for The most helpful tricks and tisp

[@nikkyn4543]

I love these helpful tips

[@junejaundoo3827]

So helpful, thank you!

[@niranjan9075]

યતિ

[@lejouet007]

Thank you!