Subtotal Command in Excel - automatically calculate subtotals and grand totals

[@harikc872]

Your Explanation is in a Lucid Way ................Cheers Chris Menard.....😊👍

[@ChrisMenardTraining]

Thanks 👍

[@agroasesor1]

Gracias mil !!!!
So.... Here is another option for Pivot Tables !!!!
Basic, clear and concrete explanation so, very good 6 minutes investment !!!!!

[@ChrisMenardTraining]

Thank you.

[@balajisrikaanthp]

thank you Chris. Your video was Wonderful

[@ChrisMenardTraining]

Glad you enjoyed it!

[@explorermusings6916]

Thanks sir for explaining in a neat way.

[@ChrisMenardTraining]

Glad to help. Thank you!

[@rach4724]

This was very helpful.

[@JoshCaiLovzu]

This is quality content. Subbed!

[@ChrisMenardTraining]

Welcome aboard!

[@tommyharris5817]

Brilliant!

[@ChrisMenardTraining]

Thank you.

[@johnjoseph7127]

Very nice.

[@CandiceNance]

I love your videos, but it would help if you captioned them (not autocaptioning!). I'd like to use these in my classes but we are required to use captioned videos.

[@ChrisMenardTraining]

Candice, can you give me a little more detail? They have captions that are correct. We use Descript to get accurate captions. drive.google.com/file/d/1tElyT9A-rWw7MlA94CCPf5rrv2F-C9AG/view?usp=drivesdk

[@richardhay645]

What is the keyboard shortcut for the subtotal feature ,NOT Autosun but the dialog box you illustrated in this video)

[@ChrisMenardTraining]

Hello, Richard. I looked and I did not see a shortcut key for the the Subtotal feature.

[@richardhay645]

There should be! I tried to figure it out before posting my comment. I usually keep the ribbon hidden and rely heavily on shortcuts. Maybe I will post a comment on the Insider blog. Thanks for checking.. Great video.

[@richardhay645]

@@ChrisMenardTraining figured it out: ALT,D,B opens the Subtotal Dialog Box.

[@harikc872]

@@richardhay645 Life made Simple 😊

[@hoit1753]

Please include exercise files for viewers to practice. Thanks.

[@MiguelMedV]

Umm... Just make some of your own, it's not hard...