How to Create a Summary Table in Excel | Using Excel Formula or PivotTable

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍

In this Microsoft Excel video tutorial I explain how to create a summary table. I explore two methods. The first method uses the following functions: SORT, UNIQUE, SUMIF and COUNTIF. The second method uses a PivotTable. Which is the best method to use?

00:00 Introduction
00:37 House your data in a table
01:13 Formula method
04:26 PivotTable

#exceltutorial #exceltips

[IvanCortinas_ES]

Excellent both methods. Thank you Chester!!!

[carolhollett]

At the risk of being really inappropriate, I think I love you. You have just solved my reporting problem for a project I'm working on. Thank you so much.

[zakirmankorota]

Thank you to your important explanation about Excel using method!!!

[Jojosmith]

thumbs up as always to the very useful tutorial. Thanks a lot Chester

[Fullstack_LP]

My patience was running thin after half an hour of repeated AI hallucinations. This tutorial was exactly what I was looking for. Thank you

[MervinRamos]

On pivot we can filter the dates easily. Can we also filter it by dates using that unique methods?

[johnboffin]

Hello Sir, Question, how to create a table in Excel 2000? Table for list of items in One column for drop down menu, All I have is Excel 2000, and people on YouTube teaching about 360. will be appreciated if you could help me on this.

[mohanmadhava]

Hi sir, how to get a summary from 30 to 40 sheets, pls explain

[mohanmadhava]

I have an excel sheet with 30 to 40 sheets then am copy & paste in summary tab sir, pls help