Look Who it Was Random video

Excel - March Madness Bracket! How to Use the Commissioner Worksheet - Episode 463

1,574 views · Published 18 May 2009 · 3:41 · Indexed 29 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  March Madness Bracket! How to Use the Commissioner Worksheet.

Welcome back to the MrExcel netcast! In this week's episode, we're talking about the beginning of March Madness - the NCAA men's college basketball tournament in the United States. And to celebrate, we're hosting a competition where you can win some great Excel books. All you have to do is download your bracket from MrExcel.com/NCAA.html, fill it out, and send it in. It's completely free and there's no gambling involved, just some friendly competition and a chance to show off your Excel skills.

Now, let's dive into the topic of the day - the commissioner worksheet. This is the worksheet where the commissioner keeps track of all the entries for the tournament. It can be a tedious task, with 63 teams to enter for each participant. But fear not, we have a solution for you. Our commissioner spreadsheet includes a formula that shows the top and bottom seed for each game, making it easier for you to keep track of the teams.

But that's not all, we also have a formula that shows all the possible teams for each game as the tournament progresses. This is especially helpful when filling in winners earlier in the bracket, as the list of possible teams narrows down. And to ensure accuracy, we have a work area in the worksheet that uses the 'find' function to check for any errors in the codes entered for each individual entry. This way, you can easily spot and correct any mistakes.

So, whether you're a basketball fan or just looking for a fun Excel challenge, we invite you to download our bracket and join in on the competition. And don't worry if you don't know much about basketball, sometimes those are the years where you have the best chance of winning. Thank you for tuning in to this episode of the MrExcel netcast, and we'll see you tomorrow for another informative episode.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


The first entries in the NCAA office pool are starting to come in and the commissioner of the NCAA pool will have to key your entries from the faxed USA Today bracket into the spreadsheet. In the MrExcel spreadsheet, concatenation formulas help to make sure that the teams keyed for each player are correct. Episode 463 shows you how to use FIND, ISERR, and IF functions to check to make sure your data entries are in a list of valid values.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction to March Madness competition
(00:28) Commissioner worksheet and its purpose
(01:01) How the worksheet displays possible teams for each game
(01:48) How the formula narrows down possible teams as winners are filled in
(02:18) Using the 'find' formula to check for errors in player selections
(03:06) Reminder to download the bracket and play for free
(03:19) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Bottom seed
Bracket
Commissioner worksheet
Download bracket MrExcel.com/NCAA.html
Fine function
Formula
Is error function
March Madness
MrExcel.comNCAA.html
NCAA men's college basketball tournament
Round-1
Top seed


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152417/

More from this channel