Excel - Green Bay Packers: Episode 1365

378 views · Published 21 March 2011 · 2:27 · Indexed 29 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Predict the Super Bowl Winner with Custom Number Formatting.

Welcome back to another Learn Excel podcast with Bill Jelen from MrExcel. In this episode, we will be revisiting episode 1358 where I was in Mike Girvin's office and allegedly found the missing episode. During that episode, I joked about having a formula that could predict the winner of the Super Bowl. And to everyone's surprise, the answer that popped up was "Green Bay Packers". I challenged our viewers to figure out how I did it and we had five people who sent in the correct answer.

So, how did I do it? Well, it's all about custom number formatting in Excel. I simply entered the number 5, went to the custom number format and changed it to display as "Green Bay Packers". This means that any number I enter will now show up as "Green Bay Packers". But that's not all, you can also combine text and numbers in the custom format. For example, "Green Bay Packers will win by" and then the number code. So when I change the number to 19, it will now display as "Packers win by 19". Pretty cool, right?

I want to give a shoutout to the five viewers who sent in the correct answer - Noel, Richard, Bob, Stan, and Reuvain. As promised, I will be giving away a copy of Mike's new book to one of these lucky winners. Using the INDEX and RANDBETWEEN functions, the winner is... Noel! Congratulations, Noel, and thank you to everyone who participated in this fun challenge. I hope you all learned something new about custom number formatting in Excel.

Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe to our channel for more Excel tips and tricks. And if you have any suggestions for future episodes, please leave them in the comments below. See you next time!

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/


Table of Contents:
(00:00) Introduction to MrExcel podcast 1365: Green Bay Packers
(00:11) Finishing up episode 1358
(00:26) Using a formula to predict the Super Bowl winner
(01:11) Customizing number format to display "Green Bay Packers"
(01:45) Announcing the winners of the contest
(02:17) 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:
Ctrl+1 shortcut in Excel
Custom number format
Excel formulas
Green Bay Packers
Index formula in Excel
Learn Excel
Mike Girvin's office
Mike's new book giveaway
Statistics in Excel
Super Bowl winner prediction
Text formatting in Excel


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


Today we look at a question posed in Episode #1358 "How did Mike and Bill predict the Super Bowl winner?" Bill gives us the answer in Episode #1365 - and announces the winner of the contest.

More from this channel