Excel: The Indispensable NCAA Bracket Tool

It’s almost Selection Sunday, when it seems that everyone in the country, including President Obama, makes their picks for the Final Four. There’s no need to search the Internet for a bracket template – you’re just a few mouse clicks away from one in Microsoft Excel. Many users overlook the wide variety of templates that are readily available in Excel. Poke around a bit, and you’ll find a dizzying array of business templates, along with a cricket scorecard, football pool squares, and much more.

The NCAA bracket templates are available in any version of Excel. From the File menu (or main menu in Excel 2007) choose New, and then type NCAA in the field that says Search Office.com for Templates, as shown in Figure 1.

Figure 1: A free NCAA Final Four bracket template resides within Microsoft Excel.

The competition starts early, as you’ll find one or two different versions of the template depending upon your Excel version. I think the first one is easier on the eyes, but simply double-click on the template of your choice. Once the template opens in Excel, you’ll need to do some minor maintenance so that you can access the [Dates] fields:

  • Excel 2007 and later: Click Unprotect Spreadsheet on the Review tab.
  • Excel 2003 and earlier: Choose Tools, Protection, and then Unprotect sheet.

Figure 2: You must unlock the worksheet before you can type dates in the bracket spreadsheet.

The second worksheet within the template provides a tracker from which you can manage up to five sets of picks. If this isn’t enough for your needs, simply unprotect the Tracker worksheet, and then copy and paste additional pick/result columns as needed.

Figure 3: Microsoft’s free NCAA template makes it easy to track your picks.

Users that follow March Madness often consider their choices to be proprietary. If you need to hide your spreadsheet in a hurry, you could press Ctrl-Tab to toggle to the next open workbook. Of course, if you only have one spreadsheet open, your bracket will remain on-screen. Fortunately there are a couple of ways that you can temporarily hide this, or any other sensitive spreadsheet:

  • Excel 2007 and later: Choose View, and then Hide.
  • Excel 2003 and earlier: Choose Window, and then Hide.

It can be tough to execute these commands quickly if someone approaches your desk unexpectedly, so you may wish to create a keyboard shortcut instead:

  • Create a macro: Turn on Excel’s Macro Recorder, carry out the Hide steps for your version of Excel, and then stop recording. During the process you’ll see a spot where you can assign a keyboard shortcut.
  • Use the Quick Access Toolbar: In Excel 2007 and later, right-click on the Hide command on the View tab, and then choose Add to Quick Access Toolbar. Not only does this give you an icon you can click, it also creates a keyboard shortcut that will be revealed when you press the Alt key.

When you’re ready to unhide your workbook, choose View (or Window in Excel 2003), Unhide, and then double-click on the file name, such as NCAA Bracket.xlsx.

About the author:
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, teaches webcasts for CPE Link, and writes freelance articles on Excel for AccountingWEB, Going Concern, et.al.

You may like these other stories...

Cybersecurity is no longer the domain of an organization's IT staff. It's moved to the boardroom, and in a big way. Accountants and financial managers may have been thinking it's just the province of the tech...
You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having Print Preview grafted...
Following other recent high-profile hacking events, investigators discovered yesterday that hackers broke into the draft work paper files of several famous CPA firms. Revealing images of the scantily clad documents have been...

Already a member? log in here.

Upcoming CPE Webinars

Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 21
Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.