The pivot table is one of the single most powerful tools in Microsoft Excel. Learn how to use the pivot table for data analysis. Microsoft Excel's pivot tables are a powerful tool you can use to compare large datasets. You can use the pivot table as an interactive data summarization tool to automatically condense large datasets into a separate, concise table. You can use it to create an informativ