Pivot tables are a powerful tool within Excel that can be used to analyze, sort, filter and present  data in an understandable way.