Create an Automatic Football League Table in Excel Premium class

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

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

    • Setting up the Tables

    • Calculate Games Played, Won and Lost

    • Calculate Games Drawn, Goals For and Goals Against

    • Calculate Points Earned and Goal Difference

    • Rank Teams by Points

    • Uniquely Rank Teams

    • Rank Teams by Goal Difference then Goals Scored

    • Populating the League Table

    • What to do Next


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.





Alan Murray

IT Trainer, Coffee Lover and Lifelong learner

Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 17 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.

I set up Computergaga about 8 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.

I have a real passion for Excel and I hope that it comes across in my classes. I believe that it helps if you enjoy what you are learning.

I currently live in Ipswich, on the east coast of England. I am married with two beautiful children. So they take up most of my time away from Excel. If I'm not with my family or Excel, I can probably be found running.

View the latest FREE Excel Tips >>

Speak to you soon. Have fun learning.