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

Project Description

For your class project, please create a league table in Excel to share.

You can create a league table for whatever you want (football, rugby, hockey, bowls). It does not necessarily need to be for sports. It could be for computer gaming with your friends, or business like ranking call centre staff or a sales team performances.

Student Projects