Pivot tables are the single most powerful tool in Excel for a Finance Team. Simply, they take any size dataset and summarise it dynamically by any piece of information in the underlying dataset. They are quick to create, easy to amend, and simple to add to or refresh. Whatever job you perform in a Finance Team, pivot tables will save you time.