About

About MrExcel

Online, he's known as Mr. Excel, but offline, he's better known as Bill Jelen, a real-life Excel expert. Bill has over 18 years of spreadsheet experience. He has been doing Excel consulting since 1998 and it is now his full-time gig.

Bill works with clients all over the world, designing custom Excel applications, solving their Excel emergencies and providing tips and hints that help Excel users get the most out of their spreadsheet applications.

When he first launched MrExcel.com, Bill had no idea it would take off the way it did. When he received his first two questions five days after the site went live, he didn't know the answer to either one! He forced himself to learn Excel from his user's perspective, using the program in ways that were new to him.

By relating to other Excel users rather than programmers, he firmly believes that there are two ways to program every application. There is an easy and a right way. He'd much rather spend the extra time to give his clients the right solutions that save more time over the long haul than give them the easy solutions that will consume more of the clients' time than they should.

About Easy-XL

Easy-XL is a partnership between Bill Jelen of MrExcel.com and InformationActive Inc., a software company based in Ottawa, Canada.

Site Login



Shopping Cart

MrExcel Podcasts

Learn Excel from MrExcel
New Excel Tips & Tricks Every Weekday!
  • Make Font Red If It Meets a Condition – Without Conditional Formatting
    Before there was conditional formatting, there was custom number formatting. You can still add a condition to your custom number formats. Select the range of cells. Press Ctrl+1 to open the Format Cells dialog. Select the Number tab. Choose Custom from the bottom of the list. In the Type box, enter a format such as(...)
  • Data Pasted to Excel Starts Splitting at Comma?
              Usually, you grab text from Notepad or Email or a web page, paste to Excel, and it all stays in one column. But…one day, late in the afternoon, the pasted data starts automatically parsing into separate columns!     Here is the deal… I bet you did a Text to(...)
  • Prevent #N/A! in Excel VLOOKUP
    So, you have this nice little =VLOOKUP(A2,$Z$2:$AB$99,3,False) formula. But in order to prevent the #N/A! error when something is not found, you used to have to do the VLOOKUP twice:  =IF(ISNA(VLOOKUP(A2,$Z$2:$AB$99,3,False)),”Not Found”,VLOOKUP(A2,$Z$2:$AB$99,3,False)). This is far simpler starting in Excel 2010: Think about it. Let’s assume you are doing 1000 VLOOKUPs. There are 990 that are(...)
  • Power Excel Live 2014-2015 Schedule
    I am taking my Power Excel seminar back on the road for 2014-2015, hitting many of my favorite cities from the past plus some new cities. If you live near one of these Power Map markers, I would love to see you at a seminar this year. For the complete tour schedule, visit http://www.mrexcel.com/pressappearances.shtml MrExcel tour(...)
  • Add Any Excel Icon to the QAT
    Have you found a great Excel feature that is buried three clicks deep? Make it always be 1 click away by adding it to the Quick Access Toolbar (QAT) Adding to the QAT is simple: Right-click the icon and choose Add to Quick Access Toolbar.