In order for a pivot table to work the data it receives MUST be in a certain format. It is important to understand the required data format for Pivot tables as it can be very frustrating if the Pivot Tables doesn’t recognise your data and refuses to switch on.
This lesson covers the rules that ideal data sets should adhere to when creating Pivot tables.
To see the full course contents click here.