The 40th Anniversary of Excel: Unlocking the fascinating History, Easter Eggs, Excel humor, and more

Can't believe it. You did it. We did it. It looks great. This is a miracle.

This is Microsoft Excel. So why don't we go ahead and get started. First, I'm going to list 16 fun facts about Excel. So the first many of you may not know this, but Excel was originally launched for the Mac. Excel today supports 16 million colors. You can have 17.2 billion cells in Excel. Did you know the formula bar in Excel can only handle up to 32,767 characters? The next I'd say big upgrade was 2021 added dynamic arrays. At this point we had a roughly 482 function. One of the most interesting functions I think in Excel is Financial Modelers Corner is the world's premier modeling podcast. It is brought to you by Financial Modeling Institute, the world's leading financial modeling accreditation organization. Welcome to Financial Modeler's Corner. I am your host Paul Barnhurst, AKA the FP and a guy and this is a podcast where we talk all about the art and science of financial modeling with distinguished financial modelers from around the globe. This week is a special episode. As many of you may know, this year 2025, Microsoft celebrates its 40th birthday for Excel. Excel was launched in 1985. So I thought it would be fun for this episode to go through some fun things about Excel. Some of its history, different releases, some Excel jokes, some fun things done in Excel and I'm going to share my screen throughout. I encourage you if you're able to watch this episode on video, but you can also listen to it as audio as I will walk through everything I do, but I do think you'll get more out of it. There will also be a spreadsheet that I will put on my website that you can download that talks about some of these things. So super excited. I think this will be a really fun episode. It will be unique and different. So why don't we go ahead and get started. First, I'm going to list 16 fun facts about Excel. You could see them here on the spreadsheet if you want to look at it. Or I'll just talk to them. So the first Many of you may not know this, but Excel was originally launched for the Mac. Yep, that's right. Winix Mac. A couple other interesting facts. The original code name for Excel was Odyssey. Also when they considered names for Excel, they had these doozies. First they considered seriously it was one of the finalists naming it Mr. Spreadsheet. Could you imagine saying to all your students now please open Mr. Spreadsheet and how that would be perceived by females and other people. The other name they considered was Master Plan. The first version of a spreadsheet Microsoft released before Excel was called Multiplan. So it's probably similar to that. This I found really fascinating. I didn't know this till I did my research. Excel was the first computer application in the world to use a toolbar. Nobody had ever used a toolbar in a software application until Excel did it. I believe it was Excel 3.0. We'll talk a little bit more about that later. There's more than 500 functions today. 516. We'll talk about that as well a little bit later. Excel today supports 16 million colors. This is a really interesting one that I'm going to guess most people didn't know. You cannot name a worksheet as history in Excel. It's saved for versions. It saves history there. I just tried doing it today. It doesn't work. It says that name is reserved. Another interesting one is dates in Excel. The first date in Excel is actually the number zero. But what's really weird is if you put the number 0 in, the date you'll get is Saturday, January, 0, 1900. Excel also considers 1900 a leap year, even though it actually wasn't a leap year because of the zero. So some interesting facts there. Number eight. All of us use undo control Z, one of the most used functions in Excel. But did you know the maximum number of times you can undo something is 100? So if you have 101 to do well, you're screwed. You can only go to 100. A workbook can only contain a certain number of hyperlinks. I don't know how anyone ever used this many. But you can only have 65,530 hyperlinks. If you go over that limit, you'll get an error. Surprisingly enough, your charts. You can have up to 255 data series in one chart. I would argue if you have that many, you got bigger problems. But don't have 256 or you'll get an error. Next. You can have 17.2 billion cells in Excel. Technically, you could fill all of them. Although I would argue your computer would bomb out. It can't handle the memory. At least if you try to write a formula that spills to all of them. I tried it with a dynamic array and it definitely could not do 17.2 billion. The memory couldn't handle it. Next. Excel can handle big numbers, but if you go more than 15 digits, what will happen is Excel will start rounding. So if you're dealing with super large numbers, you will start to get errors in Excel. Next. Excel actually has a limit to its file size. I did not know this. I was not aware there's a limit. The limit is 2 gigabytes. The biggest file I've ever opened was a gigabyte in Excel. I have not got close to two. If anyone has, please email me. I'd love to know what that monstrosity was generally. You know, people say it's huge. If it's like 3050 meg, I've seen a billion. You can go all the way up to 2 billion or 2 gigabytes. So 2 billion bytes. Did you know the formula bar in Excel can only, and I use the word only loosely, can only handle up to 32,767 characters. So don't go over that when you're writing your functions. If you do, maybe you need a helper column. Next. I don't know how many knew this, but Excel pixel art is a real thing. You Google it, you'll find all kinds of art out there. But the most interesting is a guy by the name of Tatsu Hirochi who made a living out of Japan. And we'll share a little bit more about that later. Building beautiful art in Excel Next. One of the most interesting functions I think in Excel is the bot text function. So it's ba and it was originally created in the Thailand version of Excel to turn display a number in Thai as a text. They needed that for some of the things they were doing, a help with some kind of regulation and it made its way into the full version of Excel. So it's one of the most unique functions because most people look at it and go why would I ever use that? Why would I want a number to be converted to text in Thai? So there's a few interesting facts. Next, what I want to do is I want to go through a little bit of the high level Excel timeline and with that we're going to look at some images. I'm going to talk to them. That just shows some of the original old screens. There's a great website that shows the 40 years of history. So first let's just talk a little bit of history. So Excel was released in 1985. It was the first Microsoft spreadsheet that was a graphical user interface. Multiplan was a command user interface. Interesting enough, the very first version only had 16,384 rows, 256 columns. Then it had roughly 150 functions. 1987 version 2 was released. They added roughly 20 new functions. And these are estimates. It probably wasn't until about 97, 2000 I got a clear number of functions. I kind of googled the Web, used Chat GPT and tried to make some estimates. 1987 they released it with roughly 170 functions. They added the menu option which we're all used to today. They upgraded it to 65,536 rows but kept the number of columns that stayed that way all the way till the 2007 version when they added 1.1 million rows and 16 columns, which is where the 17.2 billion cells comes from. The next one is 1990. That's when Microsoft Excel was released with the toolbar. First software ever have a toolbar. And that's when it killed Lotus 1, 2, 3. That's really where they started to get dominance in Ninet and It just continued. 92 they added charts. The huge upgrade was 93 VBA. 1995 they included the Office package. At this point they had roughly 300 functions. So they doubled in about the first decade. The first 10 years or so went from 150 to 397. They added VBA mode and another 25 functions or so. Around 2000 they added a few more functions, added new charts, tables which were originally lists came in 2003. 2007 Big 8 update was the toolbars and the ribbon and the million rows. Just think about that. We're also used to these type of things, but they weren't there. Pivot charts weren't added till 2010, only 15 years ago. And we saw Excel online come around. Then Flash fill was added in 2013. At this point we had 460. They added roughly 50 new functions in 2010, another 50 in 2013. Huge upgrades in 2016 that version and they had. At first it was a add in, then it became native. You saw Power Query, Power Pivot, waterfall charts before that. I still remember working in FP&A and having all these workarounds using a scatter plot or a bar chart or different ways to create a waterfall chart. The next I'd say big upgrade was 2021 added dynamic arrays. At this point we had a roughly 482 functions. Then there's 2024 which added another 20 functions. It added dynamics, charts, images, etc. Microsoft 365 today has roughly 516 functions. The most recent was just released in August of 2025 called Copilot and it allows you to call things from AI using the copilot function. Some other notable things. 2015 was the first mobile version of Excel. 2020 is when they implemented dynamic arrays which completely changed the way they work in Excel. 2023 is when we got Lambdas which made Excel touring complete when that came out. So that's a little bit of history. Now for fun we're going to go through and look at some of the design pages and I'll comment about those. So we're going to go to the website. You'll be able to find the website in the Excel document that will be on my website. But what's amazing is I'm looking at multiplan Multi plan was nothing but numbers command line. You know, it wasn't a graphical user interface. Just imagine what that would look like. Then we have Microsoft Excel for the Mac. Completely white background, blocky text. The spreadsheet just. It still has a little bit of today but it looks so different seeing it in a Mac. And it just keeps going. You know, Excel 2.0 for Windows, blue background with that purple and fluorescent blue color. And you're just looking at it going wow, that's ugly. But was huge for today, you know, had virtually no memory. Like in one of the images here it shows conventional memory, expanded memory, the formula ribbon, file edit gallery, chart format, macro window. Just think how different that is now what would those be? And then they show more images. We get up to 1990, you know, starts to look a little more similar to today, but still a very different menu. We have file edit, formula format data much closer to today options, macro window help and it just keeps going. I won't spend a lot of time here because I know many are listening to this but you know, you can see the, the progression that we go through on the screen. Can still remember, you know, 95 or actually yeah, Windows 95. We started to get little icons for everything and it was just a very different look of the toolbar. We even had it in version 5. 93 but this became much more pronounced and that just keeps going. They have about 70 images here. You can see what 2,000 look like. And you know, we get eventually to where today's ribbon is and just think, you know, it looks so different when I look at today in Excel. So kind of a fun history. Encourage you to go through that. We've talked about some of the functions next I think is fun. Well, my background is in fpa. I am also passionate about financial modeling. Like many financial modelers, I was self taught. Then I discovered the financial Modeling Institute, the organization that offers the Advanced Financial Modeler program. I am a proud holder of the afm. Preparing for the AFM examination made me a better modeler. If you want to improve your modeling skills, I recommend the AFM program. Podcast listeners save 15% on the AFM program. Just use code podcast. I want to share a little bit about the different Easter eggs. I'm not sure how many are aware of this, but for a long time Microsoft Office products would have Easter eggs in them. And for Excel, these Easter eggs were mostly games. So in 1995 they had what they called the hall of Tortured Souls. It was similar to Doom. If anyone's played Doom, first person shooter game, very popular in the 90s, I remember playing it in high school. So it was a Doom style game. In the Excel file that, like I said, you can download from my website, I put a YouTube video if you want to go see a little bit of what it looked like. You know, pretty amazing to think that was available in Excel. In 95 they also had 3D animated credits for the developers of the show. 1997, they added a flight simulator. And here's just an image of hall of Tortured Souls. I mean, just a very basic, almost brick style game. The flight simulator, again, very clunky, right in your spreadsheet, you see you could fly this plane. And so that was 97. The next one in 2000, they created one called Dev Hunter where you could race a car. And so that was the 2000 version. 2001, they also had the special Formula One animation. 2003, they had a Tic Tac toe and Space Invaders game. And 2019, they added a formula called Clippy where you could return Clippy and see an image of Clippy. There's a website called Excel Easter Eggs Fun and hidden surprises you might have missed. That's where I got a lot of this. And it has instructions if you can find a copy of these different Excel of how to access the games and access these Easter eggs. So if you're one of those nerds that want to have a lot of fun, go ahead and give it a try. Could be fun for you. All right, so that's a little bit about the Easter eggs. Next we're going to go through a list of some of my favorite Excel jokes. So that's what we're going to do next is I have about 10 here that I have listed and we're just going to run through those jokes. So here we go. Number one, what do you call a broken spreadsheet? The new employees problem. Or sometimes I've heard it said as the intern's problem. What did the data analyst put in his hair? Some product. Do you know what you say when you make a mistake in Excel? Not that you say oh sheet. Have you ever wondered why the spreadsheet was constipated? Well, it's because it couldn't budget. That's for my FPA audience. What is the best cell to store your Excel error message is it's column fu row 2 what do men and Excel have in common? They're both trying to turn everything into dates when they are not dates. What do gold diggers and Excel have in common? If you want them to stay in place, you have to throw money at them. What does every newborn spreadsheet need? Formula. Does anyone know why the spreadsheet hated his job? Too many functions. These next two One comes from Jordan Goldmeier and one comes from Chandu. Both Microsoft Excel MVPs. An analyst walks into a bar. Ouch. A pivot table walks into a bar and orders a beer. It says to the bartender, put me in the same tab, will ya? All right, so there's our nerdy Excel jokes. We've done our Easter eggs. We've talked about the function history from 150 roughly to 500 plus. Just all these amazing Excel things. Done the fun facts about Excel. Now I'm going to go ahead and share a couple fun Excel websites and I'll talk to what I'm seeing here. So if you want to see this, you can also follow along on video on YouTube. So the first site is the 7 Most Epic Excel creations ever. Beautiful pieces of art. And here shows somebody having created some trees. This is Tatasua Horici who created amazing art in Excel and if you're looking you can see it. If you're not, it's these trees. Very kind of white blossoms with a background in the sun. Amazing artwork. Something you would never think was created in Excel. Next, someone created a full length role playing game. Carrie Walken, an accountant from Canada, took him five months and he released it in March of 2013. It features 2,000 potential enemies in a storyline with four different endings depending on how you navigate the game. So you can go to my like I said website, download the file if you want to play the game. Another person showed how you can convert any photo into an Excel spreadsheet. It's think Mathis calls it cracking the digital photo file open, scraping out all the numbers and putting them into the cells of an Excel spreadsheet. That's how he describes the process. So the process is cracking the digital photo file open, scraping out all of the numbers and putting them into Excels in an Excel spreadsheet. There's a video about that. Again, if you go to the Excel file, you can go check that out. You know, kind of amazing. Think about that. How many would want their digital files all put in Excel. And he has a very unique way of doing it through numbers. It's really fascinating. In fact, if we click here for one minute, he has a fun video that kind of walks through him doing that and it's. It is pretty amazing. Some of your favorite songs and maybe you'll be in my next video. We also have another one where somebody does musical animation in Excel. There's a video for that, so you can check that one out as well. Another great guy is Clint Tuttle, professor at UT Austin. He shares a lot of great fun YouTube videos, funk parody, making fun of Uptown Funk and several others. He does the Justin Bieber one, so check that out. So many other things. Creating a Sudoku in Excel. One of the more interesting ones Chandu did is he created in Excel a pendulum using a scatter chart that is animated with an amazing 3D dancing pendulum. So you wouldn't think that you could do that with a scatter plot, but he shows these pendulums swinging back and forth and up and down. And so those are just some examples of many of the different things. You know, there are a lot of other great websites that just have all kinds of fun things that have been done in Excel. Last one is Tom Hinkle. I've played this many times. He created Minesweeper, the original Minesweeper game. If any of you remember it. I have it up here on my screen for those who are watching. And you can just click new game. It brings up a game in Excel. And then what you do is once the game loads is you just try to find the bombs. It's really quite, you know, it's quite fun to do that. I hit a bomb on my very first try, so I need to start over. But I can click on that. I can try to find the patterns and see if I can actually locate all the bombs without blowing myself up. So anyway, I probably talked too long. You may find this a boring episode, but with Excel turning 40, I thought it would be fun to just have an Excel themed episode. So I hope you enjoy this as much as I did. And we'll be back to our regularly scheduled episodes next week as we bring in some great guests and we have some exciting series and other things coming up that we'll be doing. All right. Well, that about wraps it up. Thank you so much for joining me. I hope you had fun with this episode. Going back to next week, we'll go back to the guest style episodes. We hope to have an announcement in the next few weeks of some other fun things we're doing. But stay tuned, keep listening, keep being a great modeler. And remember, the tool of choice for modelers is Excel. It's 40 years old. It's not going anywhere. It's something to be celebrated, all that it's accomplished. So thanks for joining me. And until next week, I'm signing off. We'll talk to you soon. Financial Modeler's Corner was brought to you by the Financial Modeling Institute. This year I completed the Advanced Financial Modeler certification and it made me a better financial modeler. What are you waiting for? Visit fmi@www.fminstitute.com podcast and use code podcast to save 15% when you enroll in one of the accreditations today.