In this class you will learn how to create a football league table in Excel. We will use the power of Excel to automatically calculate league table rankings as results are entered.
Whether your league table rankings are determined by goal difference, goals scored, number of away wins or something else. You will learn how you can use this criteria to automatically determine a team or players league position.
The spreadsheets used are available for download along the way for practice, or to use as a template to adapt to your needs.
In this class we focus on creating a league table for football/soccer. However these techniques can be used for any sports or business example when league tables and rankings are used.
For the class project you can create a league table for whatever scenario you wish.
Let’s get started.