Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.