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 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(...)
  • Use Wheel Mouse to Scroll Left & Right in Excel
    Sure… you can roll the mouse wheel to scroll up and down… What about left and right? Your mouse wheel can be pushed in, like you are clicking a button on the mouse, but you are “clicking” the mouse wheel. While you hold the mouse wheel down, move the mouse left or right to scroll!(...)
  • Move to Top of Selection in Excel
    You start at the top of the data set. You press Ctrl+Shift+DownArrow and Ctrl+Shift+RightArrow. This is great… you’ve selected the whole data set, but now how do you get back to see the top of the selection? Press Ctrl+Period twice. Each press of Ctrl+Period keeps the current selection but moves to the next corner (in(...)
  • Easy Territories in Excel Pivot Tables
    You pivot table has a list of cities, but no Territory field: There is an easy way to create a virtual Territory field: 1) Select the cities in the first territory (Click on first city, Ctrl+Click on others) 2) In the Pivot Table Tools ribbon, click Group Selection. 3) By default, they call the territory(...)