If you can feel the rumbling of the stadium, the weight of the shoulder pads and can honestly say you’re “ready for some football,” don’t put on those Friday night lights without a little prep work first. Use Microsoft Excel to create a football league table so you can keep score, make updates and adjustments and follow along like a true fan. Enjoy customization options to truly bleed blue and yellow -- or your preferred team’s colors -- and score a winning touchdown with Excel.
Drag the row divider of a new workbook between rows 1 and 2 down to give your row a wider appearance than the others on the grid. Type the name of the league or your preferred table title. Highlight and format the text with the Font portion of the home tab, including boldfacing the title, changing its colors and making it a strong font.
Click into the row below and type the first column header, such as “Jersey Number.” Press the “Tab” key and type your next column header, “Team Name” or “City.” Continue to press “Tab” to move one cell to the right and enter in as many column headers as you want to track. Highlight all of the cells you just typed and format them as desired, such as making them boldfaced or filling the row with a background color to separate it from the rest of the grid.
Click the “Insert” tab, then click the “Pictures” button. Browse to where you have imagery associated with the league stored on your computer, such as league logos or team photos, and double-click an image to add it to the grid. You can also click the “Online Pictures” button and browse for general football clip art such as pigskins and kickers.
Experiment with Excel’s math and macro features to put some kick into your league sheet. Highlight all of the cells in a row or column, then click the “AutoSum” button on the Home tab’s ribbon. The button looks like a sigma character and adds the cell contents, which can automatically calculate stats such as kicker points, downs recovered and fouls. Click the “Formulas” tab to access the AutoSum button as well as different macros and calculations.
Create a player foul sheet out of your data by highlighting the cells with the players’ names or numbers, as well as the corresponding data for each. Click the “Insert” tab, then click one of the options in the Charts section of the ribbon, such as a pie chart or bar graph. Excel auto-formats a generic type of graph for you. Click the chart to open the Chart Tools tab, where you can change colors, resize the chart, add chart labels and more. This type of chart depends on the data in your league table and what you’re keeping track of. Consider inputting league data for items such as players’ success at free kicks, roughing fakes or incomplete passes, then running the chart feature to add graphics to the table.
Draw your own version of a starting layout by clicking the “Shapes” button on the Illustrations section of the Insert tab’s ribbon. Use the rectangle shape to draw a large rectangle and click the “Shape Fill” option on the ribbon to fill the rectangle with black, to resemble the chalkboard often used in player locker rooms. Choose the circle shape from the Shapes menu and draw small circles to resemble players. Change the circle to have “No Fill” on the “Shape Fill” menu and white on the “Shape Outline” menu. Click the line shape and draw lines between the circles, showing the path of movement for the play. Change the line color to white as well.
Tips & Warnings
- Show your team spirit by coloring your league table your team’s colors. Use options on the “Page Layout” tab to add in colors and designs. Clicking the “Background” button launches the Pictures window, where you can add a team logo or roster photo to the grid’s background. Highlight all of the cells by clicking the “All Cells” button between row 1 and column A, right-click and select “Format Cells.” Click the “Fill” tab and select one of your team’s colors from the color menu. You can also highlight several cells, rows or columns by holding down the “Ctrl” key and using the Fill feature the same way, to give the spreadsheet a multi-color look.
- These instructions are written for Microsoft Excel 2013 users. Earlier or later versions of the software may behave differently.
- Photo Credit Mike Watson Images/moodboard/Getty Images