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

  • @sridharv8432
    @sridharv84323 жыл бұрын

    Wowwwwwwww aft this 10 min i had a smile in my face ,due to value addition , thanks a lot

  • @bilalhassankhan221

    @bilalhassankhan221

    2 жыл бұрын

    Same with me!! 😛

  • @tapasvipannaty2849

    @tapasvipannaty2849

    2 жыл бұрын

    Same here :D

  • @venkatakartheekkarnati8893

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

  • @shreyanshdangi4366
    @shreyanshdangi43663 күн бұрын

    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

  • @todayis325
    @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
    @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
    @vijayarjunwadkar2 жыл бұрын

    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_

    @chandoo_

    2 жыл бұрын

    Thank you Vijay...

  • @introvertboyedith4638

    @introvertboyedith4638

    2 жыл бұрын

    Ur right

  • @SiddharthaNarayanan
    @SiddharthaNarayanan2 жыл бұрын

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

  • @rohanshirude5117
    @rohanshirude51173 жыл бұрын

    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_

    @chandoo_

    3 жыл бұрын

    So happy to see this. I am glad you are now confident of using Pivot Tables.

  • @Zomeone
    @Zomeone Жыл бұрын

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

  • @dineshajgaonkar4984
    @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!

  • @studymate8469
    @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

  • @pritikane4448
    @pritikane44483 жыл бұрын

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

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Thanks Priti... :)

  • @aadityadixit2075
    @aadityadixit20753 жыл бұрын

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

  • @sunilaryan
    @sunilaryan3 жыл бұрын

    Liked before starting as I know this will be awesome.

  • @parth_pm16
    @parth_pm162 жыл бұрын

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

  • @toorank7669
    @toorank7669Ай бұрын

    Thank you for these simple steps, Chandoo!

  • @venkatakartheekkarnati8893
    @venkatakartheekkarnati88932 жыл бұрын

    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.

  • @iambilly
    @iambilly2 жыл бұрын

    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_

    @chandoo_

    2 жыл бұрын

    You're welcome!

  • @DaveS-we5xs
    @DaveS-we5xs22 күн бұрын

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

  • @senpai.5517
    @senpai.55173 жыл бұрын

    Another awesome video, Chandoo. Though I was familiar with many of these things, some ideas were new to me. Thanks. Well presented, too!

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Thank you senpai....

  • @anubhutisingh4194
    @anubhutisingh41943 ай бұрын

    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.

  • @emilieward6415
    @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!

  • @caissa6187
    @caissa61872 жыл бұрын

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

  • @wayneedmondson1065
    @wayneedmondson10653 жыл бұрын

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

  • @YTantirungrotechai
    @YTantirungrotechai3 жыл бұрын

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

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Glad it was helpful!

  • @ReviewsTechy
    @ReviewsTechy Жыл бұрын

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

  • @minkish781
    @minkish781 Жыл бұрын

    Just love your teaching style. Awesome work brother 👍

  • @saianish7075
    @saianish70752 жыл бұрын

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

  • @soumyasajjan4006
    @soumyasajjan4006 Жыл бұрын

    Such a clarity on everything..I just lovved it

  • @msjohn6529
    @msjohn652910 ай бұрын

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

  • @pratibhadadhich6104
    @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...

  • @exwhyz33
    @exwhyz333 жыл бұрын

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

  • @chandoo_

    @chandoo_

    3 жыл бұрын

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

  • @LetubaMatsepe-yh7mw
    @LetubaMatsepe-yh7mw11 ай бұрын

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

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

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

  • @shriidharkulkarni6648
    @shriidharkulkarni66482 жыл бұрын

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

  • @georgeneamodia7240
    @georgeneamodia72402 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    😊 Thanks Georgene...

  • @DanielMoreira_18
    @DanielMoreira_182 жыл бұрын

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

  • @katilitaufik4149
    @katilitaufik41492 жыл бұрын

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

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

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

  • @chandoo_

    @chandoo_

    Жыл бұрын

    Always welcome

  • @DenisThornton
    @DenisThornton2 жыл бұрын

    completely awesome run-through-thank you!

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    Glad you enjoyed it! 😀

  • @mohitsingha210
    @mohitsingha210 Жыл бұрын

    Thanks Chandoo. Very Useful indeed thank you!

  • @jpemanahan8699
    @jpemanahan86993 жыл бұрын

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

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Glad you liked it!

  • @kumarsandeep3952
    @kumarsandeep39522 жыл бұрын

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

  • @NATIONALISTBBAU
    @NATIONALISTBBAU10 ай бұрын

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

  • @Tommy_Univerxse
    @Tommy_Univerxse Жыл бұрын

    I love your content so much!❤️

  • @arshiyafarheen505
    @arshiyafarheen5056 ай бұрын

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

  • @zoeyzou1910
    @zoeyzou19102 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    My pleasure!

  • @roadsailor79
    @roadsailor799 ай бұрын

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

  • @chandoo_

    @chandoo_

    9 ай бұрын

    Happy to help!

  • @georgeaboh
    @georgeaboh2 жыл бұрын

    I enjoy watching how you teach! Thanks Chandoooooooooo :)

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    My pleasure!

  • @ertugrulb
    @ertugrulb2 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    You are welcome Ertugrul.

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

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

  • @pgkannan
    @pgkannan3 жыл бұрын

    Your way of presentation is awesome man❤️

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Thank you so much 😀

  • @chandrimachoudhury1057
    @chandrimachoudhury1057 Жыл бұрын

    Very helpful video on Pivot tables. Thank u

  • @BijoySalahuddin
    @BijoySalahuddin2 жыл бұрын

    Thank you very much for such a well detailed tutorial.

  • @user-tp4xv9uf4y
    @user-tp4xv9uf4y2 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    My pleasure 😊

  • @VijayKumar-hw7ys
    @VijayKumar-hw7ys3 жыл бұрын

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

  • @chandoo_

    @chandoo_

    3 жыл бұрын

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

  • @canirmalchoudhary8173
    @canirmalchoudhary81733 жыл бұрын

    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_

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

  • @user-zp6go2tz2r
    @user-zp6go2tz2r4 ай бұрын

    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

  • @chamindasilva3191
    @chamindasilva31912 жыл бұрын

    Your explanations are superb 🙏

  • @OsmanOsman-cu1ic
    @OsmanOsman-cu1ic2 жыл бұрын

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

  • @nicholaschin4503
    @nicholaschin45032 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

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

  • @RMKserve
    @RMKserve2 жыл бұрын

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

  • @sharavv676
    @sharavv6762 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    Most welcome 😊

  • @fernandnikolaicapellan1480
    @fernandnikolaicapellan1480 Жыл бұрын

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

  • @utkarshkunwar4319
    @utkarshkunwar43193 жыл бұрын

    Thanks for the quick yet comprehensive tutorial sir! Also, love that background music that you've added, one of my personal favourites!

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Thanks Utkarsh for enjoying the video :)

  • @aishwaryagandhi1878
    @aishwaryagandhi18786 ай бұрын

    I am new to excel, this video helped me out a lot. Thank you sir 😇😇

  • @chandoo_

    @chandoo_

    6 ай бұрын

    All the best

  • @Acheiropoietos
    @Acheiropoietos2 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    EVERYTHING IS AWESOME!!!

  • @primeknowledge99
    @primeknowledge992 жыл бұрын

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

  • @osrsyambo
    @osrsyambo Жыл бұрын

    This was amazing, good job!

  • @chandoo_

    @chandoo_

    Жыл бұрын

    Glad you liked it!

  • @divyamsaxena295
    @divyamsaxena2953 жыл бұрын

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

  • @IndianGraduate
    @IndianGraduate2 жыл бұрын

    really appreciate the video, must needed for me !!

  • @OMMI100m
    @OMMI100m2 жыл бұрын

    Learned A lot . Thanks Chandoo

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    You are welcome Nikhil 😀

  • @NicO-cm2xo
    @NicO-cm2xo2 жыл бұрын

    So awesome Chandoo power!! Many thanks:)

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    Glad you like it!

  • @FreeSpeech1959
    @FreeSpeech19592 жыл бұрын

    Just brilliant!

  • @chethann7871
    @chethann7871 Жыл бұрын

    Thanks chandooo Brother for teaching us ❤️

  • @coffeewithkrupesh2113
    @coffeewithkrupesh2113 Жыл бұрын

    Amazing, easy understanding, thanks for sharing 😊

  • @chandoo_

    @chandoo_

    Жыл бұрын

    Glad it was helpful!

  • @user-nt2tl7xv8g
    @user-nt2tl7xv8g2 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    Glad it was helpful!

  • @dipisingh5268
    @dipisingh5268 Жыл бұрын

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

  • @rogeriopsvalle
    @rogeriopsvalle3 жыл бұрын

    Great video. Short and precise.

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Thank you...

  • @catlord21
    @catlord2110 ай бұрын

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

  • @ashequrrahmankhan915
    @ashequrrahmankhan915 Жыл бұрын

    Awesome presentation 👏 👌 👍 🙌.

  • @ojatola
    @ojatola2 жыл бұрын

    Thanks for this and grateful

  • @SushantRaghavan
    @SushantRaghavan2 жыл бұрын

    Thank you for this awesome video 🙌

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    You're so welcome!

  • @mobinuddin7131
    @mobinuddin71312 жыл бұрын

    Thanks Dada for sharing the valuable tricks on Pivot Table

  • @Userisnmuh
    @Userisnmuh Жыл бұрын

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

  • @shaikusman536
    @shaikusman5362 жыл бұрын

    Awesome Chandoo...@DFTBA!

  • @yilianbruckner2461
    @yilianbruckner24612 жыл бұрын

    Woow! I am very happy with this video!

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    Thank you! 😃

  • @justarandomj261
    @justarandomj2612 жыл бұрын

    Thanks sir, for such simple way of teaching

  • @josephhinkle3454
    @josephhinkle3454 Жыл бұрын

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

  • @sabrareservation
    @sabrareservation2 жыл бұрын

    Great job honestly Bro

  • @madan8951
    @madan89512 жыл бұрын

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

  • @chandoo_

    @chandoo_

    2 жыл бұрын

    You are welcome Madan.. :)

  • @manojkumarleo
    @manojkumarleo3 жыл бұрын

    You are rocking Sir!

  • @myklopez9843
    @myklopez9843 Жыл бұрын

    watching from the Philippines

  • @arauf963
    @arauf9632 жыл бұрын

    Amazing Chandoo u r awesome 😎

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

    Excellent sir, thank you

  • @ashishh1323
    @ashishh13232 жыл бұрын

    Very nicely explained.

  • @signofshinejobs6391
    @signofshinejobs63913 жыл бұрын

    Thanks a lot chandoo It's really good

  • @chandoo_

    @chandoo_

    3 жыл бұрын

    Most welcome 😊

  • @kanishkashrivastavaofficial
    @kanishkashrivastavaofficial3 жыл бұрын

    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_

    @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

  • @tennified6600
    @tennified66008 ай бұрын

    omg this blew my mind !!!

  • @zainulabidin8482
    @zainulabidin84822 жыл бұрын

    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 👏 👍

  • @AkshayKumar-ko2ny
    @AkshayKumar-ko2ny2 жыл бұрын

    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_

    @chandoo_

    2 жыл бұрын

    Thanks Akshay. :)

Келесі