How to Collate Sports Fixtures Results into a League Table in Excel (2/6)

Published by : Tiger Spreadsheet Solutions
How can you collate sports fixtures or results into a league table in Excel?

Download file link:
goo.gl/4wBpl0

Video 1 - INTRODUCTION
https://youtu.be/AokM8LW_yW8

Video 2 - convert scores to a result using if
https://youtu.be/UkCyukcyIDg

Video 3 - collate wins and losses using countif 1
https://youtu.be/a7M7udI_boQ

Video 4 - collate wins and losses using countif 2
https://youtu.be/2D5cy560kMc

Video 5 - use sumif to find goal difference
https://youtu.be/Il2d6xaa1Qc

Video 6 - use match and offset to create the league table
https://youtu.be/NlyWNoJof8s


Sport enthusiasts might wish to create a league table from a set of results in Excel, but it can be difficult to know how to start. Without good pivot table or VBA programming skills, it is a complex task that cannot be completed in one fell swoop. It necessitates some clear, logical thinking about the required steps, and the creation of a well-structured Excel file.

This invites us to reflect on what a well-structured Excel file looks like. We propose a structure comprising three elements - a backend, calculations and frontend - and apply it in the video series. This is a good general structure to apply to your next Excel-based task!

Along the way, we apply Excel formulae that are essential in spreadsheet modelling including if, sumif, offset, match and vlookup.

As a starting point, Chris takes the results data from the 2015-16 Premier League season and works through the steps towards a league table. In the final video in the series, Chris tests the model created against the actual Premier League table. Will it be accurate?

For regular spreadsheet hints and tips and more on the #ExcelRevolution:
https://www.facebook.com/TigerSpreadsheetSolutions
https://twitter.com/TigSpreadsheets
http://tigerspreadsheetsolutions.co.uk
external link sitemap

publishedAt channelId title description thumbnails channelTitle tags categoryId liveBroadcastContent localized defaultAudioLanguage