How to Create a Football League Table on Excel
Football league tables are an easy way to keep track of player and team performance during a season of football games.
The tables offer specific data areas for many parameters, including individual player points, the type of activities achieved (such as passes or touchdowns), the number of home games and away games and other game details. Microsoft Excel is aptly suited to tracking this information. The program is designed in a spreadsheet grid that easily formats data into columns and rows. It is possible to have a football league table up and running in Excel in a matter of minutes.
Identify a football league table that suits your purpose from any online source that provides Excel templates. There are many, including the official Microsoft site. The style of templates widely vary. Some are designed specifically for football, while others are flexible and accommodate any sport.
Download the Excel template. Most online sources for Excel templates provide these free of charge. Optionally, you may seek a template from a source that charges for its services. These templates could offer additional features or more robust spreadsheet interfaces. However, it is advisable that you first consider free options as they often suit the most common demands.
Double-click the downloaded template to open it in Excel.
Click the "File" menu in Excel and choose the "Save As" command. A pop-up window will appear. Choose any name for the template. Consider naming the template with the year and team(s) that it contains. Press "Save" when done. By creating this second file, you ensure that your original Excel download remains empty so you may use the template again in another season.
Type the names of the players and teams into the template where specified. As the season unfolds, track player and team performance by entering numerical data that corresponds to the template's layout. Always save the Excel file after any updates.
- Some templates will provide multiple tabs. These are located at the bottom of the Excel window. They may not be apparent at first, but multiple spreadsheets are often included in downloaded templates to provide layouts for many scenarios. Click any tab to activate it and use its spreadsheet.