Excel for PI Day - Using Excel to Calculate Best Pizza Value - Episode 1666
1,122 views · Published 14 March 2013 · 2:28 · Indexed 26 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: It's PI Day - 3/14 or 3.14 - and Pizza is typically round in the US, so today Bill has decided to dedicate today's Podcast to =PI()*Radius^2. Welcome back to the MrExcel podcast. In this episode, we're celebrating Pizza PI Day! March 14th, also known as 3.14, is a day to honor the mathematical constant PI. But why is this date specifically chosen? Well, let's dive into some Excel magic and find out. First, we'll format the number 3.14 with a custom number format of M dot D, which represents the modern way of writing the date. And if we use the right number of decimal places, we'll see that it also equals 3.14. A clever math joke that math enthusiasts like myself can appreciate. But let's not stop there, let's see if we can use PI to solve a real-life problem. In this case, we have Mo's Pizza Shop with two sizes of pizza: a 10-inch for $6.99 and a 15-inch for $10.49. At first glance, it seems like the prices are similar, but let's use our Excel skills to determine which one is the better deal. We know that the area of a circle is PI times the radius squared, or PI times R squared. So, in Excel, we can use the formula =PI()*(diameter/2)^2 to calculate the area of each pizza. And when we do the math, we see that the 15-inch pizza has a total area of 353 square inches, while the 10-inch pizza only has 235 square inches. Clearly, the 15-inch pizza is the better deal, giving you more pizza for your money. So, next time you're at Mo's Pizza Shop, remember to order two larges instead of three smalls. So, whether you're a math geek or just someone who loves pizza, I want to wish you a Happy PI Day. And don't forget to treat yourself to a slice of pizza or a blueberry pie, whichever you prefer. Thanks for tuning in to this episode of the MrExcel podcast, and I'll see you next time for more Excel tips and tricks. 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) Explanation of Pi Day (00:16) Formatting Pi as a Date (00:26) Using Pi to Solve a Real-Life Problem (01:01) Comparing Pizza Sizes and Prices (01:11) Calculating Area of a Circle in Excel (02:03) Choosing the Best Deal at Mo's Pizza Shop (02:13) 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: Area of a circle Best deal Custom number format Episode 1666 Large pizza Learn Excel Math joke Mo's Pizza Shop Pi Day Small pizza Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153488/ Follow along with Episode #1666 to get a bit of PI/Pie humor and some Radial number crunching in Excel with MrExcel! ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!
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