Excel - Green Bay Packers: Episode 1365
378 views · Published 21 March 2011 · 2:27 · Indexed 29 October 2026
Channel: MrExcel.com · 2011 · Education
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920