Beginner PivotTable Tutorial | Analysing Rugby Statistics (Patreon)

Beginner PivotTable Tutorial | Analysing Rugby Statistics

Timestamps Intro: 00:00 - 1:00 Cleaning up raw data: 1:00 - 10:27 Creating PivotTable (Top 10 Tryscorers): 10:28 - 14:02 Creating a Filter (Top 5 Tryscorers by Team): 14:03 - 16:38 Employing a slicer to restrict data (Most Accurate Goal Kickers): 16:39 - 20:39 Longest Average Kicker: 20:40 - 24:13 Most Prolific Off-loaders (Practicing restricting data using multiple slicers): 24:14 - 29:23 Graphing using PivotTables (Tries by Team): 29:24 - 32:55 Report Filter (Report for Tries per Team) + Conditional Formatting tricks: 32:56 - 39:27 Outro: 39:28 NOTE: My screen recording was accidentally cropped, so that it excludes viewing of the Worksheet tabs. Overall, this doesn't affect the video except for the 'Report Filter' tutorial at the end. If anybody cannot follow this part of the video due to the worksheet tabs being excluded, comment down below and I will do a seperate video on the Report Filter. Data: For this video, I copy and pasted all my raw data from: https://www.foxsports.com.au/nrl/nrl-premiership/stats/players?wpa=BB44D82C3D7223D393F2AE47579FB5EA6791ABE4&editiondata=none&fromakamai=true&pt=none&device=DESKTOP