25. Creating Pivot Tables and Slicers
Pivot tables can summarize one million rows with five clicks of the mouse button. For example, if you have sales data broken up by company and product then you can quickly summarize the sales by company then product or, with a few clicks, reverse the report and summarize by product then company. Or if you’re in charge of all the local kids’ soccer leagues then you can create a report showing the number of boys versus girls, grouped by age. A pivot table can do all this and more. Another option is a slicer, which allows you to filter a pivot table, but in a much more user-friendly way.
Pivot tables are so powerful ...