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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!