Analyzing Categorical data with Pivot tables
In the examples we have looked at so far, we have used numerical data in our values fields. But we can also use categorical data (or text fields) The default …
Course: How to Use Pivot Tables to Analyse Data in Excel
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 …
These articles are from the online course:
How to Use Pivot Tables to Analyse Data in Excel
