1. Articles
  2. Excel Heroes: MrExcel Turns 25

 
On November 21, 2023, Excel guru Bill Jelen celebrated a jaw-dropping milestone, and Sheetcast was thrilled to play a co-starring role in the occasion (more on that at the end of this article).

Exactly 25 years ago, in 1998, Jelen published his first in a series of weekly Excel help articles at his brand-new website MrExcel.com (hardcore fans can still read that debut article thanks to the Wayback Machine). Soon afterward, he launched the MrExcel Message Board, an online community for Excel enthusiasts like himself. It quickly blossomed into a thriving forum for online collaboration, a place where people could ask questions, contribute answers, and share each other’s Excel tips and tricks. The board remains active today, with over a million threads and five million posts.


 
Jelen’s online profile took another huge leap in 2006, when he launched the MrExcel channel on YouTube. His friendly, relatable personal style clearly translated to video. At the time of writing, the channel boasts a staggering 2,468 Excel tutorial videos, 148K subscribers, and well over 20 million views. Exploring Jelen’s channel may just be the best way to learn Excel without spending a dime, never mind the 67 books he has written and published about Excel.

To give you a sense of the vast expanse of Jelen’s online career, he was working in Excel 97 on a Windows NT machine when he launched his weekly blog in 1998. Let’s look back at a few memorable Excel developments that have occurred since he began as an online Excel advisor—and, where possible, travel back in time for his take.

End of the Clippy Era

Microsoft Office 2000 made its retail debut June 9, 1999. Today, this version is remembered as the death knell of “Clippy,” the much-maligned office assistant known for popping up in annoyingly inopportune ways. (Clippy technically survived until Office 2007, but at least it was now turned off by default). Jelen’s own thoughts on Clippy don’t appear to be preserved online but, as an Excel 97 power user, you can be sure he would have an opinion.

The Great Ribbon Panic of 2007

On January 30, 2007, the public got its first taste of Excel 2007. The release represented a major overhaul of the Excel interface with the introduction of the ribbon menu system. Although most people nowadays could barely imagine Excel without a ribbon, at the time the change caused an uproar among experienced users—many of them even penning lengthy rants about how they would never buy the new release. 

 

For his part, Jelen hailed Excel 2007 as a massive upgrade overall. But even he had his reservations about the ribbon—in particular the huge amount of real estate it occupied at the top of the screen. So, he released a MrExcel video explaining how his viewers could minimize the ribbon to free up more space for their beloved spreadsheets.

Sparklines Trend in Excel 2010

In the summer of 2009, Jelen got his hands on a technical preview of the upcoming Excel 2010. He quickly pulled together a video centered around Sparklines, the one new feature that had him, quote, “giddy with excitement.”
With this new feature, Excel users could instantly add tiny charts to cells in their data, providing vivid indicators of trends in the numbers. “If you’ve ever looked at a table of data and struggled to see the overall trend,” wrote Jelen, “then you’ll understand why Sparklines are such a game-changer.”

Flash Forward to Flash Fill in Excel 2013

Although Jelen is fluently adept at building formulas to coax Excel to do what he wants, he also celebrates new Excel functions that enable lesser beings like us to generate our own magic.

In episode 1589, Jelen walked his viewers through Flash Fill—a feature that has since saved Excel users countless hours of drudgery. “Oh my gosh,” gushed Jelen as he began to enter data into a couple of cells only to have Excel intuitively suggest entries for the entire remainder of the column. “I just press ENTER and the whole thing is done. Is that amazing, or what?”


 

Power Query Fully Integrated in Excel 2016

Power Query, Excel’s, ahem, powerful tool for importing, cleaning and combining data into Excel, was first introduced as an optional download for Excel 2010 and 2013. With the arrival of Excel 2016, however, the feature was built into Excel under the “Get and Transform” tab.

Although Jelen had produced a few videos on Power Query by then, he used 2016’s Episode 2037 to introduce the Excel function to an audience who might be encountering it for the first time. “Just amazing how cool it is,” he enthused.


 

Dynamic Arrays Trump Pivot Tables in Excel 2019

As the release date of Excel 2019 approached, one new feature was causing a stir in the online Excel community: Dynamic Arrays. Jelen responded by illustrating a quick and straightforward way to leverage their power. Using three Dynamic Array formulas, he replaced an ordinary pivot table with a table that instantly and automatically responds to changes in the underlying data—no refresh needed. “This is super cool and super powerful,” said Jelen.

Excel 2021: MrExcel had a Little LAMBDA

When LAMBDA functions debuted in Excel 2021, Jelen was, in a word, stoked. “These functions are set to change the game and revolutionize the way we use Excel,” he wrote.

He celebrated LAMBDA’s arrival in Episode 2381, walking viewers through several practical examples of how they can be used. “I’ve never seen so many Excel MVPs write so many articles on the same day about something,” he observed.


 

November 2023: MrExcel Meets Sheetcast

Because Bill Jelen has reported on every major Excel development in the past 25 years, the Sheetcast team was thrilled when he chose to highlight the patented new Excel add-in for his 25th anniversary episode.

“Today, I have something truly amazing to show you—how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property,” he wrote. (Click here for more about the importance of protecting your spreadsheets.)

In the video, Jelen showed a complex spreadsheet he had built to enable him to search his entire catalogue of YouTube videos for specific topics. The Sheetcast team had promised to take his spreadsheet and quickly turn it into a functioning web app. Jelen was initially dubious. “I honestly figured I had used some functions that probably were going to throw them for a loop.”

Sheetcast surprised him. “This is really pretty mind blowing,” he said in the video. “I gave them a fairly complicated worksheet with 18 different functions on Friday, and on Monday I now have a web app that's actually working, that replicates all of the logic that I knew how to build in Excel.”

Jelen shared with his viewers a working URL where they can check out the web app for themselves, and even enter search queries of their own. In doing so, he also inadvertently contributed massively to the writing of this article—by enabling the author to instantly locate all the MrExcel videos cited above.

Given Bill Jelen’s decades as an Excel MVP (and one of the internet’s most beloved Excel advisors), it was a massive honor for Sheetcast to knock his socks off for his milestone anniversary. Head to the home page for more information (and a demo video). Become your own Excel web app developer today.


 

More Articles:

Excel plus Sheetcast as Your Ultimate Spreadsheet.com Alternative

Amid Spreadsheet.com's closure, Sheetcast provides a reliable solution, an Excel add-in. Created by a company of 15+ years, Sheetcast offers more than a quick fix. It pioneers innovative data management and application development, providing a secure path for those impacted by Spreadsheet.com's shutdown.

Customers Scramble for Alternatives as Spreadsheet.com Shuts Down

With Spreadsheet.com closing its doors on May 31, users are actively seeking alternatives. Sheetcast, an Excel add-in, stands out as the top solution, providing advanced capabilities and a seamless transition to reconstruct workflows into customized web apps. Sheetcast provides a smooth solution to Spreadsheet.com's shutdown

Excel Heroes: N-nyiimock Bitanyanmi

N-nyiimock Bitanyanmi is a welcome and familiar face in the online Excel community, where he often goes by the name Justice. Behind his enthusiasm, knowledge, and eagerness to learn, however, lies a surprising fact: until he was almost an adult, he had rarely laid hands on a computer.

Excel Heroes: Chandeep Chhabra

Meet Chandeep Chhabra! When the Mumbai investment bank where he worked suddenly couldn’t make payroll anymore, Chandeep decided to turn his “Excel expert” side hustle into a full-time career. Despite having little experience and zero Excel credentials, he cold-called his way into a job interview at a major financial services company—and the rest is history.

Excel Heroes: Ken Puls

Follow the captivating journey of Ken Puls—from a novice to a renowned expert! Discover how this Excel hero transformed from an accounting supervisor to a global Excel trainer, sharing his passion for automation and unlocking Excel's full potential.

Excel Heroes: Alan Murray

Embark on the remarkable odyssey of Alan Murray, in his journey from computer mentor to MVP. Starting with teaching computer basics, Alan's evolution into an Office 365 specialist led to him focusing on Excel and Power BI. Alan discovered his passion for Excel and is now leading the popular London Meetup, fostering a global community of Excel enthusiasts.

Excel Heroes: Gašper Kamenšek

Discover Gašper Kamenšek's journey from college student to Excel MVP. His passion for Excel ignited during Microsoft Office classes, leading to a career shift and a thriving community involvement. Explore his experiences, insights, and adventures, from overcoming toxic work environments to becoming a sought-after speaker. Dive into his love affair with Excel and the ever-evolving landscape of data analysis.

Bulgaria Excel Days 2024

Sheetcast proudly announces their lead sponsorship for Bulgaria Excel Days 2024, demonstrating their dedication to the Excel Community. Join experts Ken Puls, Gašper Kamenšek, Alan Murray, and others for three days of Excel insights, presentations, and masterclasses. Don't miss Alex Martin of Sheetcast, premiering advanced new functions and workflows. Bulgaria Excel Days 2024 runs April 23-25 in Sofia, Bulgaria.

Excel Heroes: Crispo Mwangi

As the only Excel MVP in East, Central, and Southern Africa, Crispo Mwangi stands out as an Excel Influencer, business owner, and host of an MS Excel Forum, making his skills highly sought after. Despite his many commitments, this Kenyan luminary published his latest book, "Excel with PowerQuery and ChatGPT.

Advanced Data Visualization Techniques in Web Apps From Excel

If you’ve ever viewed a report or infographic powered by Excel-generated graphics, you recognize that the time-tested spreadsheet application has some powerful tricks up its sleeve in terms of data visualization. Bar charts, pie charts, scatter plots, pivot tables, and more

The Evolution of Efficiency from Excel to Web App

For decades, Microsoft Excel has been a foundational component in the way global businesses collect, analyze, track, and report data. As powerful and flexible as Excel is on its own, however, it can now also serve as a stepping-off point to something even more dynamic and efficient.

Tips to Prevent Data Entry Errors in Excel

With Excel, your formulas, charts, and reports are only as good as the data you enter. So, if you’re responsible for entering a vast data set, it’s important to minimize the risk for error.

Ten Memorable Excel Disasters

Pretty much anyone who has ever used Excel has a horror story or two to share—a misplaced decimal, a missing minus sign, a botched cut-and-paste, or some other minor blunder with potentially major consequences.

Seven Essential Ways to Protect Your Spreadsheet

Too many of us are cautious in our daily lives, but cavalier with the safety and security of our spreadsheets.

How to use forms in Excel … plus something better

Excel forms have improved my life. Now, I know there’s something even better (stick around to the end of this tutorial).

Co-authoring in Excel: Tips and Pitfalls

For years, Excel users have been able to collaborate on shared workbooks. By making it possible for multiple users to work together on a single file, Microsoft unlocked countless ways to boost efficiency and productivity.

Why Do People Still Use Spreadsheets?

Microsoft Excel debuted on the Macintosh in 1985 and came to Windows in 1987. Three and a half decades later, its name remains virtually synonymous with the very concept of “spreadsheets.”

Time for Excel to Evolve: From Spreadsheets To Web Apps

The Necessary Evolution from Excel Spreadsheets to Web Apps. Like many of the greatest technologies of our time, spreadsheets can be our salvation or our downfall – and with great power comes great responsibility.

Want to Convert Excel Spreadsheets to Web Apps?

Sheetcast enables you to convert Excel spreadsheet to web apps directly in Microsoft Office, a tool you already use every day. Sheetcast is affordable, easy to learn, and has hundreds of potential uses (limited only by your imagination).

Do You Use Any of These Five Excel Features? If So, Try Sheetcast

Maybe you’re a bit of an Excel guru. Your workmates frequently marvel at your ability to get the most out of the app, employing functionality they never even knew existed.