Wednesday, June 29, 2022

Track NCAA Division I men's basketball championships with Excel [MS]

"…for those who have just joined us, I'm calling this incredible game, high above courtside. The ball is in play with 7 seconds to go on the game clock. The point guard drives hard to the top of the key — spins away from one defender — gets smacked by another! He throws up an off-balance, desperation shot… It's good! The crowd is going bonkers!!"

Before you and the announcer keel over from excitement, you may start wondering, "How can I keep track of 64 teams and all this basketball tournament madness?"

Use Excel to track your picks

We've made it easy for you to track the progress of your favorite college men's basketball teams with the Excel bracket template for the Men's Division I championship (last updated on Monday, March 18, 2019).

You can download the college basketball template, or go to File > New, and search for it.

The template is made up of several worksheets:

  • Instructions - This gives you a brief overview of what to do.

  • User Input - Here you'll enter your tournament preferences.

  • Brackets - This sheet shows team assignments as announced by the NCAA.

  • NCAA Rankings - This sheet shows the latest NCAA team statistics.

  • Scoring Offense/Defense/Won-Lost % - These NCAA statistics can help inform your team selections.

Throw a party

If you're planning an event for your fellow basketball fans, we've created a custom party invitation in Microsoft Word to help you celebrate the madness. You can download the basketball party template, or in Word, go to File > New, and search for basketball.

No comments:

Post a Comment

Search This Blog

Work with note containers [MS]

Work with note containers OneNote for Microsoft 365 OneNote 2021 OneN...