Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

How to use top/bottom rules Highlight cells rules are good when you have a specific value in mind, such as numbers greater than 100, cells containing specific words, and so on.