How to use Pivot Tables in Excel - A Step-by-step guide

Рет қаралды 297,036

Күн бұрын

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...

Пікірлер: 360

@sridharv8432 3 жыл бұрын

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.

@penielmgbado2562 27 күн бұрын

He's really good!

@todayis325 Жыл бұрын

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. ❤️

@judya2664 Жыл бұрын

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! 💯💫🍟

@vijayarjunwadkar 2 жыл бұрын

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

@SiddharthaNarayanan 2 жыл бұрын

I love the logical thought flow and no-nonsense style. Thank you for sharing!

@rohanshirude5117 3 жыл бұрын

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.

@Zomeone Жыл бұрын

You explained way much better than the other videos in KZfaq, thank you 👍

@studymate8469 Жыл бұрын

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

@aadityadixit2075 3 жыл бұрын

Thank you, Chandoo. You always add value to my knowledge Bank. Really glad that i found your page.

@sunilaryan 3 жыл бұрын

Liked before starting as I know this will be awesome.

@parth_pm16 2 жыл бұрын

Thank you for making understanding the pivot table/chart concept so easy with an analogy.

@wayneedmondson1065 3 жыл бұрын

Hi Chandoo. Awesome Pivot Table starter video! Thanks for sharing :)) Thumbs up!!

@toorank7669 2 ай бұрын

Thank you for these simple steps, Chandoo!

@dineshajgaonkar4984 Жыл бұрын

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!

@pritikane4448 3 жыл бұрын

Apart from the quality of the content, your style and humor factor makes it worthwhile to watch😊

@chandoo_ 3 жыл бұрын

Thanks Priti... :)

@venkatakartheekkarnati8893 2 жыл бұрын

@iambilly 2 жыл бұрын

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!

@senpai.5517 3 жыл бұрын

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....

@caissa6187 2 жыл бұрын

I freaking LOVE your videos. Teaching me something important while making me laugh a bit. Thanks, sir!

@JunaidKhan-gq8nw 7 күн бұрын

Genius, lot of respect for you my dearest sir Chandoo.

@anubhutisingh4194 4 ай бұрын

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.

@saianish7075 2 жыл бұрын

Love you bro ❤️ finally a proper channel to improve myself!

@emilieward6415 Жыл бұрын

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!

@YTantirungrotechai 3 жыл бұрын

this is a really clear tutorial on pivot tables. Thanks!

@chandoo_ 3 жыл бұрын

Glad it was helpful!

@soumyasajjan4006 Жыл бұрын

Such a clarity on everything..I just lovved it

@msjohn6529 11 ай бұрын

This was brilliant Chandoo. I learnt how to employ PivotTables for varied datasets with this one video. Thank you.

@minkish781 2 жыл бұрын

Just love your teaching style. Awesome work brother 👍

@exwhyz33 3 жыл бұрын

love your style, especially the finger clicking (a hidden excel feature) - have subscribed

@chandoo_ 3 жыл бұрын

The best one really... Thank you and welcome :)

@shreyanshdangi4366 Ай бұрын

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

@ReviewsTechy Жыл бұрын

One of the best Guru in the excel world.👏👏👏👏

@DanielMoreira_18 2 жыл бұрын

on top of the excel you have incredible editing skills, nice video all around!

@mohitsingha210 Жыл бұрын

Thanks Chandoo. Very Useful indeed thank you!

@shriidharkulkarni6648 2 жыл бұрын

You are great Sir, Even an old birdbrain like me could understand the beauty of Pivot tables. Thanks a lot.

@EduardoSilva-mt4su Жыл бұрын

Grande Aula Chandoo agragou muito para meus conhecimentos. Thank You !

@pratibhadadhich6104 Жыл бұрын

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...

@LetubaMatsepe-yh7mw 11 ай бұрын

You are the best. I am learning a lot from you anytime I watch your videos

@georgeneamodia7240 2 жыл бұрын

sending a virtual flying kiss, thank you for such premium content! the most worth it video for 10 minutes.

@chandoo_ 2 жыл бұрын

😊 Thanks Georgene...

@DenisThornton 2 жыл бұрын

completely awesome run-through-thank you!

@chandoo_ 2 жыл бұрын

Glad you enjoyed it! 😀

@Tommy_Univerxse Жыл бұрын

I love your content so much!❤️

@katilitaufik4149 2 жыл бұрын

Thank chandoo, your share video i put for my main excel learning reference. Hope you always doing well..

@ImtiazHussain-hy8br Жыл бұрын

Dear your knowldege of excel is marvlous. I learned a lot from tutorials/lectures. all the best

@BijoySalahuddin 2 жыл бұрын

Thank you very much for such a well detailed tutorial.

@chandrimachoudhury1057 Жыл бұрын

Very helpful video on Pivot tables. Thank u

@OsmanOsman-cu1ic 2 жыл бұрын

Thank you for your effort. learned a lot from you!

@NATIONALISTBBAU 11 ай бұрын

Thank god I found your channel admist of my struggle with data love to you

@fernandnikolaicapellan1480 Жыл бұрын

Very very very helpful, thank you so much. You earned my like and subscription.

@arshiyafarheen505 7 ай бұрын

Thank you soooo much for making it so easy to learn and understand ✨

@jpemanahan8699 3 жыл бұрын

i like the way you explain, so simple but awesome!

@chandoo_ 3 жыл бұрын

Glad you liked it!

@ertugrulb 2 жыл бұрын

You have created a great channel!Thank you for all your efforts!!!!

@chandoo_ 2 жыл бұрын

You are welcome Ertugrul.

@kumarsandeep3952 2 жыл бұрын

Thank you .... Your teaching methods are so good ... It really fun learning

@IndianGraduate 2 жыл бұрын

really appreciate the video, must needed for me !!

@zoeyzou1910 2 жыл бұрын

It’s all most useful skill you are sharing to us! Thank you!

@chandoo_ 2 жыл бұрын

My pleasure!

@Prashant.Ingale Жыл бұрын

Thanks Chandu bhai. As a fresher it was very useful to me!

@chandoo_ Жыл бұрын

Always welcome

@roadsailor79 10 ай бұрын

You have no idea how much this helps.. Thanks bro!

@chandoo_ 10 ай бұрын

Happy to help!

@georgeaboh 2 жыл бұрын

I enjoy watching how you teach! Thanks Chandoooooooooo :)

@chandoo_ 2 жыл бұрын

My pleasure!

@catlord21 11 ай бұрын

Thanks a LOT ! lotlotlot ! it's clear, it's didactic, perfect for what I'm planning.

@FreeSpeech1959 2 жыл бұрын

Just brilliant!

@VijayKumar-hw7ys 3 жыл бұрын

Awesome video, It helped me to understand pivot table concept, Thanks a Ton

@chandoo_ 3 жыл бұрын

Thank you Vijay... Be sure to practice too.

@Acheiropoietos 2 жыл бұрын

Lego Technic, nice! Excellent pacing too, well done! I learned a lot more than I expected.

@chandoo_ 2 жыл бұрын

EVERYTHING IS AWESOME!!!

@ashequrrahmankhan915 Жыл бұрын

Awesome presentation 👏 👌 👍 🙌.

@osrsyambo Жыл бұрын

This was amazing, good job!

@chandoo_ Жыл бұрын

Glad you liked it!

@ojatola 2 жыл бұрын

Thanks for this and grateful

@DaveS-we5xs Ай бұрын

Dear Chandoo, Awesome , thank you for very much , nice explanation. Liked the potato analogy 👏👏

@shaikusman536 2 жыл бұрын

Awesome Chandoo...@DFTBA!

@NicO-cm2xo 2 жыл бұрын

So awesome Chandoo power!! Many thanks:)

@chandoo_ 2 жыл бұрын

Glad you like it!

@gurmailsingh942 7 ай бұрын

Great video. Thanks a lot🎉🎉🎉🎉🎉

@rogeriopsvalle 3 жыл бұрын

Great video. Short and precise.

@chandoo_ 3 жыл бұрын

Thank you...

@lijidevasaras 2 жыл бұрын

I was looking for this. Thank you Chandoo. 😍Wonderful presentation 👏👏

@chandoo_ 2 жыл бұрын

My pleasure 😊

@RMKserve 2 жыл бұрын

Chandoo you are amazing and inspiration for me❤️❤️

@canirmalchoudhary8173 3 жыл бұрын

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.

@hussainsardarulmulk 2 жыл бұрын

great videos ! awesome!

@sabrareservation 2 жыл бұрын

Great job honestly Bro

@chamindasilva3191 2 жыл бұрын

Your explanations are superb 🙏

@tennified6600 9 ай бұрын

omg this blew my mind !!!

@ashishh1323 2 жыл бұрын

Very nicely explained.

@arauf963 2 жыл бұрын

Amazing Chandoo u r awesome 😎

@nicholaschin4503 2 жыл бұрын

Thank you so much, this information has helped me. I was completely lost before.

@chandoo_ 2 жыл бұрын

Thanks Nicholas. I call this the Potato Pathfinder 🥔🥔🥔

@primeknowledge99 2 жыл бұрын

Big big big fan of yourself 🙂 thanks for everything, keep it up sir

@sharavv676 2 жыл бұрын

Mann....😥 No words to say ...nailed it... Thanks a lot.🙏🙏🙏🙏

@chandoo_ 2 жыл бұрын

Most welcome 😊

@yilianbruckner2461 2 жыл бұрын

Woow! I am very happy with this video!

@chandoo_ 2 жыл бұрын

Thank you! 😃

@user-nt2tl7xv8g 2 жыл бұрын

Thank you so so helpful to see step by step examples :)

@chandoo_ 2 жыл бұрын

Glad it was helpful!

@pgkannan 3 жыл бұрын

Your way of presentation is awesome man❤️

@chandoo_ 3 жыл бұрын

Thank you so much 😀

@chethann7871 Жыл бұрын

Thanks chandooo Brother for teaching us ❤️

@Userisnmuh Жыл бұрын

MasyaAllah keren banget....and terima kasih banget ya.. absolutely brilliant tutorial... ❤

@coffeewithkrupesh2113 Жыл бұрын

Amazing, easy understanding, thanks for sharing 😊

@chandoo_ Жыл бұрын

Glad it was helpful!

@adeeppradhan5795 2 жыл бұрын

Great video..very informative

@manojkumarleo 3 жыл бұрын

You are rocking Sir!

@workstuff5253 3 жыл бұрын

Nice collection of Lego on the stairs :)

@SushantRaghavan 2 жыл бұрын

Thank you for this awesome video 🙌

@chandoo_ 2 жыл бұрын

You're so welcome!

@Hollywood2Tollywood04 5 күн бұрын

Awesome Anna

@mobinuddin7131 2 жыл бұрын

Thanks Dada for sharing the valuable tricks on Pivot Table

@HariKrishna-yl9kq Жыл бұрын

Excellent sir, thank you

@bilalyusaf7822 Жыл бұрын

Excellent video 👍

@utkarshkunwar4319 3 жыл бұрын

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 :)

@swatisaxena3044 2 жыл бұрын

Super👍 Thank god i found ur channel

@OMMI100m 2 жыл бұрын

Learned A lot . Thanks Chandoo

@chandoo_ 2 жыл бұрын

You are welcome Nikhil 😀

@madan8951 3 жыл бұрын

Wow such a amazing video thank you so much I learnt so many thinks 10mins

@chandoo_ 3 жыл бұрын

You are welcome Madan.. :)

@justarandomj261 2 жыл бұрын

Thanks sir, for such simple way of teaching

@signofshinejobs6391 3 жыл бұрын

Thanks a lot chandoo It's really good

@chandoo_ 3 жыл бұрын

Most welcome 😊

@myklopez9843 Жыл бұрын

watching from the Philippines