Learn Pivot Tables in 6 Minutes (Microsoft Excel)

Here is the sample file: www.codybaldwin.com/sample-fi.... Interested in learning more. You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course.
Learn pivot tables in 6 minutes... Pivot tables allow you to automatically summarizes your data... so you can “slice-and-dice” in a million ways. This means you can replace lots of hand-typed summary calculations with more automated reporting. To create a pivot table, select a cell in your table and click “PivotTable” on the “Insert” tab.

[@codymbaldwin]

What's up, Excel ninjas? I hope this video is helpful. I love me some pivot tables! If you're interested in learning more, you can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course

[@koredeadedeji9254]

Hello, I have an upcoming interview and the role is majorly working with pivot table.if I enroll is this something I can learn in a short while?

[@Billbro_Swagginz]

This was very helpful. Thank you.

[@maurosalvador1038]

cargar un video de la función if por favor

[@maurosalvador1038]

upload a video of the if function please

[@musicismagic5074]

I appreciate your presentation, but the close ups and moving across the screen was making me dizzy!

[@doriabs]

Writing : Excel (proficient) on my resume when I don't know how to use Excel and then actually getting the interview is the reason why I'm here

[@nub2max]

Yes, and then we remember to mention in the interview that we have experience in Pivots cuz we watched this vid.

[@excellentviolet590]

Same dude😂😂😂😂🙏

[@oo4667]

but how did the interview go?

[@eoinoliver4826]

Brilliant!

[@alpacino9226]

same

[@KingMechanics]

Watched this video before going on an interview. I’m trying to expand my skillset

[@ytaaalx3195]

this is so me rn. i have an ojt interview tomorrow and i need to learn how to do this.

[@rimigeriausia]

Sameeeeeee

[@LukeCage1015]

I have an interview in 6 hours so that is also why I’m here lol

[@jenniferlogan-porter9788]

@@cordneyellis442 Good luck!

[@khairulazmi7432]

I got in my interview and the job but I still need to know this because I never use it before

[@user-hp5xs3bo8p]

Cody, You are BY FAR the best instructor for EXCEL on KZbin. You don't bore us with small talk. You get right to the point of how to do the task. Thank you.

[@nathano1599]

Thanks for the timeless tutorial. 6 years later. Still immensely useful

[@youtubepunisher8695]

Boss: Are you comfortable with Excel? Me: Yes Boss: How about pivot tables Me: uhm Yes Also Me: *KZbin Videos*

[@nickmeijer88]

Hopefully the boss won't give you an excel worksheet to work your magic ;)

[@drenee1416]

@@nickmeijer88 that's why you watch the video first lol

[@calabrisella122]

rocky mountain lass That is the honest truth!

[@amandaziegler8288]

Oh my god this 😂 I legit do know a lot of excel but this is one corner I’d never touched. What the hell did people do without the internet?!

[@tiffanypersaud3518]

KZbin Punisher, dude same.

[@jodihume5857]

HOLY COW this is helpful. I've always imagined pivot tables to be wildly complicated but you made it SO EASY.

[@yorandaingram1991]

Learning everything Excel while in quarantine.

[@nojokej]

4-year-old video. Still delivering great value. Thank you for taking the time to make and share.

[@rbergevine]

Your demeanor and presention was incredibly user friendly - gentle, clear, and deliberately well-paced to allow the viewers to process. Superior presentation skills, well done and thanks.

[@FredDrake76]

Your voice is so calming. You're like the Bob Ross of Excel videos.

[@mertbeloglu]

I don''t know how to thank you for this video. I have seen hundreds of pivot table tutorial videos on KZbin, none of which made any sense. But now I finally understand after having watched your tutorial. Thanks a thousand, Cody Baldwin :)

[@5reck0]

I forgot we had to do Pivot tables on the test, and I got reminded that we do have to do it 6 minutes before it. This was truly a God send

[@WhosDercy]

Clear, simple, and straight to point, Thank you.

[@chrismitchell2333]

This is the best explanation I've heard of pivot tables - clear and really helpful. Thank you!

[@Nutellabrot9]

Short, precise, boiled down ! Perfect - thanks Cody!

[@sshaoor7772]

Found the only one on youtube who is clear and audible to listen to and zoomed the screen so we can see clearly. Everything well explained. Thanks alot ❤️❤️❤️❤️ @Cody Baldwin

[@MsRyder120]

I am so glad there are people like you who enjoy Excel & are also really good at teaching people. You're a lifesaver.

[@naveedwantt2846]

Bhai... Can u please help me out with a 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 sepetately. Please bro, it's really important.

[@shalysagavin6354]

Thank you! I just learned how to do basics in excel last semester and because of an assignment and this video I've learned how to do a handful of new things that I will use in my future classes and career.

[@jazlr721]

Awesome! Six minutes and my perspective of doing pivot table changed. Thank you for this!

[@depth386]

Very decent... my first reaction is like "wtf no, i want control" and then I realize just how flexible it is without having to do all kinds of field equation editing. Nice video

[@LoganWeilerIII]

Wow! You are a gifted teacher. You made the most intimidating feature of Excel seem simple. Thank you for unraveling the mystery of pivot tables.

[@naveedwantt2846]

Can u please help me out with a 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 sepetately. Please bro, it's really very important.

[@Retotion]

@@naveedwantt2846 down bad

[@giantcat4354]

This was clear, concise and you didn't waste time by talking about how you worked at Microsoft or about your channel for 6 minutes. Thanks.

[@oladipupomesole8542]

@Giant Cat, that’s why he got plenty of views, short video that hits the main point.

[@soljer99]

Great video, makes easy to understand and learn the basic concepts of Pivot Tables. Thank you for posting it, Cody!

[@LenMarten]

Good video, thank you. The "zoomy" thing was pretty frustrating and I don't think was needed at all. Next time, just zoom the spreadsheet a little. I like to see the effect of the changes you're making and there were a couple of times you clicked on items and we didn't actually get to see the resultant change in the pivot table.

[@holbycat8833]

AGREED!

[@Stabbytabbycat]

It was disorienting. I appreciate the knowledge shared but would have preferred the wide shot so the changes could be seen in real time.

[@Britt1Nicole]

came here to say this

[@TheCactusCooler]

Logged into youtube just to say this same thing.

[@abaddon319]

wow that you for the easy to understand demonstration. I did not even know how useful the pivot table was until now.

[@sosenaofor]

Very good video.Short and straight to the point. No waste of time, high-quality information. Thanks dude

[@prettyyella32]

Thank you so very much for this video. Can't thank you enough.

[@DigitalBeaver]

Well you just showed me in 6 minutes what I've been avoiding for 16 years. WOW. So easy, thank you.

[@lolliemoua]

This video will change the course of my life. Thank you so much.

[@baongchannelEn]

thank you man, slow enough for beginners to digest!

[@Morgan-cu2hb]

I'm working on a project for work and I'm very interested in excel and all of the cool things it can do. Thank you so much! I was sitting at my desk like "oh my god!" and gasping, "that's so cool!" Thanks for making my day!

[@N3v3rDuplicated]

I’m amazed at how easy you just made this look! I’m sure it can get much more difficult but this 6 minute video literally just changed how I track my sales in my business!

[@thatninja8]

hope this helped you run the business smoother, best of luck

[@BollywoodBonanzaB]

This is awesome, thank you. I once had a colleague who kept sorting out the pivot tables I needed for my job for me, and when I asked him how I could do it myself, he smiled at me and said, "If I told you I would be out a job." Since then, Pivot Tables have felt like a distant secret to my mind. Thank you for beginning to break down that barrier. :)

[@gullysteph]

BollywoodBonanzaB That was just selfish of your colleague😕

[@swizzleproxi4810]

I was worrying about pivot tables but not now, after seeing your video I took a sigh of relief 👍😃ahhh

[@TheBladeofMiquella]

This is honestly one of best explanations for Pivot Tables I've seen, very nice job

[@paigey72]

This took something had overwhelmed me and showed me JUST HOW SIMPLE they are. I just needed to understand what value meant I think. Thank you so much!

[@codymbaldwin]

Thanks, Paige!

[@fabiandjm]

Love the way you explain it, so patiently and clear! Now I can add this Pivot tables knowledge to my resume lol.

[@naveedwantt2846]

Bhai... Can u please help me out with a 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 sepetately. Please bro, it's really important.

[@noelgonzalez9549]

Great Instructions. I particularly liked when you said just drop things around - I feel that's a good way to learn.

[@MrDC77DC]

Wonderful! thank you for clearly explaining the basics. Truly appreciate it!

[@ScorpioBeautyxx]

Awesome explanation and examples! I have an interview and needed to know how to do this. It's pretty simple. Thanks!

[@techknowhow4802]

Great beginners guide to building excel pivot tables. Someone could watch this and start building their own pivot tables and start doing some great analyses on their data right away. Thank you. I subbed. :)

[@WifeOfDJSteveHouston]

AWESOME INSTRUCTIONS!

[@alvinfranco5731]

I have an interview tomorrow morning and needed to learn pivot tables. This man is God sent!

[@engr.paulynejeremiahdipasu4812]

I have a freaking interview tomorrow and needed to refresh this as one of my "skills"

[@jrperena]

Very clear and you enunciate your words very well so I was able to follow. Quick and easy. Thank you

[@rokpodlogar6062]

excellent presentation but the zooming in actually made me lose the "big picture" :)

[@matthausfc9267]

Same

[@codymbaldwin]

My bad, Rok. You're right. I thought it would make it easier to see on a mobile device, but it can be distracting. I will see if I can post a version of the video without all the zoom.

[@evilmeme3359]

@@codymbaldwin Honest thought though, I would think most people looking into a help video for Excel would rather watch from a workstation/computer and not from a smartphone. For the smartphone screen I would agree with your assumption. Anyways the overall approach was helpful and thank you for making that video.

[@itsagoodday2165]

Cody Baldwin i am watching through mobile as i have clients i have to do this for. I hardly use my laptop as i am on my computer all day, so zoom in was perfect for someone who can’t see very well. This is the best video i seen where i grasped what actually is a Pivot table.

[@woonsuanloo506]

I think the zooming in is really good. I prefer zooming in rather than no zooming in. The zooming in helps me focus on what the teacher wants the audience to focus on when he speaks about something.

[@ikirangga3779]

The pivot table is so useful for me, the pivot can make my assignment become easy. This tutorial is very easy to understand.

[@randomname9758]

I know this is wayyyy after the fact but describing a slice and dice actually makes a lot more sense to me as pivot table sounds really intimidating. Great explanation thank you.

[@ivanmeno]

I never though I would actually need to learn this program :D

[@mpty2022]

thanks... you are a good teacher

[@imitatefirst]

Helped me analyze a large data set; this video helped me move beyond doing a simple data sort to more efficient analysis. Thank you -

[@armchaircritic5605]

Great tutorial guides. Very clear yet brief. Please do more!

[@alanmusic3495]

You have a knack for explaining things. I've seen several videos related to pivot tables that were too complicated, but your video gets right to the point and is very understandable. Thanks!

[@amjadmahmood5904]

wonderful, thanks for making pivot tables easy....after watching your video this is the first time I feel so comfortable on this subject that I can now teach pivot tables.

[@DawnBoyette]

You just saved me about 45 minutes a week! Thank you.

[@witty_net]

Crsytal clear! I understood every single detail. THANKS!

[@KAlovesherkitties]

That was explained incredibly well. Didn’t think I’d grasp pivot tables and this helped!

[@Justnik05]

I really appreciate this simplistic yet very useful explanation. I also appreciate your reminder to explore.

[@LaMitre-Corzy]

Thank you so much for taking the time to do this and share with the world

[@tayluvofficial]

Who's watching before final?😅

[@Akirashiro407]

😅

[@ronnyfernandez1986]

great video; i was looking for a short video which gives full information on getting started with pivots and this is precisely the one!

[@dianamontano223]

This was so clear and you’re gifted with a v soothing voice. thanks for your video, I didnt only learn but feel calm. thanks! God bless!

[@wbhauck]

Nice introduction to pivot tables. Thank you for sharing

[@jongkorkuol8112]

I wish I knew this page existed long before today. Thanks for excellent overview.

[@renss2072]

EXCELlent

[@coriculp]

Thank you! That really helped. So many employers are asking for this experience.

[@shahidahmed1809]

I never comment on KZbin videos but your videos made me do it. You make it look so easy. Well done and thank you

[@simpleexcelexamples9619]

Thank you for this video! The lay-out slightly changed over the course years but it is still very clear!

[@Inquisitive9]

Love it! very tactful style and approach to teaching. I liked how you started by just adding a single field to the values and built upon that.

[@lmutukisna3183]

Grate , its sounds easy hope I can watch it again a few times , Thanks Cody

[@skusa7106]

Great video tutorial! Thanks!!!

[@jennybt1827]

I'm taking a GALE intermediate Excel course and was so disheartened by the Pivot Table Lesson. Thanks for making it seem a little easier to understand.

[@tadasuko8935]

Extremely helpful video. Thank you for teaching in such a concise and some way!

[@johnconeff5832]

00:00 Start 00:40 Insert > Pivot Table 01:15 Insert > Add Pivot Table (gives range) 01:53 Choosing "Total Cost" 02:19 Choosing Rows option (filter) 03:39 Dragging Quantity to Rows 03:50 More information ... 04:15 Moving Rows to Columns 05:50 Design Pad

[@othmanhamzah6398]

Thank you very much sir, indeed you are a gifted teacher. Succint explanation combined with soothing voice.

[@tedt2139]

The best Pivot tool explanation on KZbin.

[@andreasgrenner5332]

Thx for this quick guide. It helped me a lot.

[@sararamonajohansson]

I'm about to cry. Pivot tables are my biggest fear and seeing them broken down in this simple way is an amazing relief.

[@codymbaldwin]

Aloha, Sara. I'm so glad this helped!

[@oigomieggo24]

Before: "Aw man, pivot tables? That sounds hard." After: "My feelings have...*puts on sunglasses* pivoted." Good tutorial

[@DrDamoStrikesBack]

Cue the theme song!

[@sapnanayak1453]

This comment is gold!

[@west1002]

Straight to the point! I needed this for a pre employment test! thanks guy!

[@da5603]

Really well done in a short amount of time. Thank you Cody. Officially subscribed.

[@sgarcata]

You have a lovely voice and demeaner for explanations like this. Many thanks.

[@lynestersarmie3220]

Best excel pivot tutorial I've watched. Thank you for this video

[@syedabeer829]

Thank you so much for simplifying it... nice presentation... cheers!

[@Chuk13838]

Great pacing and clear explanations. Thank you!

[@nileproductions3792]

Simply solved the pivot table problem, thanks Cody Baldwin.

[@ninatucker1579]

Great job!!! Just what i needed!!!

[@geraldgenita6742]

I'm actually here for my data analyst interview. this is a big help for me. thank you sir

[@cyber-eye1152]

Thank you. This is great. Simple and to the point.

[@andikaneduok1674]

This was a great tutorial, thank you for taking your time, I really appreciate how you elucidated every detail.

[@ll-hw4xn]

This was amazing. Thnx a bunch!

[@therese_a]

MAN, I hvae tried watching tons of tutorials here and u by far is the best!!! I got it right away after 3:39.

[@paulinekeysherpaula2482]

Ooh my God this is useful and it will alwats be usefull for centuries thanks alot please still useful in 2023

[@osababinladen420]

Thank you Cody... simple but effective lesson

[@srinivasmanchi8130]

Thanks for the explanation with easy examples, able to understand it quickly.

[@nataliekittylane4910]

Your voice is heavenly. Thank you for making this video - it is SUPER helpful :)

[@homesavvytech]

Thanks a ton for saving me a good 2 hours at word Cody.

[@gladysmaeademe1300]

This is a very comprehensive tutorial. Thank you 😁

[@lalchhanhima_DarkHeart]

So, last week i had a bank data analyst job interview and the interviewer ask me to bring my work experience certificate and all right after the interview. He ask if i know about pivot table in Excel and i do says im good in Excel/spreadsheets.. but little did i know, i was not expecting that will dominate the actual work.. which took around 60-70% of the analysis. I'm really glad i found this just in time. 🤣

[@topramen925]

Thank you for a simple, no-nonsense tutorial

[@asheikh6940]

Thank you for a very concise overview. Very helpful.