Тёмный

Learn Pivot Tables in 6 Minutes (Microsoft Excel) 

Cody Baldwin
Подписаться 83 тыс.
Просмотров 6 млн
50% 1

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.

Опубликовано:

 

18 окт 2015

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 691   
@codymbaldwin
@codymbaldwin 4 года назад
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
@koredeadedeji9254 4 года назад
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
@Billbro_Swagginz 4 года назад
This was very helpful. Thank you.
@maurosalvador1038
@maurosalvador1038 4 года назад
cargar un video de la función if por favor
@maurosalvador1038
@maurosalvador1038 4 года назад
upload a video of the if function please
@musicismagic5074
@musicismagic5074 4 года назад
I appreciate your presentation, but the close ups and moving across the screen was making me dizzy!
@doriabs
@doriabs 5 лет назад
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
@nub2max 5 лет назад
Yes, and then we remember to mention in the interview that we have experience in Pivots cuz we watched this vid.
@excellentviolet590
@excellentviolet590 5 лет назад
Same dude😂😂😂😂🙏
@oo4667
@oo4667 5 лет назад
but how did the interview go?
@eoinoliver4826
@eoinoliver4826 5 лет назад
Brilliant!
@alpacino9226
@alpacino9226 5 лет назад
same
@KingMechanics
@KingMechanics 5 лет назад
Watched this video before going on an interview. I’m trying to expand my skillset
@ytaaalx3195
@ytaaalx3195 5 лет назад
this is so me rn. i have an ojt interview tomorrow and i need to learn how to do this.
@rimigeriausia
@rimigeriausia 5 лет назад
Sameeeeeee
@LukeCage1015
@LukeCage1015 5 лет назад
I have an interview in 6 hours so that is also why I’m here lol
@jenniferlogan-porter9788
@jenniferlogan-porter9788 5 лет назад
@@cordneyellis442 Good luck!
@khairulazmi7432
@khairulazmi7432 5 лет назад
I got in my interview and the job but I still need to know this because I never use it before
@nathano1599
@nathano1599 2 года назад
Thanks for the timeless tutorial. 6 years later. Still immensely useful
@jodihume5857
@jodihume5857 4 года назад
HOLY COW this is helpful. I've always imagined pivot tables to be wildly complicated but you made it SO EASY.
@youtubepunisher8695
@youtubepunisher8695 5 лет назад
Boss: Are you comfortable with Excel? Me: Yes Boss: How about pivot tables Me: uhm Yes Also Me: *RU-vid Videos*
@yorandaingram1991
@yorandaingram1991 4 года назад
Learning everything Excel while in quarantine.
@user-hp5xs3bo8p
@user-hp5xs3bo8p 10 месяцев назад
Cody, You are BY FAR the best instructor for EXCEL on RU-vid. You don't bore us with small talk. You get right to the point of how to do the task. Thank you.
@rbergevine
@rbergevine 2 года назад
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.
@johnconeff5832
@johnconeff5832 2 года назад
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
@5reck0
@5reck0 4 года назад
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
@LenMarten
@LenMarten 2 года назад
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
@holbycat8833 2 года назад
AGREED!
@Stabbytabbycat
@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
@Britt1Nicole Год назад
came here to say this
@TheCactusCooler
@TheCactusCooler Год назад
Logged into youtube just to say this same thing.
@FredDrake76
@FredDrake76 3 года назад
Your voice is so calming. You're like the Bob Ross of Excel videos.
@nojokej
@nojokej 4 года назад
4-year-old video. Still delivering great value. Thank you for taking the time to make and share.
@rokpodlogar6062
@rokpodlogar6062 5 лет назад
excellent presentation but the zooming in actually made me lose the "big picture" :)
@matthausfc9267
@matthausfc9267 4 года назад
Same
@codymbaldwin
@codymbaldwin 4 года назад
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
@evilmeme3359 4 года назад
@@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
@itsagoodday2165 4 года назад
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
@woonsuanloo506 4 года назад
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.
@mertbeloglu
@mertbeloglu 5 лет назад
I don''t know how to thank you for this video. I have seen hundreds of pivot table tutorial videos on RU-vid, none of which made any sense. But now I finally understand after having watched your tutorial. Thanks a thousand, Cody Baldwin :)
@LoganWeilerIII
@LoganWeilerIII 4 года назад
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
@naveedwantt2846 2 года назад
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
@Retotion 2 года назад
@@naveedwantt2846 down bad
@shalysagavin6354
@shalysagavin6354 3 года назад
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.
@sshaoor7772
@sshaoor7772 4 года назад
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
@giantcat4354
@giantcat4354 2 года назад
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
@oladipupomesole8542 2 года назад
@Giant Cat, that’s why he got plenty of views, short video that hits the main point.
@tayluvofficial
@tayluvofficial 4 месяца назад
Who's watching before final?😅
@Akirashiro407
@Akirashiro407 2 месяца назад
😅
@paigey72
@paigey72 4 года назад
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
@codymbaldwin 4 года назад
Thanks, Paige!
@chrismitchell2333
@chrismitchell2333 2 года назад
This is the best explanation I've heard of pivot tables - clear and really helpful. Thank you!
@depth386
@depth386 5 лет назад
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
@DigitalBeaver
@DigitalBeaver 2 года назад
Well you just showed me in 6 minutes what I've been avoiding for 16 years. WOW. So easy, thank you.
@MsRyder120
@MsRyder120 4 года назад
I am so glad there are people like you who enjoy Excel & are also really good at teaching people. You're a lifesaver.
@naveedwantt2846
@naveedwantt2846 2 года назад
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.
@Morgan-cu2hb
@Morgan-cu2hb 4 года назад
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!
@jazlr721
@jazlr721 6 лет назад
Awesome! Six minutes and my perspective of doing pivot table changed. Thank you for this!
@soljer99
@soljer99 5 лет назад
Great video, makes easy to understand and learn the basic concepts of Pivot Tables. Thank you for posting it, Cody!
@WhosDercy
@WhosDercy 3 года назад
Clear, simple, and straight to point, Thank you.
@alvinfranco5731
@alvinfranco5731 3 года назад
I have an interview tomorrow morning and needed to learn pivot tables. This man is God sent!
@engr.paulynejeremiahdipasu4812
@engr.paulynejeremiahdipasu4812 2 года назад
I have a freaking interview tomorrow and needed to refresh this as one of my "skills"
@BollywoodBonanzaB
@BollywoodBonanzaB 4 года назад
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
@gullysteph 4 года назад
BollywoodBonanzaB That was just selfish of your colleague😕
@Nutellabrot9
@Nutellabrot9 3 года назад
Short, precise, boiled down ! Perfect - thanks Cody!
@N3v3rDuplicated
@N3v3rDuplicated 3 года назад
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
@thatninja8 2 года назад
hope this helped you run the business smoother, best of luck
@abaddon319
@abaddon319 6 лет назад
wow that you for the easy to understand demonstration. I did not even know how useful the pivot table was until now.
@ScorpioBeautyxx
@ScorpioBeautyxx 4 года назад
Awesome explanation and examples! I have an interview and needed to know how to do this. It's pretty simple. Thanks!
@TheBladeofMiquella
@TheBladeofMiquella 4 года назад
This is honestly one of best explanations for Pivot Tables I've seen, very nice job
@sosenaofor
@sosenaofor 3 года назад
Very good video.Short and straight to the point. No waste of time, high-quality information. Thanks dude
@NepaliKidsinUSA
@NepaliKidsinUSA 15 дней назад
You have made pivot table so easy. I always think it is quite complicated. Thank you, you made my job easy.
@alanmusic3495
@alanmusic3495 3 месяца назад
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!
@randomname9758
@randomname9758 2 года назад
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.
@fabiandjm
@fabiandjm 4 года назад
Love the way you explain it, so patiently and clear! Now I can add this Pivot tables knowledge to my resume lol.
@naveedwantt2846
@naveedwantt2846 2 года назад
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.
@baongchannelEn
@baongchannelEn 5 лет назад
thank you man, slow enough for beginners to digest!
@swizzleproxi4810
@swizzleproxi4810 4 года назад
I was worrying about pivot tables but not now, after seeing your video I took a sigh of relief 👍😃ahhh
@dianamontano223
@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!
@ikirangga3779
@ikirangga3779 4 года назад
The pivot table is so useful for me, the pivot can make my assignment become easy. This tutorial is very easy to understand.
@noelgonzalez9549
@noelgonzalez9549 6 лет назад
Great Instructions. I particularly liked when you said just drop things around - I feel that's a good way to learn.
@imitatefirst
@imitatefirst 4 года назад
Helped me analyze a large data set; this video helped me move beyond doing a simple data sort to more efficient analysis. Thank you -
@ivanmeno
@ivanmeno 5 лет назад
I never though I would actually need to learn this program :D
@lalchhanhima_DarkHeart
@lalchhanhima_DarkHeart 2 года назад
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. 🤣
@jongkorkuol8112
@jongkorkuol8112 5 лет назад
I wish I knew this page existed long before today. Thanks for excellent overview.
@renss2072
@renss2072 4 года назад
EXCELlent
@prettyyella32
@prettyyella32 5 лет назад
Thank you so very much for this video. Can't thank you enough.
@sararamonajohansson
@sararamonajohansson 5 лет назад
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
@codymbaldwin 4 года назад
Aloha, Sara. I'm so glad this helped!
@KAlovesherkitties
@KAlovesherkitties 2 года назад
That was explained incredibly well. Didn’t think I’d grasp pivot tables and this helped!
@Inquisitive9
@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.
@lolliemoua
@lolliemoua 5 лет назад
This video will change the course of my life. Thank you so much.
@jrperena
@jrperena 5 лет назад
Very clear and you enunciate your words very well so I was able to follow. Quick and easy. Thank you
@jennybt1827
@jennybt1827 2 года назад
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.
@oigomieggo24
@oigomieggo24 4 года назад
Before: "Aw man, pivot tables? That sounds hard." After: "My feelings have...*puts on sunglasses* pivoted." Good tutorial
@DrDamoStrikesBack
@DrDamoStrikesBack 3 года назад
Cue the theme song!
@sapnanayak1453
@sapnanayak1453 2 года назад
This comment is gold!
@techknowhow4802
@techknowhow4802 6 лет назад
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. :)
@ronnyfernandez1986
@ronnyfernandez1986 5 лет назад
great video; i was looking for a short video which gives full information on getting started with pivots and this is precisely the one!
@shahidahmed1809
@shahidahmed1809 4 года назад
I never comment on RU-vid videos but your videos made me do it. You make it look so easy. Well done and thank you
@simpleexcelexamples9619
@simpleexcelexamples9619 2 года назад
Thank you for this video! The lay-out slightly changed over the course years but it is still very clear!
@WifeOfDJSteveHouston
@WifeOfDJSteveHouston 6 лет назад
AWESOME INSTRUCTIONS!
@armchaircritic5605
@armchaircritic5605 4 года назад
Great tutorial guides. Very clear yet brief. Please do more!
@amjadmahmood5904
@amjadmahmood5904 4 года назад
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.
@MrDC77DC
@MrDC77DC 4 года назад
Wonderful! thank you for clearly explaining the basics. Truly appreciate it!
@mpty2022
@mpty2022 5 лет назад
thanks... you are a good teacher
@DawnBoyette
@DawnBoyette 2 года назад
You just saved me about 45 minutes a week! Thank you.
@LaMitre-Corzy
@LaMitre-Corzy 4 года назад
Thank you so much for taking the time to do this and share with the world
@paulinekeysherpaula2482
@paulinekeysherpaula2482 Год назад
Ooh my God this is useful and it will alwats be usefull for centuries thanks alot please still useful in 2023
@Justnik05
@Justnik05 4 года назад
I really appreciate this simplistic yet very useful explanation. I also appreciate your reminder to explore.
@coriculp
@coriculp 4 года назад
Thank you! That really helped. So many employers are asking for this experience.
@othmanhamzah6398
@othmanhamzah6398 4 года назад
Thank you very much sir, indeed you are a gifted teacher. Succint explanation combined with soothing voice.
@wbhauck
@wbhauck 5 лет назад
Nice introduction to pivot tables. Thank you for sharing
@lmutukisna3183
@lmutukisna3183 5 лет назад
Grate , its sounds easy hope I can watch it again a few times , Thanks Cody
@rajkumarpanditYouTub
@rajkumarpanditYouTub 3 года назад
Thank you very much - Cody Baldwin. May I happen to see your video a little late but - it is great. A simple way to learn-- I was struggling to get this concept this long.
@da5603
@da5603 3 года назад
Really well done in a short amount of time. Thank you Cody. Officially subscribed.
@MoonMagickSpirit
@MoonMagickSpirit 3 года назад
*Applies for job that requires knowledge of pivot tables not knowing anything about pivot tables and gets interview* So now I'm here trying to learn about pivot tables LOL
@tadasuko8935
@tadasuko8935 2 года назад
Extremely helpful video. Thank you for teaching in such a concise and some way!
@skusa7106
@skusa7106 6 лет назад
Great video tutorial! Thanks!!!
@tedt2139
@tedt2139 2 года назад
The best Pivot tool explanation on RU-vid.
@west1002
@west1002 2 года назад
Straight to the point! I needed this for a pre employment test! thanks guy!
@ll-hw4xn
@ll-hw4xn 5 лет назад
This was amazing. Thnx a bunch!
@eimran1178
@eimran1178 4 года назад
Thanks for the vid. I also prefer an overall overview instead of specific zoom but it's not that much of a problem to me. Other than that a very Well explained informative video.
@rolandemmerich5993
@rolandemmerich5993 Год назад
This is like, 1 semestre of college explained in 6 mins 🙂
@MPOTW
@MPOTW 6 лет назад
Why so few comments eh? Very good explanation.
@andikaneduok1674
@andikaneduok1674 7 месяцев назад
This was a great tutorial, thank you for taking your time, I really appreciate how you elucidated every detail.
@andreasgrenner5332
@andreasgrenner5332 5 лет назад
Thx for this quick guide. It helped me a lot.
@geraldgenita6742
@geraldgenita6742 2 года назад
I'm actually here for my data analyst interview. this is a big help for me. thank you sir
@witty_net
@witty_net 4 года назад
Crsytal clear! I understood every single detail. THANKS!
@homesavvytech
@homesavvytech 5 лет назад
Thanks a ton for saving me a good 2 hours at word Cody.
@Turrican
@Turrican 5 лет назад
This is a really good video thank you so much so I'm off to try some experiments now
@BollywoodBonanzaB
@BollywoodBonanzaB 4 года назад
Now THIS is how you spend a weekend night! 😂👍👍👍👍👍👍
@ninatucker1579
@ninatucker1579 6 лет назад
Great job!!! Just what i needed!!!
@sgarcata
@sgarcata 3 года назад
You have a lovely voice and demeaner for explanations like this. Many thanks.
@wesNeill
@wesNeill 3 года назад
Great video. Came here trying to understand pivoting Pandas DataFrame.pivot, and actually came away with a decent understanding. Thank you.
@peytonwaskey2774
@peytonwaskey2774 5 лет назад
I was looking for some more advanced help on pivot tables, but if I were just starting out this would have been very helpful.
@codymbaldwin
@codymbaldwin 4 года назад
That's good feedback. I will work on an advanced pivot tables video.
@sethorinmusic
@sethorinmusic 4 года назад
Cody, I was watching this video with some soothing spa music on. Your voice and the music was very relaxing together. Perhaps you could record some guided meditations?
@kyojins9467
@kyojins9467 4 года назад
video: learn pivot tables in 6 minutes me, changing playback speed to 2x: that's 3 minutes trooper
@kyojins9467
@kyojins9467 4 года назад
@i’ll grabsack your dad’s wheatnut former debater
@user-db1zc1pg7c
@user-db1zc1pg7c 3 года назад
@@kyojins9467 good one - then thats justifiable
@nileproductions3792
@nileproductions3792 3 года назад
Simply solved the pivot table problem, thanks Cody Baldwin.