-
GUI function (Insert -> Pivot table)
-
Select range of the table (in the table / range option)
-
Table will not be generated immediately. You have to specify the row / column / values.
-
Specify values in empty areas.
-
And the remainding is quite straightforward.
-
Mainly drag and drop.
-
Set role, column, and excel will do the rest.
-
Filters: You can choose to hide unwanted data.
- Scenario manager will help in these cases.
- e.g. Set different sets of data
- Will ask to input different Scenarios.
- Summary will be generated.
- Goal seek is also included in what-if analysis.