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.
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.
This screencast shows how to use one of the data filtering methods in Excel: AutoFilter. With AutoFilter you can add multiple conditions to multiple columns to filter data.
This screencast shows how to sort data in Excel.
Learning by Screencast offers you free screencasts for self-learning. A screencast is a digital recording of computer screen output, often containing audio narration. In other words: when you are watching screencast, then you have virtual teacher, who shows and explains how to use some kind of software or make some kind of screen activity.
