While working with data divided in categories, finding sum is often not straightforward. If data is not ready to accept subtotals, it will be even more difficult to insert subtotals for each category in Excel.

In this Excel video tutorial we are learning how to insert Subtotals for each category quickly using Excel Go To Special tool and Auto Sum shortcut.

This video is loaded with shortcuts to add subtotals, sum category values and format data in Excel!

Lets Excel!

For more Excel tips, tricks and tutorials don't forget to subscribe to @Learn Excel to excel YT channel.

Learn #Excel your way:
===================
Website: [ Ссылка ]
--------------------------------------

Pick your favourite social page:

Fb: [ Ссылка ]
Tiktok: [ Ссылка ]
Tw: [ Ссылка ]
Pin: [ Ссылка ]
Yt: [ Ссылка ]
Insta: [ Ссылка ]

Music by: [ Ссылка ]

#excelsubtotal #excelgotospecial #exceltutorial #exceltips

свернуть