Recommended Pivot Tables in Excel
If you are wondering how it is possible to automatically generate pivot tables in excel then in this tutorial I am going to tell you everything about this with step by step. There is an option of Recommended Pivot Tables in Excel which can be used for this purpose. This feature is newly introduced in Excel 2013.
Herewith very simple steps I will show how you can do this:
STEP1. Firstly select your data and;
Go to Insert > Tables > Recommended Pivot Tables
STEP2. Now you have generated your Pivot Table recommendations so, now select the sum of cash by gender and then click OK.
STEP3. Now you have a sheet of generated Pivot Table so make some changes in it. Select Value Field Settings by clicking first name option.
As you can see, You can drop down to see the list of females and males.
You can also add other options like ;
- Last name
- Email Address
- IP Adress
If you have selected all above, your pivot table will look like;