Learn how to use Excel's PivotTable feature to generate meaningful reports that summarize data.

How to combine Excel VLOOKUP() and PivotTable for simple solutions Your email has been sent Combining features often extends the flexibility and efficiency of your solution. Many solutions require ...

A PivotTable is an Excel tool for summarizing a list into a simple format. You create PivotTables from lists, as you define which fields should be arranged in columns, which fields should become ...

Use Excel PivotTables to quickly analyze grades Want to quickly sort the data in your Excel gradebook by category, such as section number or teaching assistant’s name? PivotTables let you view this ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Creating Running Totals in Regular Ranges To create a running total in an Excel range that isn't formatted as an Excel table, you need to use a combination of absolute and relative references.