Welcome to Excel Heatmap Analysis For Football Traders!  The course will teach you how to create heatmap type analyses for football data.  These are commonly associated with odds brackets, but you can analyse many different types of data with heatmap analyses, as we will see.  So, let's get started!

The bad news is that we cannot simply click our fingers and produce a heatmap analysis.  A set of foundational skills, techniques and knowledge is necessary.  The good news is Chris takes you through this learning, step-by-step, in this series.  Make sure you download the Excel files and work along with Chris.

In the first session, we explore how to undertake a basic data analysis of continuous numerical data.  Simply put, how do we understand a set of numbers?  It's an absolutely fundamental skill for any data analyst.  We start with basics then build to more sophisticated techniques.  Watch out for the powerful FREQUENCY formula which facilitates a cool visualisation of the data - it's one of Chris' Excel secret weapons!

Tools And Techniques

- COUNTA
- MAX / MIN
- AVERAGE / MEDIAN
- STDEV
- FREQUENCY
- COLUMN CHART