You shouldn't underestimate pivot tables in Excel. That's because Excel's PivotTables will deliver everything you'll need for data analysis. From condensing rows of data to deriving sums and grouping similar columns, there is a bit of everything in pivot tables.