Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.

After you fill in the table, you can create a nice chart based on the data inside it. If you're not too accustomed to Excel, it might be even easier to do all these actions in Word.

Charts already do that, for example. But, until now, a pivot table can still require a manual click to update if changes are made… and you might not always remember to make that click, either.