How to use Pivot Tables in Excel - A Step-by-step guide
HTML-код
- Опубликовано: 19 июн 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... - Наука
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.
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
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!
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 RUclips, thank 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
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!
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!
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.
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!
Apart from the quality of the content, your style and humor factor makes it worthwhile to watch😊
Thanks Priti... :)
Thank you, Chandoo.
You always add value to my knowledge Bank. Really glad that i found your page.
One of the best Guru in the excel world.👏👏👏👏
Thank you for making understanding the pivot table/chart concept so easy with an analogy.
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...
Liked before starting as I know this will be awesome.
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.
This was brilliant Chandoo. I learnt how to employ PivotTables for varied datasets with this one video. Thank you.
I freaking LOVE your videos. Teaching me something important while making me laugh a bit. Thanks, sir!
Thank you for these simple steps, Chandoo!
Such a clarity on everything..I just lovved it
You are great Sir,
Even an old birdbrain like me could understand the beauty of Pivot tables. Thanks a lot.
Just love your teaching style. Awesome work brother 👍
Love you bro ❤️ finally a proper channel to improve myself!
Dear your knowldege of excel is marvlous. I learned a lot from tutorials/lectures. all the best
You are the best. I am learning a lot from you anytime I watch your videos
Dear Chandoo, Awesome , thank you for very much , nice explanation. Liked the potato analogy 👏👏
this is a really clear tutorial on pivot tables. Thanks!
Glad it was helpful!
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....
completely awesome run-through-thank you!
Glad you enjoyed it! 😀
Thank god I found your channel admist of my struggle with data love to you
Hi Chandoo. Awesome Pivot Table starter video! Thanks for sharing :)) Thumbs up!!
Thank you .... Your teaching methods are so good ... It really fun learning
Thank you very much for such a well detailed tutorial.
Grande Aula Chandoo agragou muito para meus conhecimentos. Thank You !
sending a virtual flying kiss, thank you for such premium content! the most worth it video for 10 minutes.
😊 Thanks Georgene...
You have no idea how much this helps.. Thanks bro!
Happy to help!
Thank you for your effort. learned a lot from you!
Thanks Chandoo. Very Useful indeed thank you!
love your style, especially the finger clicking (a hidden excel feature) - have subscribed
The best one really... Thank you and welcome :)
on top of the excel you have incredible editing skills, nice video all around!
Thank you soooo much for making it so easy to learn and understand ✨
Thanks Chandu bhai. As a fresher it was very useful to me!
Always welcome
Mann....😥 No words to say ...nailed it... Thanks a lot.🙏🙏🙏🙏
Most welcome 😊
i like the way you explain, so simple but awesome!
Glad you liked it!
It’s all most useful skill you are sharing to us! Thank you!
My pleasure!
Big big big fan of yourself 🙂 thanks for everything, keep it up sir
Thank chandoo, your share video i put for my main excel learning reference. Hope you always doing well..
really appreciate the video, must needed for me !!
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
Chandoo you are amazing and inspiration for me❤️❤️
I love your content so much!❤️
Very helpful video on Pivot tables. Thank u
Your explanations are superb 🙏
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.....
MasyaAllah keren banget....and terima kasih banget ya.. absolutely brilliant tutorial... ❤
Thanks Dada for sharing the valuable tricks on Pivot Table
Just brilliant!
Thanks for this and grateful
You have created a great channel!Thank you for all your efforts!!!!
You are welcome Ertugrul.
Thanks chandooo Brother for teaching us ❤️
I enjoy watching how you teach! Thanks Chandoooooooooo :)
My pleasure!
Thank you so much, this information has helped me. I was completely lost before.
Thanks Nicholas. I call this the Potato Pathfinder 🥔🥔🥔
Thanks sir, for such simple way of teaching
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...
omg this blew my mind !!!
Thanks a LOT ! lotlotlot ! it's clear, it's didactic, perfect for what I'm planning.
Awesome video, It helped me to understand pivot table concept, Thanks a Ton
Thank you Vijay... Be sure to practice too.
Lego Technic, nice! Excellent pacing too, well done! I learned a lot more than I expected.
EVERYTHING IS AWESOME!!!
Super👍 Thank god i found ur channel
Chandu, good video.
Can you teach how to do reconciliation between two sets of data, the work area where I intern requires these types of reconciliation and I struggle because data is too big.
Woow! I am very happy with this video!
Thank you! 😃
Awesome presentation 👏 👌 👍 🙌.
Thank you so so helpful to see step by step examples :)
Glad it was helpful!
Amazing, easy understanding, thanks for sharing 😊
Glad it was helpful!
You are rocking Sir!
This was amazing, good job!
Glad you liked it!
I was looking for this. Thank you Chandoo. 😍Wonderful presentation 👏👏
My pleasure 😊
Great video. Short and precise.
Thank you...
watching from the Philippines
Excellent sir, thank you
Thank you for this awesome video 🙌
You're so welcome!
Your way of presentation is awesome man❤️
Thank you so much 😀
Chandu You have got such a sweet voice.. I must say it's devine and addictive.
How you teach brother it's just amazing
Thanks Akshay. :)
great videos ! awesome!
Great job honestly Bro
Very very very helpful, thank you so much. You earned my like and subscription.
Wow such a amazing video thank you so much I learnt so many thinks 10mins
You are welcome Madan.. :)
Thank you!!🙏🙏😎
fine,thank you bro!
Great video. Thanks a lot🎉🎉🎉🎉🎉
Learned A lot . Thanks Chandoo
You are welcome Nikhil 😀
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 👏 👍
thank you so much 🙏
So awesome Chandoo power!! Many thanks:)
Glad you like it!
Nice collection of Lego on the stairs :)
Bro you are the best
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