PIVOT table in MS Excel helps you summarise the data quickly so that you don't have to do manual calculations, which improves the accuracy during analysis.
In this tutorial, you will learn how to create a PIVOT Table in MS Excel?
How to apply filters in PIVOT table?
How to create a heat map in PIVOT table by using conditional formatting?
How to structurise data differently using PIVOT Table?
Watch the tutorial here. https://www.youtube.com/watch?v=I5Q7kaqxFoM