Let us take one more example that is go back to our data, select the entire data go to insert pivot table there are select OK. Now, the new pivot table has been created in sheet three. This time there is analyze, how many employees have resigned from each of the programs. So, our data should have the program names on the left hand side with the number of employees that have resigned in the following column. So, for that we will select the program names as rows and employee code as summation of values because only want the count of the employees. Again, we will change the field settings to count. As you can see, there are many other options over here like average maximum minimum product, and some which was selected by default.
We can use this based on our requirement. After clicking on Ok, I can see that from ABC program, there were 20 employees who had resigned from KLM program there were two employees who are designed. In this way, we can analyze the data from different perspectives and arrive at conclusions. Also, it is a good way to represent the data using charts. There are many options in Excel that we can use To represent the data