A pivot table is a powerful tool in Excel to summarize ... Format your data as an Excel table (more on that later). Essential Microsoft Excel functions to streamline your everyday tasks Now ...