Now you've had an introduction to Excel's fitering and sorting capability. The next thing you might want to do is to summarize your data. You might want to see subtotals by company or by month. However, we are going to skip showing more worksheet features, because it is finally time to jump into Excel's most powerful tool, the PivotTable. The PivotTable allows you to summarize and analyze your data in just about any way you can think of.

The PivotTable feature is covered in the next tutorial in this series.

If you would like to download the sample xl file with all changes up to this point, it is here.