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...

Accountants who specialize in forensic and valuation services point to electronic data analysis, or big data, as the most pressing issue they’ll face in the coming months, according to results of a new survey released...
As complex as federal tax can get, at least you're only dealing with one agency: the IRS. But when you get into state and local sales tax, you're coordinating hundreds of jurisdictions that are constantly changing....
All that was needed on Tuesday was a voice vote for the House of Representatives to pass a bill that would prevent state and local governments from taxing access to the Internet.Now the ball is in the Senate’s court....

Upcoming CPE Webinars

Jul 24
In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.
Jul 31
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Aug 5
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.