« Screencast: Excel: Data Filtering
Screencast: Excel: Using PivotTable »

Screencast: Excel: Subtotals

This screencast is about using Subtotals in Excel. It’s recommended, that you know how to sort data in Excel, but it is not necessary to understand Subtotals. Subtotals are used to find a sum (count, average, maximum, minimum, etc…) of values for some group of data. We start with simple subtotal exercise and go on with multiple subtotals in one table. Subtotals also provide good data viewing opportunity by showing/hiding some group of data.

File for self-learning: sales.xls

del.icio.us:Screencast: Excel: Subtotals digg:Screencast: Excel: Subtotals simpy:Screencast: Excel: Subtotals newsvine:Screencast: Excel: Subtotals furl:Screencast: Excel: Subtotals reddit:Screencast: Excel: Subtotals blogmarks:Screencast: Excel: Subtotals Y!:Screencast: Excel: Subtotals

This entry was posted on Friday, September 29th, 2006 at 3:20 pm and is filed under Screencast, Excel, Learning, Database, Data analysis. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Screencast: Excel: Subtotals”

  1. LearningNerd Says:
    October 7th, 2006 at 3:08 am

    Thanks for sharing these screencasts! I’m bookmarking your blog for future reference. :) Expect a link or two from me one day, since I’m also keeping an educational blog. (I’m planning to learn everything there is to know, so you can be sure that one day I’ll get around to learning more about Excel!)

  2. Learning by Screencast » Blog Archive » Screencast: Excel: Using PivotTable Says:
    October 9th, 2006 at 10:43 am

    […] Learning by Screencast Learning - it’s easy « Screencast: Excel: Subtotals […]

  3. Learning by Screencast Says:
    October 9th, 2006 at 11:19 am

    Thank You for bookmarking my site. I hope that these screencasts are useful for someone like you. You have very good self-learning blog. Keep on going!

Leave a Reply