Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £35.99 £24.99. New subscribers only T&Cs apply

Find out more

The Finishing touches

Apply any finishing touches to your dashboard as required. Once you are happy with it, you can save the file. Comment below: What are your main takeaways from this video?


Using the workbook provided, set up the two pivot tables as demonstrated, and then set up the helper columns using the GETPIVOTDATA function. Make sure you can complete this step …

Changing the Value settings

When we add values to our pivot table, Excel’s default value field settings are set to SUM. However, there are often times when you need to find information other than …