Friday, August 19, 2011

How To...Use Subtotals for Data Analysis in Excel 2010

I have a new video to YouTube - this one is about creating subtotals in Excel 2010. This is a handy function that takes some of the work out of analysing data, and reduces the risk of error. It is based on a spreadsheet containing sales figures by region, and shows how to get subtotals of units sold and revenue for each of four regions. This is done without writing formulas or copying and pasting data. This is a straight-forward exercise, but I've never used the subtotal function before (and only learned how do use it myself just before I created the video). I hope to use more exercises like this in class tutorials to help students analyse data, so that they have a method with which to summarise data for presentations and reports.

No comments:

Post a Comment