How to use Pivot Table in Microsoft Excel
In this video, I'm going to show you how to create and use Pivot tables in Microsoft Excel. The pivot table is one of Microsoft Excel's most powerful and intimidating functionality.
Powerful because it can help you to do some pretty amazing analysis. Intimidating because traditionally, pivot tables always had the reputation of being complicated.But the good news is: Learning how to create and use pivot tables in Excel is much easier than you might have been led to believe!
We will use some dummy data and analyse using Pivot Tables to answer queries like:
1. How many employees are there in each Department by Gender?
2. How much salary are we paying in each Department?
3. Which Department has the highest salary payments?
4. What is the average Basic Salary of each Department?
5. What percentage is the Total Salary of the Grand Total?