How to use Pivot Tables in Excel - A Step-by-step guide
Ғылым және технология
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...
Пікірлер: 355
Wowwwwwwww aft this 10 min i had a smile in my face ,due to value addition , thanks a lot
@bilalhassankhan221
2 жыл бұрын
Same with me!! 😛
@tapasvipannaty2849
2 жыл бұрын
Same here :D
@venkatakartheekkarnati8893
2 жыл бұрын
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.
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
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! 😊👍
@chandoo_
2 жыл бұрын
Thank you Vijay...
@introvertboyedith4638
2 жыл бұрын
Ur right
I love the logical thought flow and no-nonsense style. Thank you for sharing!
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!
@chandoo_
3 жыл бұрын
So happy to see this. I am glad you are now confident of using Pivot Tables.
You explained way much better than the other videos in KZread, thank you 👍
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!
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
Apart from the quality of the content, your style and humor factor makes it worthwhile to watch😊
@chandoo_
3 жыл бұрын
Thanks Priti... :)
Thank you, Chandoo. You always add value to my knowledge Bank. Really glad that i found your page.
Liked before starting as I know this will be awesome.
Thank you for making understanding the pivot table/chart concept so easy with an analogy.
Thank you for these simple steps, Chandoo!
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.
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 :)
@chandoo_
2 жыл бұрын
You're welcome!
Dear Chandoo, Awesome , thank you for very much , nice explanation. Liked the potato analogy 👏👏
Another awesome video, Chandoo. Though I was familiar with many of these things, some ideas were new to me. Thanks. Well presented, too!
@chandoo_
3 жыл бұрын
Thank you senpai....
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.
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!
I freaking LOVE your videos. Teaching me something important while making me laugh a bit. Thanks, sir!
Hi Chandoo. Awesome Pivot Table starter video! Thanks for sharing :)) Thumbs up!!
this is a really clear tutorial on pivot tables. Thanks!
@chandoo_
3 жыл бұрын
Glad it was helpful!
One of the best Guru in the excel world.👏👏👏👏
Just love your teaching style. Awesome work brother 👍
Love you bro ❤️ finally a proper channel to improve myself!
Such a clarity on everything..I just lovved it
This was brilliant Chandoo. I learnt how to employ PivotTables for varied datasets with this one video. Thank you.
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...
love your style, especially the finger clicking (a hidden excel feature) - have subscribed
@chandoo_
3 жыл бұрын
The best one really... Thank you and welcome :)
You are the best. I am learning a lot from you anytime I watch your videos
Dear your knowldege of excel is marvlous. I learned a lot from tutorials/lectures. all the best
You are great Sir, Even an old birdbrain like me could understand the beauty of Pivot tables. Thanks a lot.
sending a virtual flying kiss, thank you for such premium content! the most worth it video for 10 minutes.
@chandoo_
2 жыл бұрын
😊 Thanks Georgene...
on top of the excel you have incredible editing skills, nice video all around!
Thank chandoo, your share video i put for my main excel learning reference. Hope you always doing well..
Thanks Chandu bhai. As a fresher it was very useful to me!
@chandoo_
Жыл бұрын
Always welcome
completely awesome run-through-thank you!
@chandoo_
2 жыл бұрын
Glad you enjoyed it! 😀
Thanks Chandoo. Very Useful indeed thank you!
i like the way you explain, so simple but awesome!
@chandoo_
3 жыл бұрын
Glad you liked it!
Thank you .... Your teaching methods are so good ... It really fun learning
Thank god I found your channel admist of my struggle with data love to you
I love your content so much!❤️
Thank you soooo much for making it so easy to learn and understand ✨
It’s all most useful skill you are sharing to us! Thank you!
@chandoo_
2 жыл бұрын
My pleasure!
You have no idea how much this helps.. Thanks bro!
@chandoo_
9 ай бұрын
Happy to help!
I enjoy watching how you teach! Thanks Chandoooooooooo :)
@chandoo_
2 жыл бұрын
My pleasure!
You have created a great channel!Thank you for all your efforts!!!!
@chandoo_
2 жыл бұрын
You are welcome Ertugrul.
Grande Aula Chandoo agragou muito para meus conhecimentos. Thank You !
Your way of presentation is awesome man❤️
@chandoo_
3 жыл бұрын
Thank you so much 😀
Very helpful video on Pivot tables. Thank u
Thank you very much for such a well detailed tutorial.
I was looking for this. Thank you Chandoo. 😍Wonderful presentation 👏👏
@chandoo_
2 жыл бұрын
My pleasure 😊
Awesome video, It helped me to understand pivot table concept, Thanks a Ton
@chandoo_
3 жыл бұрын
Thank you Vijay... Be sure to practice too.
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.
@chandoo_
3 жыл бұрын
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.
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
Your explanations are superb 🙏
Thank you for your effort. learned a lot from you!
Thank you so much, this information has helped me. I was completely lost before.
@chandoo_
2 жыл бұрын
Thanks Nicholas. I call this the Potato Pathfinder 🥔🥔🥔
Chandoo you are amazing and inspiration for me❤️❤️
Mann....😥 No words to say ...nailed it... Thanks a lot.🙏🙏🙏🙏
@chandoo_
2 жыл бұрын
Most welcome 😊
Very very very helpful, thank you so much. You earned my like and subscription.
Thanks for the quick yet comprehensive tutorial sir! Also, love that background music that you've added, one of my personal favourites!
@chandoo_
3 жыл бұрын
Thanks Utkarsh for enjoying the video :)
I am new to excel, this video helped me out a lot. Thank you sir 😇😇
@chandoo_
6 ай бұрын
All the best
Lego Technic, nice! Excellent pacing too, well done! I learned a lot more than I expected.
@chandoo_
2 жыл бұрын
EVERYTHING IS AWESOME!!!
Big big big fan of yourself 🙂 thanks for everything, keep it up sir
This was amazing, good job!
@chandoo_
Жыл бұрын
Glad you liked it!
I can't take the risk of not subscribing to your channel... Thanks for doing such a great job... Please do some data analysis projects on excel for real life experience... Thank you very much...
really appreciate the video, must needed for me !!
Learned A lot . Thanks Chandoo
@chandoo_
2 жыл бұрын
You are welcome Nikhil 😀
So awesome Chandoo power!! Many thanks:)
@chandoo_
2 жыл бұрын
Glad you like it!
Just brilliant!
Thanks chandooo Brother for teaching us ❤️
Amazing, easy understanding, thanks for sharing 😊
@chandoo_
Жыл бұрын
Glad it was helpful!
Thank you so so helpful to see step by step examples :)
@chandoo_
2 жыл бұрын
Glad it was helpful!
Hi, Feeling blessed after following your tutorials. I searched so much but now feel that going in the right direction. I have been teaching mathematics and statistics till 12 graders. But now in the last year, I am so fascinated with converting data to visuals so want to become a data analyst. Thinking, Certainly you are the right Mentor for me. I will be very grateful to you if you can show me the right path to becoming a data analyst by clearing my doubts, Which is more worthy certification or a degree? Please Please answer.....
Great video. Short and precise.
@chandoo_
3 жыл бұрын
Thank you...
Thanks a LOT ! lotlotlot ! it's clear, it's didactic, perfect for what I'm planning.
Awesome presentation 👏 👌 👍 🙌.
Thanks for this and grateful
Thank you for this awesome video 🙌
@chandoo_
2 жыл бұрын
You're so welcome!
Thanks Dada for sharing the valuable tricks on Pivot Table
MasyaAllah keren banget....and terima kasih banget ya.. absolutely brilliant tutorial... ❤
Awesome Chandoo...@DFTBA!
Woow! I am very happy with this video!
@chandoo_
2 жыл бұрын
Thank you! 😃
Thanks sir, for such simple way of teaching
Wonderful presentation: easy to understand, informative, entertaining, and effective. Exactly what I was looking for. Thank you! Also, data (raw potatoes) -> information (fries) ->knowledge (hunger satisfied)?
Great job honestly Bro
Wow such a amazing video thank you so much I learnt so many thinks 10mins
@chandoo_
2 жыл бұрын
You are welcome Madan.. :)
You are rocking Sir!
watching from the Philippines
Amazing Chandoo u r awesome 😎
Excellent sir, thank you
Very nicely explained.
Thanks a lot chandoo It's really good
@chandoo_
3 жыл бұрын
Most welcome 😊
I am the new learner and I see this video is only the best with which I can learn .. Thanks for these types of video and I would request u to make a video on business analyst if u r new comer then how u can become business analyst with another working experience
@chandoo_
3 жыл бұрын
Glad it was helpful! I will add such a video. Meanwhile watch my recent video on data analyst skills here - kzread.info/dash/bejne/mYqmm8hqd63KisY.html
omg this blew my mind !!!
Thanks for sharing the percentage method. I was using it with manual method but it will comes always error when we change the value from slicer... Just start the video for looking the answer. And found it ..... Great work 👏 👍
Chandu You have got such a sweet voice.. I must say it's devine and addictive. How you teach brother it's just amazing
@chandoo_
2 жыл бұрын
Thanks Akshay. :)