Excel How to Use Subtotals

Excel is packed with lots of great tools. One of my favourites is the Subtotals. Here you can take a list, sort it into order so that appropriate items are grouped together, then click a button and it will determine the subtotal for each of those groups.

Not only will it create subtotals, it will do averages, max and min to find the highest and lowest values.

Check out the video tutorial below to see it in action. For more tutorials see my website www.jargonfreehelp.com.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel and tagged , , , , . Bookmark the permalink.

One Response to Excel How to Use Subtotals

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s