An overlooked feature is the ability to (automatically) have Excel create a number of new sheets with Pivot Tables in them, named with the selection chosen and the filter switched onto that selection. This lesson shows how you can automatically duplicate your Pivot Tables with different selections.
To see the full course contents click here.