Create an Automatic Football League Table in Excel
- 1x (Normal)
Setting up the Tables8:57
Calculate Games Played, Won and Lost10:53
Calculate Games Drawn, Goals For and Goals Against7:38
Calculate Points Earned and Goal Difference3:16
Rank Teams by Points2:47
Uniquely Rank Teams4:45
Rank Teams by Goal Difference then Goals Scored7:45
Populating the League Table3:30
What to do Next2: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.
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.