PIVOT TABLE is a well known feature of EXCEL which everybody of us might have heard of. But many times we don’t know how to effectively use the PIVOT TABLE.
PIVOT TABLE is a dynamic table which we can create in Excel. We called it dynamic as we can transform it within seconds. The original data remains the same.
We know that whatever is hinged to a pivot, can rotate here and there, so is the name given to these tables.
PIVOT Table is a very powerful tool to summarize, analyze explore the data in very simple steps. Its very important to learn the use of pivot tables in excel if we want to master excel. Pivot tables give us the facility to put different simple operations on a selected data in seconds.
We have already learnt about creating PIVOT TABLES HERE.
In this article we will focus upon the frequent difficulties which users face while using the pivot tables.