Recommended PivotTables

Excel 2013 and above has the ability to analyze the data, and recommend the most suitable pivot tables for it.

To use this feature, locate the cursor in a cell in your data table, and under the “INSERT” tab, clickRecommended PivotTables

Excel will suggest a list of pivot tables:

pivot table

Select the one that suits your needs.

Do you think it was helpful? Share it with your friends