Create an Automatic Football League Table in Excel

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Lessons (54m)
    • 1. Introduction

      2:33
    • 2. Setting up the Tables

      8:57
    • 3. Calculate Games Played, Won and Lost

      10:53
    • 4. Calculate Games Drawn, Goals For and Goals Against

      7:38
    • 5. Calculate Points Earned and Goal Difference

      3:16
    • 6. Rank Teams by Points

      2:47
    • 7. Uniquely Rank Teams

      4:45
    • 8. Rank Teams by Goal Difference then Goals Scored

      7:45
    • 9. Populating the League Table

      3:30
    • 10. What to do Next

      2:15

About This Class

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.