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

As two of the accounting world's major governing bodies—the FASB and the IASB—converge, they're scrutinizing how businesses track lease expenses. Under existing accounting standards, a majority of leases...
A new survey from online accounting software provider Xero found that nearly 90 percent of small businesses are forecasting an increase in revenues next year, while 21 percent are expecting growth of more than 100 percent....
More and more businesses are adopting the cloud in order to take advantage of benefits such as greater efficiency, increased productivity and lower costs. Companies in general are flocking to the cloud for email hosting,...

Already a member? log in here.

Upcoming CPE Webinars

Oct 9In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards.
Oct 15This webinar presents the requirements of AU-C 600, Audits of Group Financial Statements (Including the Work of Component Auditors).
Oct 21Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience’s communication style.
Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.