MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Creating Sports League Tables and Tournaments in Excel

Course Summary

Learn how to set up spreadsheets to calculate league table rankings and other sports competitions in Excel.

  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Create a Sports League Table (Football/Soccer Example)
      • Setting up the Tables
      • Calculating Games Played, Won and Lost
      • Calculating Games Drawn, Goals For and Goals Against
      • Calculating Points Earned and Goal Difference
      • Rank Teams by Points
      • Uniquely Rank Teams that are Tied
      • Rank Teams by Points, then Goal Difference and Goals Scored
      • Including a Points Deduction
      • Creating the League Table
      • Extra League Table Example (Aviva Premiership - Rugby Union)
    • Create a Sports Knockout Tournament (Snooker Championships Example)
      • Setting up the Spreadsheet
      • Randomise the Cup Draw
      • Assign a Number to each Player or Team
      • Populate the Cup Draw Sheet with Player or Team Names
      • Simulate the Cup Draw
      • Calculate Tournament Results
      • Clear Tournament Data
      • Extra Knockout Tournament Example (Tennis Grand Slam)
    • Create a Cricket Tournament Spreadsheet (World Twenty20 Example)
      • Overview of the Spreadsheet Setup
      • Calculate Net Run Rate (NRR) 1
      • Calculate Net Run Rate (NRR) 2
      • Calculate Net Run Rate (NRR) 3
      • Calculate Net Run Rate (NRR) 4
      • Calculate Bowling Strike Rate (SR) 1
      • Calculate Bowling Strike Rate (SR) 2

Course Fee:
USD 39

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Operating Systems Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top