Skip main navigation

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?

Introducing GETPIVOTDATA

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 …