Pivot tables is a very powerful function in excel that enables you to group and report data with certain characteristics that are the same. It automatically sorts the data together, and allows you to pick and choose which type of data you would like to display. Helpful if you have many columns of data.

We are currently updating this excel guide.