Aside from giving you the freedom to update the data in the Pivot Table, you can also organize the data in a very organized manner.
But, before anything else you must input first the data in Microsoft Excel.
Tip: change your data set to a table before you insert a pivot table.
On the Analyze tab, in the Data group, click Change Data Source.
In the list of data source options choose "Microsoft Excel list of database". 1) put a dummy column "X" off to the right of your source pivot table. 3) once the dialogue box pops up you can edit the data range to include your pivot table.
Most pivot tables are based on source data that continues to change; new records or fields may be added to the source data, existing records are modified, or the source data file is moved to a new location.
You want to ensure that your pivot table contains the latest available data and is correctly connected to the source data.
If you change any of the text or numbers in your data set, you need to refresh the pivot table.
If you change the size of your data set by adding or deleting rows/columns, you need to update the source data for the pivot table. This way your data source will be updated automatically when you add or delete rows/columns.