Create an Automatic Football League Table in Excel | Alan Murray | Skillshare

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 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.





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


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.

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 ...

See full profile

Report class