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 ...

Where conditional formatting is concerned, this is often the case. In this Excel tutorial, I’ll show you how to apply conditional formatting to a filtered PivotTable in Excel.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.