How to use Pivot Tables in Excel - A Step-by-step guide
Вставка
- Опубліковано 7 лип 2024
- Just started your data analyst career? Pivot Tables make your life easy. In this short but PACKED video, let me show you how to make 8 everyday reports using Pivot Tables in Excel.
Be sure to download sample dataset to practice the concepts.
Link - chandoo.org/wp/wp-content/upl...
In this video:
==========
0:00 - Introduction
1:24 - Making your first pivot table
2:33 - Total Sales by Sales Person - Report 1
3:40 - Sales by Person & Geography - Report 2
4:34 - Sales by Person with Geography Filter - Report 3
5:04 - Top 10 Products with Sales - Value Filter - Report 4
6:04 - Interactive Reports with Pivots - Report 5
7:00 - Pivot Charts
7:30 - Interactive Pivot Charts
8:24 - Report 8 - Sales as value & Percentages with bars
9:15 - Refreshing when you have new data
9:49 - What's next? - Advanced Pivot Tables
Sample Data & 8 Reports:
=====================
Blank data file: chandoo.org/wp/wp-content/upl...
Final reports: chandoo.org/wp/wp-content/upl...
LEARN MORE on PIVOT TABLES: Videos & Articles
=========================================
Getting started with Pivot Tables - Article - chandoo.org/wp/excel-pivot-ta...
Advanced Pivot Tables - Video Playlist - • Easily link Slicers to...
How to make pivot tables from LARGE DATASETS - • How to make pivot tabl...
My favourite time saving Pivot Table tips - • 6 Massively time savin...
COMPLETE DATA ANALYSIS COURSE
===============================
If you want a complete hands-on course to master DATA ANALYSIS with EXCEL, check out my Excel School Program. To date, more than 10,000 people around the world have gone thru this course and became AWESOME at their work.
Go here 👉 chandoo.org/wp/excel-school-p... - Наука та технологія
![19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]](/img/n.gif)
Wowwwwwwww aft this 10 min i had a smile in my face ,due to value addition , thanks a lot
Same with me!! 😛
Same here :D
Thanks a lot, basically under rows we have to write (group by features, we can move some features to columns if required) , where condition in filters, which features to aggregate and what to aggregate in the Values box-- for those coming from sql background this will be useful.
He's really good!
College never taught us important things like this. I'm so glad there are people like you who willingly teaches important things for an adult for free. Bless your channel. ❤️
Dear Chandoo, I have watched many other instructional Excel videos, but your videos make learning Excel easy and fun. You are a gifted person and a delightful teacher. I am grateful for your knowledge, kindness and humor. Thank you! 💯💫🍟
Even after you know something about an Excel feature, when Chandoo teaches it, you get to learn something more and often unknown that adds value. Keep up the great work Chandoo! 😊👍
Thank you Vijay...
Ur right
this is just like concepts freshen up video for those who r following the entire playlist because all the parts we studied are used in one way or the other
Man this was awesome learning curve for me. I was very new to pivot tables , now I feel like I have been doing this for years! Loving it!
So happy to see this. I am glad you are now confident of using Pivot Tables.
I love the logical thought flow and no-nonsense style. Thank you for sharing!
Dear Mr. Chandoo, You are the first one who has explained the video step by step. it was quite helpful in understanding this video on PT, PG, and Slicers with multiple presenting parameters: I request, keep sharing such Learning and Growing MS office software skills: Could you please share a video on PPT with us?:👌👌🙏🙏 God Bless You!
You explained way much better than the other videos in UA-cam, thank you 👍
Apart from the quality of the content, your style and humor factor makes it worthwhile to watch😊
Thanks Priti... :)
Liked before starting as I know this will be awesome.
Your video is exactly what I was looking for, no fuss, no muss, just a perfect 10 min tutorial about pivot table basics. THANK YOU kind sir :)
You're welcome!
I just love to come to your channel to learn whenever I have a doubt in excel. Even if I know the concept well, if I come to your channel, I am sure that I will always get to know something more. Please keep sharing such interactive videos and I still don't know how to select custom data for a chart or a graph to represent on x and y axis. I would love to see you upload a video on this topic. Thank you
Thanks a lot, basically under rows we have to write (group by features, we can move some features to columns if required) , where condition in filters, which features to aggregate and what to aggregate in the Values box-- for those coming from sql background this will be useful.
One of the best Guru in the excel world.👏👏👏👏
Thank you, Chandoo.
You always add value to my knowledge Bank. Really glad that i found your page.
Usually, these online tutorials are soooo dry that I get bored and quit before they finish;, but with Chandoos online tutorials, it's like you've turned around to ask a close colleague for help. That said, the only improvement, at least from my chair, is that often I couldn't see past your head as it was blocking the bottom of the PivotTable Fields, but aside from that...excellent!
Thank you for making understanding the pivot table/chart concept so easy with an analogy.
Thank you for these simple steps, Chandoo!
Very well explained. Haven't found a better explanation video since long. My interest in Excel has resurfaced because of this one. Thanks a lot.
I freaking LOVE your videos. Teaching me something important while making me laugh a bit. Thanks, sir!
Another awesome video, Chandoo. Though I was familiar with many of these things, some ideas were new to me. Thanks. Well presented, too!
Thank you senpai....
Hi Chandoo. Awesome Pivot Table starter video! Thanks for sharing :)) Thumbs up!!
I hope I would have got to know about this earlier. I would not fail at interview saying I dont advanced excel.. Thank you so much. Now I can strongly recommend anyone this channel and hope you reach millions of subscribers soon. Now I am confident enough to face the next interview in Investment Banking...
this is a really clear tutorial on pivot tables. Thanks!
Glad it was helpful!
You are great Sir,
Even an old birdbrain like me could understand the beauty of Pivot tables. Thanks a lot.
love your style, especially the finger clicking (a hidden excel feature) - have subscribed
The best one really... Thank you and welcome :)
Dear Chandoo, Awesome , thank you for very much , nice explanation. Liked the potato analogy 👏👏
completely awesome run-through-thank you!
Glad you enjoyed it! 😀
This was brilliant Chandoo. I learnt how to employ PivotTables for varied datasets with this one video. Thank you.
Such a clarity on everything..I just lovved it
sending a virtual flying kiss, thank you for such premium content! the most worth it video for 10 minutes.
😊 Thanks Georgene...
Just love your teaching style. Awesome work brother 👍
Love you bro ❤️ finally a proper channel to improve myself!
Just brilliant!
I love your content so much!❤️
Mann....😥 No words to say ...nailed it... Thanks a lot.🙏🙏🙏🙏
Most welcome 😊
Thanks Chandoo. Very Useful indeed thank you!
You have no idea how much this helps.. Thanks bro!
Happy to help!
great videos ! awesome!
This was amazing, good job!
Glad you liked it!
omg this blew my mind !!!
You are the best. I am learning a lot from you anytime I watch your videos
on top of the excel you have incredible editing skills, nice video all around!
i like the way you explain, so simple but awesome!
Glad you liked it!
I enjoy watching how you teach! Thanks Chandoooooooooo :)
My pleasure!
You have created a great channel!Thank you for all your efforts!!!!
You are welcome Ertugrul.
Thank chandoo, your share video i put for my main excel learning reference. Hope you always doing well..
Lego Technic, nice! Excellent pacing too, well done! I learned a lot more than I expected.
EVERYTHING IS AWESOME!!!
Thanks Chandu bhai. As a fresher it was very useful to me!
Always welcome
really appreciate the video, must needed for me !!
Very helpful video on Pivot tables. Thank u
It’s all most useful skill you are sharing to us! Thank you!
My pleasure!
Thank you very much for such a well detailed tutorial.
Dear your knowldege of excel is marvlous. I learned a lot from tutorials/lectures. all the best
Awesome Chandoo...@DFTBA!
Thank god I found your channel admist of my struggle with data love to you
Thank you for your effort. learned a lot from you!
Woow! I am very happy with this video!
Thank you! 😃
Thanks for this and grateful
Nice collection of Lego on the stairs :)
So awesome Chandoo power!! Many thanks:)
Glad you like it!
Great job honestly Bro
Thanks a LOT ! lotlotlot ! it's clear, it's didactic, perfect for what I'm planning.
You are rocking Sir!
Great video. Short and precise.
Thank you...
Awesome video, It helped me to understand pivot table concept, Thanks a Ton
Thank you Vijay... Be sure to practice too.
Awesome presentation 👏 👌 👍 🙌.
Thank you for this awesome video 🙌
You're so welcome!
Your way of presentation is awesome man❤️
Thank you so much 😀
Very nicely explained.
Great video. Thanks a lot🎉🎉🎉🎉🎉
Learned A lot . Thanks Chandoo
You are welcome Nikhil 😀
Chandoo!!!
this the nice presentation on Pivot Table and Slicer, also I liked the conciseness of the tutorial. Please continue the same in next video so that we can get maximum in minimum.
Thanks Nirmal. I am learning how to make better, concise and powerful videos. I am glad this one hit the nail on head. I will observe the video performance and make changes to my storytelling as needed.
Amazing Chandoo u r awesome 😎
Thank you soooo much for making it so easy to learn and understand ✨
When he said "this is a classic example of a raw potato" I couldn't help but laugh 😂I LOVE the analogy, thank you so much, this is just what I needed this morning
Amazing, easy understanding, thanks for sharing 😊
Glad it was helpful!
Thank you .... Your teaching methods are so good ... It really fun learning
Thank you so so helpful to see step by step examples :)
Glad it was helpful!
Excellent video 👍
Grande Aula Chandoo agragou muito para meus conhecimentos. Thank You !
MasyaAllah keren banget....and terima kasih banget ya.. absolutely brilliant tutorial... ❤
Your explanations are superb 🙏
Excellent Brother
watching from the Philippines
Super👍 Thank god i found ur channel
I was looking for this. Thank you Chandoo. 😍Wonderful presentation 👏👏
My pleasure 😊
AWESOMEEEEEE
Thank you so much, this information has helped me. I was completely lost before.
Thanks Nicholas. I call this the Potato Pathfinder 🥔🥔🥔
Bro you are the best
Sir you are best teacher when it comes to excel, power bi and data visualization. Sir just a request kindly share the secret to your calmness sir
Wonderful video
Very very very helpful, thank you so much. You earned my like and subscription.
woow great bro
Thanks chandooo Brother for teaching us ❤️
Chandoo you are amazing and inspiration for me❤️❤️
Thanks for the quick yet comprehensive tutorial sir!
Also, love that background music that you've added, one of my personal favourites!
Thanks Utkarsh for enjoying the video :)
Thank you!!🙏🙏😎
Excellent sir, thank you