Pivot tables have long been the standard tool for summarizing and analyzing data in Excel, and they work well for many tasks.