How to make pivot tables from large datasets - 5 Techniques

[@excelworx8712]

the 5th way was just brilliant!

[@chamilaranchigoda]

This was amazing! I specially liked the 4th and the 5th

[@shreyalingwat2654]

Hi If I want to create 1 pivot table using 5 sheet but data is too large how to create pivot table pls suggest

[@adityachachad8103]

You have not shown the function i.e How to add Pivot with Slicer

[@wayneedmondson1065]

Hi Chandoo.. thanks for this great video.. super useful tips and tricks for handling large data sets with Pivot Tables. Thanks also for providing the sample workbook. I learned a lot by following along and re-creating your examples including some shortcuts you used that I did not know about previously.. much appreciated. Thumbs up!

[@moutazeldeib9481]

Thanks a lot my teacher

[@rajivramki]

Hi Chandoo, Thank you for this great video. I have got all the Pivots except the 2nd Pivot - Collapsed details. Can you please help me out on how to do that. It will be really helpful for me.

[@AkaExcel]

MashaAllah! Beautifull!

[@sandeepkothari5000]

Dear Chandoo, Marvelous video. Please provide correct link to download the sample workbook

[@chandoo_]

Please check again Sandeep. It is working now. The link is at chandoo.org/wp/pivot-tables-from-large-data-sets/

[@Q8Patriot]

Great ideas , thanks alot

[@chandoo_]

You are so welcome!

[@bidhyadahal3899]

Hi Chandoo, thanks for the insight. How can we contact you?

[@linzhang4881]

great video!

[@kristinakanc9764]

If we have 300 customers from different cities, how to extract a beautiful list of the cities? Like how to get that they are from 20 cities (getting a list)

[@775shahrukh]

no comparision of Chandooo....

[@shaily1943]

Hello I want to know that in first pivot table how did you create the table as my data do have blank cells and I want to create a table like that I have also seen you videos but can't get the output I want please help me out.

[@shaily1943]

Or if possible can you make a video of step by step explanation for this pivot sheets?

[@shaily1943]

My data includes field like Unique Id, First, Middle, Last Name, Add 1, Add 2, State, City, zip and SSN. SSN doesn't includes actual ssn number it is displayed as Y in the field. I hope this gives you a better idea

[@chandoo_]

You may refer to the example workbook and further explanation here - chandoo.org/wp/pivot-tables-from-large-data-sets/ If you need a proper introduction to pivot tables, see this please - kzbin.info/www/bejne/l6DJpJemn9t-bdk

[@shaily1943]

@@chandoo_ Thanks for the reply and I have gone through the links and videos you shared already but was not able toh get the clear output.

[@dawn2479]

Are you a Malayali?

[@Vichitraword]

Very poor sound quqlity. Not audiable without earphone.

[@eyelook5771]

Slow down a little

[@chandoo_]

This is an advanced video. For pivot table getting started tutorial, see this - kzbin.info/www/bejne/l6DJpJemn9t-bdk You can also pause or rewind the video or reduce the playback speed. Plus there is an example file in the description. Refer to it if you need help. Happy learning.

[@bidhyadahal3899]

Please check your insta. Looking to join your online course, thanks.

[@savitripinnapati6509]

Please translate this video english to kannada and display not clearity.

[@chandoo_]

Sorry, but I am not fluent in Kannada, nor I am interested in translating the videos to all languages. May I suggest playing with downloadable files to learn or visit chandoo.org/wp/pivot-tables-from-large-data-sets/ to read text description of the tips.