Easy Pivot Table in Excel (Auto-Subtotals Feature)

.
Excel VBA/Macro Course! [On Sale]: www.teachexcel.com/vba-course...
Download the File: www.teachexcel.com/excel-tuto...
How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly perform calculations on data to see things like: how much of each item was sold, how many items were sold on a specific day, how many items in each category were sold, and much more.
The basic premise of this feature is that you can group similar items together in order to perform calculations on them and you do not need to use a PivotTable in order to do that.
This feature will allow you to quickly summarize sets of data so that you can analyze them and better understand the data.
To make the light version or small version of the PivotTable, we use the Subtotals feature in conjunction with a data sort.
Resources:
Subtotals Feature (Microsoft Link): support.microsoft.com/en-us/o...
PivotTable (Microsoft Link): support.microsoft.com/en-us/o...
#msexcel #tutorial #exceltips #freetutorial #exceltips #excel

[@lakshmichandrika7285]

Thank you for your vedio's 😊

[@shueybamin5244]

Thanks for this. Never thought to do this! This video just made my job easier 😊

[@nadermounir8228]

Thank you for this great video 📹. Nice one !

[@cougarcn]

Thank you for your vids, sir.

[@sheebanishat]

Thank you for the video. I would be grateful, if you could put conditional formatting to the subtotals so that they get highlighted in the table.
I’m a new subscriber and learned a little bit of conditional formatting through your videos 😊.