Today, I'll show you all how to analyze data using the most efficient and powerful feature of Excel that is the tables and charts. I have a data over here of employees, their gender, joining dates, resignation dates, leaving dates the service period that they had served in months and the program in which they belong to with this normal data, we can analyze it in many different ways using a pivot table. Let us see how let us first select the entire table, go to insert pivot table there are say yes because we want to create it in a new worksheet. And the range is what we had selected. When we click on Oh It takes us to sheet two and a blank pivot table.