Creating the Stats Table


Tutorial Home >Software >Finance >Microsoft Excel 2000 Projects >How do I create a team statistics stats table?
Tutorial Home >Software >Office >Microsoft Excel 2000 Projects >How do I create a team statistics stats table?
Tutorial Home >Software >Finance >Microsoft Excel 2000 Projects >Track Your Team's Statistics >Creating the Stats Table
Tutorial Home >Software >Office >Microsoft Excel 2000 Projects >Track Your Team's Statistics >Creating the Stats Table

  Step 1:  Enter Game 1

Open a Report
Click inside cell B3 and enter Game 1 (or another title for the stats).
  Step 2:  Enter the First Heading

Open a Report
Click inside cell A5 and enter the first column heading for the stats. In this example, it's the Player column.
  Step 3:  Enter the Remaining Headings

Open a Report
Continue entering all the column headings for each stat you're tracking, pressing Tab to move to the next cell until you complete the row. In this example, I'm tracking At Bat (AB), Hits (H), Strike Outs (SO), Walks (W), Runners Batted In (RBI), Runs (R), and Batting Average stats. Your screen may look similar to the one shown here.
  Step 4:  Enter the First Player Name

Open a Report
Click inside cell A6 and enter the first player's name.
  Step 5:  Enter the Remaining Names

Open a Report
Continue entering all the row headings you need (such as the remaining days of the week), pressing Enter to move to the next cell until you complete the column.