Before we startįor this exercise, you can use the file excel2007-2010-exercises.xlsx on the demonstrations files web page. The next part of this page is to create a PivotTable. This page is dedicated to show you how to use this tool with all it's options. This allows you to "dig" deeper into the data and maybe finds somethings you didn't expect. You can add/change/remove fields from one area to another and PivotTable will recalculate itself to show you the new results. ![]() You can compare the results from one field to another. That's why Microsoft placed it as the first option under the Insert tab in Excel. But it has been underused in previous versions of Excel. ![]() Rename a field and change it's propertiesĪ PivotTable is a powerful tool to easily generate summary reports from a massive amounts of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |