Learn Pivot Tables in 6 Minutes (Microsoft Excel)
HTML-код
- Опубликовано: 22 авг 2024
- Here is the sample file: www.codybaldwi.... Interested in learning more. You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwi....
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.
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
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?
This was very helpful. Thank you.
cargar un video de la función if por favor
upload a video of the if function please
I appreciate your presentation, but the close ups and moving across the screen was making me dizzy!
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
Yes, and then we remember to mention in the interview that we have experience in Pivots cuz we watched this vid.
Same dude😂😂😂😂🙏
but how did the interview go?
Brilliant!
same
Watched this video before going on an interview. I’m trying to expand my skillset
this is so me rn. i have an ojt interview tomorrow and i need to learn how to do this.
Sameeeeeee
I have an interview in 6 hours so that is also why I’m here lol
@@cordneyellis442 Good luck!
I got in my interview and the job but I still need to know this because I never use it before
Cody, You are BY FAR the best instructor for EXCEL on RUclips. You don't bore us with small talk. You get right to the point of how to do the task. Thank you.
Boss: Are you comfortable with Excel?
Me: Yes
Boss: How about pivot tables
Me: uhm Yes
Also Me: *RUclips Videos*
Hopefully the boss won't give you an excel worksheet to work your magic ;)
@@nickmeijer88 that's why you watch the video first lol
rocky mountain lass That is the honest truth!
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?!
RUclips Punisher, dude same.
Thanks for the timeless tutorial. 6 years later. Still immensely useful
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.
HOLY COW this is helpful. I've always imagined pivot tables to be wildly complicated but you made it SO EASY.
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
Learning everything Excel while in quarantine.
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.
@Giant Cat, that’s why he got plenty of views, short video that hits the main point.
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
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
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.
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.
@@naveedwantt2846 down bad
Your voice is so calming. You're like the Bob Ross of Excel videos.
*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
I don''t know how to thank you for this video. I have seen hundreds of pivot table tutorial videos on RUclips, none of which made any sense. But now I finally understand after having watched your tutorial.
Thanks a thousand, Cody Baldwin :)
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.
AGREED!
It was disorienting. I appreciate the knowledge shared but would have preferred the wide shot so the changes could be seen in real time.
came here to say this
Logged into youtube just to say this same thing.
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. :)
BollywoodBonanzaB That was just selfish of your colleague😕
I have an interview tomorrow morning and needed to learn pivot tables. This man is God sent!
I have a freaking interview tomorrow and needed to refresh this as one of my "skills"
I am so glad there are people like you who enjoy Excel & are also really good at teaching people. You're a lifesaver.
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.
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!
Thanks, Paige!
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. 🤣
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.
4-year-old video. Still delivering great value. Thank you for taking the time to make and share.
excellent presentation but the zooming in actually made me lose the "big picture" :)
Same
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.
@@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.
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.
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.
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!
Well you just showed me in 6 minutes what I've been avoiding for 16 years. WOW. So easy, thank you.
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!
Who's watching before final?😅
😅
Before: "Aw man, pivot tables? That sounds hard."
After: "My feelings have...*puts on sunglasses* pivoted."
Good tutorial
Cue the theme song!
This comment is gold!
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!
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!
hope this helped you run the business smoother, best of luck
This is the best explanation I've heard of pivot tables - clear and really helpful. Thank you!
I'm about to cry. Pivot tables are my biggest fear and seeing them broken down in this simple way is an amazing relief.
Aloha, Sara. I'm so glad this helped!
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
Clear, simple, and straight to point, Thank you.
You're a natural teacher, this video was so easy to follow, thank you!
I was worrying about pivot tables but not now, after seeing your video I took a sigh of relief 👍😃ahhh
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.
Ooh my God this is useful and it will alwats be usefull for centuries thanks alot please still useful in 2023
I never comment on RUclips videos but your videos made me do it. You make it look so easy. Well done and thank you
The best Pivot tool explanation on RUclips.
You have made pivot table so easy. I always think it is quite complicated. Thank you, you made my job easy.
You just saved me about 45 minutes a week! Thank you.
Love the way you explain it, so patiently and clear! Now I can add this Pivot tables knowledge to my resume lol.
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.
The pivot table is so useful for me, the pivot can make my assignment become easy. This tutorial is very easy to understand.
I wish I knew this page existed long before today. Thanks for excellent overview.
EXCELlent
thank you man, slow enough for beginners to digest!
Very clear and you enunciate your words very well so I was able to follow. Quick and easy. Thank you
This is honestly one of best explanations for Pivot Tables I've seen, very nice job
I'm actually here for my data analyst interview. this is a big help for me. thank you sir
Awesome explanation and examples! I have an interview and needed to know how to do this. It's pretty simple. Thanks!
You have a lovely voice and demeaner for explanations like this. Many thanks.
I love the fact you make this easy to learn and understand
I think this is the best intro of pivot table on yt. Like ur tutorial and ur first name.Thanks Cody
Short, precise, boiled down ! Perfect - thanks Cody!
video: learn pivot tables in 6 minutes
me, changing playback speed to 2x: that's 3 minutes trooper
@i’ll grabsack your dad’s wheatnut former debater
@@kyojins9467 good one - then thats justifiable
Thank you for a simple, no-nonsense tutorial
Thank you very much sir, indeed you are a gifted teacher. Succint explanation combined with soothing voice.
Thanks for the explanation with easy examples, able to understand it quickly.
This video will change the course of my life. Thank you so much.
Best excel pivot tutorial I've watched. Thank you for this video
This is like, 1 semestre of college explained in 6 mins 🙂
MAN, I hvae tried watching tons of tutorials here and u by far is the best!!! I got it right away after 3:39.
I found this video because......PIVOT TABLES - proficiency needed. Thanks so much! These comments are priceless......
wow that you for the easy to understand demonstration. I did not even know how useful the pivot table was until now.
Very good video.Short and straight to the point. No waste of time, high-quality information. Thanks dude
okay, I will have to watch this multiple times, but that has more to do with my brain than anything else. gotta say, Cody makes the medicine go down easy. mellow, unhurried not lots of "ums" and bouncing all over the place... he doesn't teach from his "I already know this" brain, but the "I will assume you don't know anything about these and that's why you're here" brain. it helps people like me. thank you. gotta see what he has on V and X lookups. I hate Excel, but I hate it less now.
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.
This is the best video pivot table explained on youtube
Thank you for creating this tutorial, Cody! This helps a lot!!
ty i passed my exam because of u what a god
Straight to the point! I needed this for a pre employment test! thanks guy!
Simply solved the pivot table problem, thanks Cody Baldwin.
I really appreciate this simplistic yet very useful explanation. I also appreciate your reminder to explore.
This was a great tutorial, thank you for taking your time, I really appreciate how you elucidated every detail.
All of your excel videos are awesome!!! Thanks for putting this together.
When he writes the video title.. he means it.. thanks for the nice explanation btw
Great video, makes easy to understand and learn the basic concepts of Pivot Tables. Thank you for posting it, Cody!
Excellent bro..... You did it in easy way... Bravo...
One happy Ninja!. Your tutorial is clear and complete. Thank you!
Thank you so much! What a great video. You are a fantastically clear instructor!
GREAT video. helping me study for my midterm :,)
You don't need to do the zoom and moving back and forth. Just show the whole screen.
I am very New to excel..zooming helps.
Zooming makes it clearer what we're supposed to be looking at (although darkening the other areas of the sceen would also work). It also makes sure the video is easy to view even if it isn't in full screen or is been viewed on a phone screen.
I like the zooming. Easier to follow the cursor/pointer this way. Just saying.
Speak for yourself. Zooming is helpful to so many others
No thank you. Personally I appreciate the zoom because I am looking at this on a smart phone. The video is better the way it is for some of us.
Bro made teaching excel looks so eaaassyyy. You on fire bro. keep going!
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.
Helped me analyze a large data set; this video helped me move beyond doing a simple data sort to more efficient analysis. Thank you -
This guy is a great narrator.
great video; i was looking for a short video which gives full information on getting started with pivots and this is precisely the one!
This is literally the definition of work smart, not hard.
Crsytal clear! I understood every single detail. THANKS!
I never though I would actually need to learn this program :D
Very good video. I fell asleep in about 10 seconds.
I am here to make my job easier and faster.
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.
YOU ARE LITERALLY BLOWING MY MIND RIGHT NOW! VERY GOOD VID! 💯
So nice and slowly presentation which can understand easily... love
Great video. Came here trying to understand pivoting Pandas DataFrame.pivot, and actually came away with a decent understanding. Thank you.
Awesome! Six minutes and my perspective of doing pivot table changed. Thank you for this!