How to Create Pivot Table in Excel

Рет қаралды 1,113,317

Күн бұрын

🔥 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 KZfaq
kzfaq.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

Пікірлер: 469

@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: kzfaq.info/sun/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 10 ай бұрын

A very good explanation

@franksterkb891 9 ай бұрын

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

@KevinStratvert 9 ай бұрын

@@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 8 ай бұрын

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?

@boozinga Ай бұрын

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

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

@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 5 ай бұрын

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!

@lucianathomas8722 Жыл бұрын

I am SO glad I have found your videos and tutorials on KZfaq! 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!

@user-ev4ql9jj4u 9 ай бұрын

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:)

@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 9 ай бұрын

aa❤❤

@rhondacrowder7469 Жыл бұрын

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

@user-nx6ze6wt1d 3 ай бұрын

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

@maribel7571 11 ай бұрын

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

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

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

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

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

@Shankar-oe5rm Жыл бұрын

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

@tetsuyarj09 6 ай бұрын

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!

@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

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

@RonMarotte Жыл бұрын

A Masters Class indeed! Thanks for sharing your wisdom.

@yamiletheisele500 Жыл бұрын

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

@EdsonNascimentoEN Жыл бұрын

We always learn something from Kevin's great tutorials.

@mohammedsaleh3288 4 ай бұрын

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

@samuelscholarsticaadaku9391 Ай бұрын

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

@maxtrenck8511 Жыл бұрын

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

@matthewlozy1140 11 ай бұрын

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.

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

@SueTMB 4 ай бұрын

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!

@chochothetlwin3545 8 ай бұрын

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.☺

@marceljunioregondi5594 Жыл бұрын

Thanks Kevin for the tutorial. Please do one on power pivot.

@KevinStratvert Жыл бұрын

Here is power pivot: How to use Power Pivot in Excel | Full Tutorial kzfaq.info/get/bejne/qKiPfMyKx7XTZ6s.html

@lauraprater2300 10 ай бұрын

BEST video on pivot tables! Beautifully presented.

@yisyvonne 8 ай бұрын

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

@samuelscholarsticaadaku9391 Ай бұрын

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

@Chrissfabbi 8 ай бұрын

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

@oseous Жыл бұрын

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

@GauriShelke-kk8nc 9 күн бұрын

Pivot tables was really confusing for me when we wanted to have a look at different data, but after watching your video I have clearly understood how to analyse the data and get the desired data. The option of calculated field was something new which is really useful. You have made me understand every concept in a very simple way which I enjoyed and you mainatined the curiosity to learn even more. thankyou for your excellent way of teaching.Kudos to your efforts!!!

@janei9674 7 ай бұрын

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

@skonzii Жыл бұрын

Absolute 🤯 at 13:07. Instantly saw the way the drop fields mimic the table. What a huge “a Ha” moment! 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.

@shravanrao5008 8 ай бұрын

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

@vetman98 3 ай бұрын

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

@sgit1 Жыл бұрын

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

@eng.alaafathy Жыл бұрын

Excellent tutorial for pivot table 👌

@ralphpayne6259 11 ай бұрын

Stunningly well-prepared tuition video and succinct. Brilliant!

@Schnappy21 Жыл бұрын

Amazing tutorial Kevin, thanks a lot for the help.

@kashtonari Жыл бұрын

Wow! Excellent summary of pivot tables! Thank you!

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

@charlesmusyoka5890 7 ай бұрын

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

@alok5402 5 ай бұрын

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

@Reed488 4 ай бұрын

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

@badgood8477 Жыл бұрын

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

@pierresoudry3678 2 ай бұрын

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

@cristygenovea2818 9 ай бұрын

Hi, Kevin! This was really very helpful and easy to follow. I was able to follow all the steps in your video using the Excel workbook except for Insert Timeline and Analyse Data. It kept on saying that there was no field formatted as Date even if there was a column on Date. I also do not have the pivot Analyze Data on my toolbar. Maybe because I was just using Excel on my laptop and not the one on the one drive. Thank you!

@darkbeauty0eliza 6 ай бұрын

I had the same problem, it did not let me add the Timeline…

@andrewdrache1055 3 ай бұрын

@@darkbeauty0elizathe dates are formatted wrongly. It worked after I corrected the column

@maryamkazemi5812 11 ай бұрын

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

@haojingh6517 3 ай бұрын

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

@richardbowden8115 4 ай бұрын

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

@_1mm Жыл бұрын

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

@ianpatrick23 4 ай бұрын

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

@dazhou9293 Жыл бұрын

Amazing tutorial! Thank you Kevin!

@user-dq7tl3ql4z Жыл бұрын

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

@kvelez 9 ай бұрын

Thank you Kevin, you are the best.

@videostok2452 Жыл бұрын

Good morning from Paris. Greetings and thanks for your videos

@ecomarketofficial 6 ай бұрын

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

@ianpatrick23 7 ай бұрын

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

@chrismutisya Жыл бұрын

This is worth the time. Thank you, Kevin!

@wallyaumau96 2 ай бұрын

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

@DavidFriedberg123 8 ай бұрын

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

@leorio4657 4 ай бұрын

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

@iamminut 9 ай бұрын

You are such a big help kevin!!!! ❤

@ninawalker9943 6 ай бұрын

Thank you. I will be able to complete my homework assignment. Your instructions were very clear and precise.

@matthewkagan6921 Ай бұрын

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

@abhishek95985 3 ай бұрын

Thank you for teaching me Pivot. Appreciate it!

@vincentparisutham9578 9 ай бұрын

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

@texasroyalty1566 9 ай бұрын

Thanks 🙏 I really appreciate the video. My job is mostly Excel and I am still trying to learn all the functions

@GCSEPhysicsExplained Жыл бұрын

Very useful information delivered by a great teacher! Thanks

@mainmanme 5 ай бұрын

Great job. I definitely understand pivot tables better. I did slow down the video speed to follow you in the workbook. By the way that was a huge help.

@muhammadbinuzair2101 2 ай бұрын

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

@ahmadimran6231 2 ай бұрын

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

@user-mv6eb1wm6n 11 ай бұрын

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

@sunlightpictures8367 Жыл бұрын

This is amazing. You're a great teacher.

@ajeeli_travels 8 ай бұрын

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

@arlindervishaj Жыл бұрын

Amazing tutorial! Thank you so much!

@peterjames2745 Жыл бұрын

You are the best! Thanks

@vk9h Жыл бұрын

Best online teacher , thank you

8 ай бұрын

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

@CyroRovathdeFaria 6 ай бұрын

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

@Karen-2023 Жыл бұрын

Thank you for the great presentation and data sources!

@mariar.suarezrozo9015 4 ай бұрын

Beautifly done Kevin! Thanks so much

@samsungGalaxyJ3Pro Жыл бұрын

Thanks, Kevin!

@paulkenyon1830 Ай бұрын

Absolutely excellent video - extremely helpful. Thank you

@Kikamalak 6 ай бұрын

Best instructor ever. Thank you so much.

@PANDUANOFFICE25 Жыл бұрын

Nice tutorial.... thanks kevin

@jamesg4825 10 ай бұрын

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

@siyadshire505 3 ай бұрын

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

@Forlorn81 Жыл бұрын

Thank you Kevin: great stuff indeed and you are a great teacher! What version of Excel are you using in the video?

@giftifeoma917 6 ай бұрын

This was quite helpful. Thanks Kevin!

@geovannyolivero6241 3 ай бұрын

Kevin let me tell you that you are the best, I appreciate all your help