Pivot tables are a report that has existed in Excel for a very long time, and it allows us to look at a source dataset from different angles, as well as to easily change views on the data. Despite the fact that this is a very useful report, many people still do not know how to use pivot tables. That’s why Microsoft recently added an option in Excel by which, based on the selected data, it can recommend you what kind of pivot table to create.
We will start from a table that stores data on sales transactions in a certain period. Select a range or a data table, then go to the Insert ribbon and select the Recommended Pivot Tables option.
A window will appear where you can see several available ways to create a pivot table suggested by Excel. Select one of them, click OK and you will add the pivot table. Voila!
Within the window, there is also an option to add an empty pivot table, as well as to change the data range. This way you can easily add pivot tables and, with a little modification, create useful reports.