How to Create a Pivot Table in Excel A Pivot Table is used to summarize, sort, reorganize, group, count, total or average data stored in a table. My go-to when analyzing the data of our amazing surgical AP team! ENROLL Now