Menu
The formulas we created in Pivots 02 and Pivots 03 are needed for all the records.
To prepare for that, we will convert our data listing to an actual Excel Table and name it. This makes life much easier, as any new raw data added will automatically be linked also to our user defined formulas.
Having defined extra information via formulas and Lookups to our first line of data, we now need that copied to cover over 7,000 lines of weather data. This can be done with one click, thanks to the Excel Table.
Once this is done, our complete data list is ready and we define our first Pivot table using all that data as our “input”.
The video shows you how. We create our Pivot table and filter the table so it shows us only what we need to answer our original question:
“Does it rain more on Sundays than on Mondays, during the day?”.
