Trick to Insert Subtotals in Excel FAST for each Category with Go To Special Tool Auto SUM easy way

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!

Like and Subscribe to My Channel and Share videos with your friends for learning.

insert subtotal excel, insert subtotals using sum function for each category, insert subtotals for each category go to special, how to insert subtotals using sum function excel, prepare data for subtotals excel, insert subtotals to data excel, find subtotal for each category excel, insert subtotals excel, excel trick to insert subtotals, insert subtotal without subtotal feature, subtotal not available, subtotal feature greyed out, subtotal not working workaround, fix subtotal

#4Atechtravel
#ytshorts
#shorts
#shortvideo
#shortsvideo
#yt
#ytshortsindia
#shortsyoutube
#exceltutorial
#excel
#exceltips
#subtotal
@4ATechTravel
@alloverfashion700
@Factors_Mentor