What Happened? The Right Tool for the Task When something goes wrong, everyone wants to go through the data and find out what happened. The Data Tools are: Sort, Filter, Group and Subtotal. A PivotTable combines all of the best Data Tools together. A PivotTable presents the data in a visual, interactive format. PivotTables summarize, sort, compare and filter the data. For some reason, most people teach PivotTables as an advanced topic. In this lesson, "advanced" doesn't mean difficult: just more steps. The Computer Mama sez formulas can be difficult. This is actually fun. Try something different.