PivotTables are one of my favorite data analysis tools in Excel. With PivotTables you can find sums (also average, minimum, maximum, etc…) much easier than with Subtotals. This screencast shows how to create and modify PivotTables in Excel.
File for self-learning: sales.xls
See also:
This entry was posted on Monday, October 9th, 2006 at 10:43 am and is filed under Screencast, Excel, 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.
Name (required)
Mail (will not be published) (required)
Website
