I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

To delete an Excel pivot table, select all the cells in the table and press Delete on your keyboard. A pivot table is a helpful Excel tool to view your data, but you might not need to keep it around ...