What are the functions of a pivot table in Excel?

Answer 1

Basically, it's a way to summarize data from elsewhere in the spreadsheet. For example, if you had expenditures of family members in various categories, a pivot table could take all those details and show just how much each family member spent of each category as well as total expenditures for each member and each category.