Choose the type of chart you would like to create.Charting present the data visually which is a much more appealing way to look at vast amount of information. You can modify or change the layout of the pivot table, after it’s been created.Ĭharts simplify the data and make it look more presentable particularly if you have to show it to clients or stakeholders. In the Tables group, click Recommended PivotTables.Select any cell in the source data table. To create a pivot table, you can use shortcut ALT + N + V + C or following these steps: Pivot tables allow you to categorize tabular data, making it easier to evaluate large datasets to locate precisely meaningful trends. All other data will be filtered, or temporarily hidden.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |