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!
  • Excel Filter by Selection
    There is a great Filter by Selection icon in Access. Excel offers the same functionality, but it is hidden and mislabeled! To add the command to your Quick Access Toolbar: Right click the QAT Choose Customize Quick Access Toolbar From the top left dropdown, change from Popular Commands to All Commands In the left listbox,(...)
  • Convert Excel Dates to Month Names
    Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format. Try these: =TEXT(A2,”MMMM”) for full month name =TEXT(A2,”MMM”) for 3-letter month abbreviation =TEXT(A2,”DDDD”) for full month name =TEXT(A2,”DDD”) for 3-letter month abbreviation You can use any valid custom(...)
  • Excel Fill Alphabet or Roman Numerals
    Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III? For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down. For the lower case alphabet, use =CHAR(ROW(97:97)) For upper case Roman numerals: =ROMAN(ROW(1:1)) For lower case Roman numerals =LOWER(ROMAN(ROW(1:1))) Tip: After filling any of these,(...)
  • Excel Search Entire Workbook
    You need to find something, but you don’t know what worksheet it is on.   Display Find with Ctrl+F Click the Options > > button. Open the Search dropdown and change from Sheet to Workbook.
  • Copy Excel Worksheet – Easy and Fast
    You’ve created the perfect report for January. Now you need to make 11 copies for the other months. Hold down the Ctrl key. While holding down the Ctrl key, click on the sheet tab and drag to the right. You should see the mouse pointer change to an arrow pointing to a sheet with a(...)