Master Excel to create dynamic spreadsheets for league tables and sports tournaments, including auto-calculations and ranking criteria.
This course teaches you how to create and automate sports league tables and tournament brackets in Excel. It shows you how to use different criteria for rankings and includes fun examples like soccer, rugby, and cricket. Let’s dive into data and have some fun!
Learn how to set up spreadsheets to calculate league table rankings and other sports competitions in Excel.
This course shows you how to create spreadsheets for sports tournaments and league tables. Use the power of Excel to automatically calculate cup draws and league table rankings.
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.
Spreadsheets are available for download along the way for practice, or to use as a template to adapt to your needs.Â
The course is broken down into three sections.Â
Creating League TablesÂ
Learn how to automatically calculate league table rankings when results are entered onto a spreadsheet. We look at adapting the league table to apply different ranking criterion. A football/soccer and a rugby union example are used for demonstration.Â
Create Cup TournamentsÂ
Learn to create cup tournaments in Excel including random cup draws and calculating match results to automatically move a player or team to the next rounds draw. A snooker and a tennis example are used for demonstration.Â
Cricket World Twenty20 TournamentÂ
A section is dedicated to learning how to calculate cricket statistics and match results due to the unique nature of the sport. The World Twenty20 tournament is used to demonstrate how to calculate match results and statistics like net run rate, bowling strike rate and total balls bowled.
Let's Do ItÂ
Although the course cannot possibly cover all sports examples, the techniques learned can be adapted for any sports competition. Let's get started.Â
To automatically calculate sports league table ranking using different ranking criteria
To calculate random draws for a knockout cup competition
To calculate statistics for a cricket tournament such as Net Run Rate, total overs or balls bowled and bowling strike rate.
2 Lectures
3 Lectures
10 Lectures
8 Lectures
7 Lectures
Alan Murray is a Microsoft MVP and an Excel & Power BI trainer. He has been training for over 20 years for businesses around the world.He is the founder of the Computergaga blog and YouTube channel. It has over 650 videos and more than 45 million views. He regularly shares new Excel tips and tutorials.He is the author of the...
Very practical skills I have learnt that here!
Just what i needed. Everything really well explained.
Thank you
For me it is a very good course.I posting scores online before it is announced officially and this models are very helpfull.
Although I am a Mechanical Engineer, I am just a beginner in Excel. I am currently pursuing my master's in Sports Management and hence, I would very much like to hone this skill and learn how to make spreadsheets concerning my work.
Well documented, easy to follow, recommended for anyone wanting to create a soccer league table in excel
Thank you Alan for putting out an excellent course! As a Sports Management student on the lookout for any kind of job opportunities in the industry, this course has definitely enriched my knowledge base in order to give me an edge.
The course delivery and the examples used were excellent as well as easy to understand.
This course has shown me how to create my own league tables and random cup draws for the different tabletop sports games that I play. I have also learnt some new functions in excel that I had never even considered before.
Great. It was I needed.
Very well presented so far.
Your email address will not be published. Required fields are marked *
Makan
At first i was confused with using the ranges of names in Excel but after a while my table league was finished.
My Ranking system was on Points and Goal Differences and Goals For and Goals Against.
Alan explained League table very good.
Thank you for very good league table course.