How to Create Pivot Table in Excel

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial for beginners, learn how to create a pivot table in Microsoft Excel. With an Excel Pivot Table, you can very quickly and easily analyze data without needing to use any formulas or functions. You can generate insights just by dragging and dropping fields. We start with how to prep your data and then walk through all the core functionality of pivot tables, including sorting, filtering, inserting charts, slicers, timelines, and more. By the end of this tutorial, you'll be confident using pivot tables in Excel.
📚 RESOURCES
- Exercise workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whO06Y...
- Excel for Beginners course: kevinstratvert.thinkific.com/
⌚ TIMESTAMPS
00:00 Introduction
00:41 Overview of data
01:56 Prep data
02:48 Turn data into table
03:43 Insert pivot table
04:16 Pivot table interface
04:59 Build basic pivot table with rows and values
06:27 Change formatting
06:40 Summarize values by
07:59 Remove fields
08:43 Sorting
09:47 Filtering
11:03 Show values as
11:54 Custom field headers
12:19 Multiple rows
12:50 Columns
13:30 Design
14:13 Pivot charts
14:44 Insert slicer
15:25 Insert timeline
15:56 Copy pivot table
16:13 Calculated fields
17:25 Refresh for new data
18:20 Source data
18:33 Recommended and Analyze Data
20:02 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZbin
kzbin.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #excel

[@KevinStratvert]

✅ Example Excel workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whO06YVUWhUW1CWJ93A?e=eOmbbu 🏫 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com ⏭ Playlist with my free Excel tutorial videos: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@Emmahoperoberts]

Hi Kevin, Would you be able to make a video about Microsoft Forms and Power Automate? Specifically the approvals process. and is there a way to pull all the data over to excel?

[@musaopeyemiibnlawal6906]

A very good explanation

[@franksterkb891]

hi. can you upload a new of the workbook. It seems the file is no longer available

[@KevinStratvert]

@@franksterkb891I just tested and confirmed that the link still works. onedrive.live.com/edit.aspx?resid=B09F9559F6A16B6C!79546&ithint=file%2cxlsx&wdo=2&authkey=!AGFVFoVFtQlifdw

[@sanguineaurakzai1867]

that was great video, but i have a question, my excel doesn't show many option in tool bar . e.g. it doesn't have that analyze option in home tab, why?

[@latoyamurphy2636]

Content creation is a job in itself so I'm taking the time to leave this comment. I've been stumbling around with Pivot Tables for a while now, but never really understood how they worked. This video was engaging and concise enough to really help me out. Kevin, thank you so much for this! Your tone and pacing made this video an easy watch and I honestly hope to use more of these videos in future when I want to learn more about Excel. Thank you so much for your efforts and passion for teaching Excel!

[@coldrulez8187]

@@Quaqu_Perry what?

[@InfoWorldTours]

Such a powerful and concise delivery in few minutes. Great job Kevin

[@TerryStoa]

You have a great teaching style, Kevin. I consider myself an Excel guru, but Pivot Tables are new to me and they’re oh so powerful!

[@trekmtl]

Thanks for this concise and well-structured tutorial! I didn't realize how much Excel functionality I was missing out on!

[@lucianathomas8722]

I am SO glad I have found your videos and tutorials on KZbin! The best I’ve ever found - simple and easy to understand. I feel like I can finally improve my Excel skills! Thank you so much!

[@Venaloid]

This was brilliant and simple, thank you so much. Pivot tables are basically just different ways to sort and visualize your data, much like a Microsoft Access "query". Very nicely explained.

[@marvelmusic4566]

Never having used Pivotal Tables, I'm saving your video because I've learned you can create a table with any particular detail being focused on and further breaking down those sums. Excellent video and provides instructions regarding details and how to highlight or filter data. Premium quality tutorial. Thank you!

[@user-ev4ql9jj4u]

Thank you KEVIN I have struggled a lot (6 months)before especially during the interview when they asked about the pivot table, I watched so many videos but couldn't find one worthy as I could not understand the concept but after watching your video I finally learn what is pivot table, when and how to use. Your teaching style is clear and concise I obviously refer others to watch more Excel videos of you including me:)

[@user-nx6ze6wt1d]

Awesome job! Easily broken down, yet still advanced enough to give real insight into data! BRAVO!

[@boozinga]

Crystal Clear and No Distractions! Presentation on point! Best Tutor!!

[@rhondacrowder7469]

Excellent tutorial! I am no longer intimated by Pivot Tables! Thank you for sharing your knowledge with us!

[@ben-uy1ud]

Kevin , you are a great teacher. Kudos to you for sharing knowledge and contributing to the community. Pls continue the good work and we are eager to learn more and more from you!! Wishing the very best!!

[@maribel7571]

Very helpful! I'm planning to apply as a VA and most of the companies require an advanced skill in Excel.. This is gold❤️

[@fangzhang3119]

You are an amazing excel teacher! I feel excel functions are so easy after watching your videos. You help me find a job! Thank you so much for your help!

[@Shankar-oe5rm]

Loved the Tutorial. Concise and made such an intimidating feature simple. Thanks Kevin!!

[@justinabosco2763]

This video was amazing. I do pivot table everyday at work but today I learnt that I can actually do so many things with it.

[@user-br3tn9cs3r]

Greetings from Australia. A fabulously thorough "nuts and bolts" portrayal of the capacity of Pivot Tables to analyse data. Crystal clear explanations of the "how tos" of Pivot tabling.

[@tetsuyarj09]

Hi Kevin, I just started watching your video and this is the first one I've watched. I just want to say that you have explained it in a very simple yet detailed manner and I could easily understand and catch on. Sending you a message to say I am grateful that you have thought of this. Thank you so much and I will continue to support your channel. Be well and be more blessed! From Malaysia learning from you!

[@lauraprater2300]

BEST video on pivot tables! Beautifully presented.

[@yamiletheisele500]

Kevin, you are like the best teacher ever!!!!!! Thank you!

[@RonMarotte]

A Masters Class indeed! Thanks for sharing your wisdom.

[@EdsonNascimentoEN]

We always learn something from Kevin's great tutorials.

[@ralphpayne6259]

Stunningly well-prepared tuition video and succinct. Brilliant!

[@arch.blender1178]

Thank you, Kevin, I was a little scared to try pivot tables but now I have watched your video I feel emboldened

[@KevinStratvert]

You can do it! 😁👍

[@learningdistilled]

Pivot tables are definitely intimidating at first but so helpful once you get the hang of it!

[@raymondpang9413]

​aa❤❤

[@maxtrenck8511]

Amazing tool and great video, clear explanation as always! 👍🏼

[@sgit1]

Amazing! A 20 minute presentation on a subject that I used but never really understood until now.

[@bonsaijansenvanvuuren]

EXCELLENT KEVIN, thank you. I moved out of the corporate world during the Covid Pandemic, and resolved to never work again. But things changed and I am now employed again. But.... during the 4 years I forgot a lot, but thanks to your video I could quickly brush up again. I thank and salute you, Kevin

[@samuelscholarsticaadaku9391]

@KevinStratvert You're really making my Data Analytics journey simple and enjoyable. Thank you for your simplicity in all your videos

[@kashtonari]

Wow! Excellent summary of pivot tables! Thank you!

[@DeeAustin_PassiveIncomeLife]

Kevin, you are a great teacher and your voice is very user-friendly. I learned so much about pIvot tables! This is going to be awesome for my business. Thank you.

[@PannyRedenius]

creation is a job in itself so I'm taking the time to leave this comment. I've been stumbling around with Pivot Tables for a while now, but never really understood how they worked. This video was engaging and concise enough to really help me out. Kevin, thank you so much for this

[@user-hc7mj1hw3q]

This is Fran Kleiner. Your create pivot tables in Excel was very helpful. I created a couple of pivot tables for work which I have to update. It looks like the version of Excel I was using changed and the way I was doing pivot tables before looked different. By watching your video, I realized how it now works, and I also learned about other functions, like the slicer feature, which I didn't know how to use.

[@vincentparisutham9578]

Fabolous work Kevin. The pace of the presentation and the quality of the examples are so good and easy to learn

[@Chrissfabbi]

Love the way you explain, so calm and well detailed. Thank you 🙏

[@maryamkazemi5812]

It's a well-structured and concise tutorial, thanks for sharing!

[@samuelscholarsticaadaku9391]

@KevinStratvert You're really making my Data Analytics journey simple and enjoyable. Thank you for your simplicity in all your video

[@oseous]

Great review getting ready for my interview in 2 days. Thank you for this clear and concise tutorial video!

[@pierresoudry3678]

EXCELLENT Tutorial. TRULY!! Was so easy to follow along.

[@pesc75]

Thank you! I wish I had knowned all this last week!! I’ll be prepared next time! Thanks again, I really enjoy watching your videos and learning.

[@eng.alaafathy]

Excellent tutorial for pivot table 👌

[@videostok2452]

Good morning from Paris. Greetings and thanks for your videos

[@user-dq7tl3ql4z]

Well put together and easy to follow along.. Thank you for this!

[@Schnappy21]

Amazing tutorial Kevin, thanks a lot for the help.

[@dazhou9293]

Amazing tutorial! Thank you Kevin!

[@justinmoorhead2632]

Thanks that's great. I've been using excel all day 5 days a week for 17 years with VBA and never got around to mastering Pivot tables until now.

[@matthewlozy1140]

Nice video, thank you! I'm proficient in Excel, but I never had a reason to really dive into Pivot Tables. Finally do and wow they're so easy to make.

[@chochothetlwin3545]

Thank you Kevin. I have to use Pivot table at work and now I understand how to apply it. This video is really helpful to me.☺

[@yisyvonne]

Kevin you are amazing! I'm a finance undergrad and this has been the best excel tutorial I've found!

[@charlesmusyoka5890]

Man. You're great on explaining Excel functions. Thank you!

[@SueTMB]

Thank you so much for this tutorial. I knew a bit about pivot tables but had mainly copied ones that others had created and played around with this. I needed to create one from scratch and this video was such an eye opener. I never knew you could get so much from a pivot table!

[@skonzii]

Absolute 🤯 at 13:07. Instantly saw the way the drop fields mimic the table. What a huge “a Ha” moment! Thank you!

[@ahmadimran6231]

Super helpful, to the point and nicely delivered. Thank you.

[@chrismutisya]

This is worth the time. Thank you, Kevin!

[@vetman98]

Kevin you have open up Excel for me. thank you. Keep the video's coming

[@Karen-2023]

Thank you for the great presentation and data sources!

[@janei9674]

I feel much better and understand pivot tables on a new level. Excellent teaching skills!!

[@ragsoh]

Kevin you are one of my favourite KZbinrs for tech stuff. Thank you very much for your videos. Stay blessed and Happy New Year. Greetings from the other side of the world - sunny Singapore.

[@haojingh6517]

excellent video, not just the content, the sound and the speed. thank you!

[@user-mv6eb1wm6n]

Thank you so much Kevin. I've learned so much from this.

[@paulkenyon1830]

Absolutely excellent video - extremely helpful. Thank you

[@richardbowden8115]

Kevin - a topic I needed to understand and you laid it out perfectly -thank you !!

[@mohammedsaleh3288]

I loved how you start your explanation by using the traditional formula and then pivot table

[@ianpatrick23]

This is such a fantastic explanation of pivot tables in Excel. Thank you!

[@wallyaumau96]

Wow. Awesome explanation. Thanks for simplifying how to construct pivot tables. Now time for me to practice

[@badgood8477]

Thanks for this tutorial ... It was very helpful 😍😍

[@alok5402]

You are truly wonderful. I never had such a great lesson in pivot tables. You explained so lucidly. Thank you 🎉

[@siyadshire505]

This is a very profound and compelling video with a lot of insights. Thanks for uploading such great content!

[@shravanrao5008]

This is awesome! I was a complete beginner now with a lot more confidence! Thank you

[@kvelez]

Thank you Kevin, you are the best.

[@jamesg4825]

Dude, you are so good at explaining things!!!

[@arlindervishaj]

Amazing tutorial! Thank you so much!

[@ajeeli_travels]

That's a very professional delivery right there, excellent.

[@sunlightpictures8367]

This is amazing. You're a great teacher.

[@ghousrasoolacca1440]

Excellent way of teaching in short time ... Thanks

[@vk9h]

Best online teacher , thank you

[@ruthaj6027]

Thank you for this, very detailed and helpful.

[@ianpatrick23]

This is such a great explanation of how to use pivot tables. Thank you!!

[@_1mm]

pivot table is not a new stuff, but i know you never disappointing me Kevin!!! thanks for the great sharing!!!

[@abhishek95985]

Thank you for teaching me Pivot. Appreciate it!

[@joshiyogesh144]

Thank you Kevin, it really helps me

[@leorio4657]

Truly powerful! I had no idea. Thank you SO MUCH!

[@giftifeoma917]

This was quite helpful. Thanks Kevin!

[@ecomarketofficial]

Best Excel video of all times, you KNOW HOW TO EXPLAIN THINGS VERY WELL, cup winner in my book, thank you!!

[@CyroRovathdeFaria]

What a great tutorial! Many thanks for that, mate!

Very easy to follow. Thank you so much. I learned a ton in this video.

[@felixjj2035]

very good video. I don't often comment, but this video explained this in a fantastic way!

[@GCSEPhysicsExplained]

Very useful information delivered by a great teacher! Thanks

[@samsungGalaxyJ3Pro]

Thanks, Kevin!

[@muhammadbinuzair2101]

You are very professional in what you are doing Thank you so much!

[@Reed488]

Thank you so much for this thorough tutorial!! In one afternoon, I've gone from being clueless/intimidated by PivotTables to feeling empowered by and confident to use them!!

[@matthewkagan6921]

Thank you so much! You really helped me to understand pivot tables.

[@peterjames2745]

You are the best! Thanks

[@mariar.suarezrozo9015]

Beautifly done Kevin! Thanks so much

[@dalemccullough5693]

Very excellent help on pivot tables. Thank you.

[@ellengusmao4320]

Best explanation I´ve found by far!

[@thinhle5765]

Really thanks for your detail yet concise tutorial

[@dastaan.]

Thanks for update 😀

[@epetsalis]

Thanks for the excellent tutorial.

[@mengyanggai3891]

Thank you so much this is very clear and informative! ❤️❤️❤️👍👍👍👍