![]() ![]() Though you can filter data in this table, we’re about to see how PivotTable can make things much more efficient. ![]() What is a pivot table? A pivot table can help quickly summarize the data and highlight the desired information. We will click on the pivot table, select the Analyze tab in the Pivot Table Tools, and click Insert Timeline Figure 7- Insert Timeline. Now we can view sales totals by Sales Person and it only took a few mouse clicks. Any changes you make to the data set are not automatically picked up by the pivot table. ![]() Once there, find the ‘Tables’ group and click ‘PivotTable’. Let’s do something simple like drag ‘Sales Person’ from the fields list and drop it into the ‘ROWS’ area. How to find a pivot table in excel PivotTable. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |