Pivot Tables in Excel - Intro & Step-by-step tutorial

#PivotTables #ExcelPivots
Excel pivot tables are very useful and powerful feature of MS Excel. They are be used to create instant summaries, reports and data analysis from your raw data. In this comprehensive Pivot Tables Tutorial, learn what is a Pivot Table, how to create one, how to filter & sort them, changing the calculations and many other tips.
Download sample data & learn more from below page.
chandoo.org/wp/excel-pivot-ta...

[@dorcassamuel1743]

Absolutely helpful! I'll recommend your tutorials over and over again. Thank you!

[@pvrameshbabu]

Nice overview of Pivot tables. People will start liking pivot tables and realize the benefits of a powerful tool.

[@ryanng328]

You're the only Indian I've seen so far that teach using English Language so that I can understand, bravo and many thanks!

[@aidanbrennan7389]

Amazing. I learned loads. Greetings from Ireland 🇮🇪

[@jake_from_statefarm7209]

Thank you for posting! I've been intimidated by pivot tables for a long time, but your explanation was fantastic! You're a natural teacher.

[@tanviikhar4077]

same here

[@VireshParmar]

Thank for making this very east to follow! Looking forward to Power Pivot videos :)

[@user-jy9ls9fx2o]

Hi Chandoo Thank for this tutorial, it is indeed very deep on how to use pivot tables. I realy enjoy you tutorials, my skills are getting better and better.

[@deepsaha9085]

Thank you for creating such good lessons💛 I am blessed to have you.

[@jonyfitness0311]

best teacher ever

[@rohitbhosale4614]

Thank you sir. You are real hero.God bless you

[@chandoo_]

You are welcome Rohit. More power to you 😀

[@Hindurashtra16]

Your explanation is awesome

[@ildefonsomahilum7374]

Thank you so much for this tutorial it's easy to follow!

[@abhisheksaraf4704]

😀Finally understood pivot table

[@karo1152]

Thanks for sharing. I find it useful and precise

[@michaelmiller2833]

Thank you for sharing. This information is very helpful! Awesome Job.

[@avinashkharapkar3378]

You are one of the best teacher i have come across. You are simply awesome! Thank you Chandoo :) Also, any sources where i could practice more on pivot tables?

[@chandoo_]

Hi Avinash.. thank you. I suggest visiting the below links for everything on Pivot Tables 1. chandoo.org/wp/excel-pivot-tables-tutorial/ 2. chandoo.org/wp/pivot-table-time-saving-tricks/ 3. chandoo.org/wp/advanced-pivot-tables/ All the best.

[@avinashkharapkar3378]

@@chandoo_ Thanks man! :)

[@gokulnath9473]

Hey chandoo! thanks for this wonderful lesson. Love from India

[@chandoo_]

My pleasure!

[@jjessica7582]

It's amazing . thanks. Chandoo !! Great work 👍😎👍👍😎

[@chandoo_]

You are welcome JPR....

[@sunilkumarsahu6466]

I am a MBA student, my aim is to be a data analyst. i am following your every videos for my learning. Thanks so much sir. looking for more interesting corporate related videos

[@faisalhussnain2778]

Bhai me bhe data analyst kr na chata hu pr plz tum thora guide kero

[@tajumir48]

A lot I have learned from this ❤❤❤thanks.

[@wayneedmondson1065]

Thanks Chandoo!!

[@lawlightplayz4071]

Wonderful as always

[@lamborghiniveneno8423]

Awesome Tutorial bro!!

[@chandoo_]

Glad you liked it!

[@EswarValluri]

Amazing tutorial

[@chandoo_]

Glad you think so!

[@yolandamascarenhas7062]

Thank you This was so helpful What if you change the amounts of different cells, or correct names spellings etc Will the refresh button update the pivot tables What you have shown is just new data addition I will be grateful if you advise Thank you

[@hazemali382]

chandoo you are one of the lovely teacher ♥

[@chandoo_]

Thanks Hazem for your love and support 😍

[@hazemali382]

​@@chandoo_ we are learning and from our duties support you ♥

[@rashikaushal7950]

Thank you so much sir .LOVE AND BLESSINGS ALL THE WAY FROM CHANDIGARH,INDIA. I AM ABOUT TO JOIN A BIG 4 AS AN AUDIT ASSISTANT,SO THIS WOULD BE REALLY HELPFUL.

[@chandoo_]

All the best

[@designhubshani1976]

Amazing! Thanks

[@biveksubedi4276]

awesome vedio sir Thank you so much Love from nepal

[@chandoo_]

So nice. Dhanyavad... 🙏

[@shekharchandra9495]

Thanking You Chandoo Garu

[@ankurpathak199]

Hi Sir, I am stuck with a college project. I am using Pivot, but I have a column where each text value is hyperlinked. The hyperlinks are not working in the pivot. Could you help me here? Or if you have any video on that? I could not find any solution for this on your channel. Please advise :)

[@ShowBizJunkie]

What version of excel you are using? I have not seen the "Table Design" on Excel before

[@drawwithkawaii9347]

very proud that ur telugu

[@justarandomj261]

Thanks sir

[@deepu91d]

Is there any video available for advanced usage of pivot ?

[@chandoo_]

Please see this play list - kzbin.info/aero/PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx

[@vijaychauhan5447]

Sir Will you make goods stock report In excel sheet ? If you already have please tell me.

[@chandoo_]

Interesting idea. I will share a template on this soon.

[@srinivaskandru5034]

You don't need to go to Value field settings, dude.. @12:58 after the right click there's an option for Number format..just use that which can skip an extra step.

[@chandoo_]

Wow, that is new. I have been using the value field settings route for so many years. Thanks for sharing this :)

[@srinivaskandru5034]

@@chandoo_ You're welcome and you proved you are not a robot by doiing that. Captcha is success, access approved..hehehe

[@riazahmad4821]

👍

[@mahathmasadineni2884]

Chandoo garu pivot tables in custom sorting Chusthuntey avatledhu

[@chandoo_]

If you have a custom list, you need to apply A->Z sorting order on the data to tell Excel to use the custom list for sort order (For ex. this works for Jan, feb, mar... dec sorting).

[@mahathmasadineni2884]

@@chandoo_ Super Sir, But nenu slicers ni change chesaka malli normal order ki velthundi daniki em cheyali ala avakundha vundali antey.

[@mahathmasadineni2884]

Why don't you make a video on that

[@venumadhavlikes5759]

Hovering mouse while explaining is distracting from learning... Our focus is being diverted to the movement of the mouse. Just a feedback but not a comment...

[@chandoo_]

Thanks Venu... This video is before I learned about that.