Q&A with Mr Excel – Bill Jelen Answers Questions

Unfulfilled Promises?

And the Sad Reality of Forgotten Bloggers

There was blog post by Chandoo in 2013 where hundreds of questions were asked of Mr Excel.  In Bill Jelen’s defense, Bill states the questions were answered…  but in the interest of completeness, Bill played along.

Click Here For The Link to Chandoo’s Post

If There Was Only Time Enough Left On This Earth For One More Spreadsheet, What Would It Be Of?

It would be a spreadsheet learned from a 4 year old.  Specifically Mike Girvin’s son (ExcelIsFun Youtube Channel).

  • Get 3 columns filled with =RAND()
  • Select entire range
  • Create 3D Bubble Chart with multiple colors
  • Refresh, refresh, refresh
  • End The World

If the Number 42 Is The Answer To The Universe, Life and Everything.  Then How Can We Make Use Of That In Our Pursuit Of Excel Bliss?

That would have been a great name for book #42.  Unfortunately the book has already been written and is being published by a serious publisher that expects serious names to books.

Just In Case You Don't Get The "42" Reference
Just In Case You Don’t Get The “42” Reference

What Is The One Function You Would Love To See In Excel That Does Not Currently Exist?

“I want VLOOKUP to go left”.  There are workarounds for this that are included in the book.  But a simpler capability to be built within the function is high on Bill’s list.

How Many Marriage Proposals Have You Received?

No Mrs Excel has come out of the works due to his Excel fame.  No marriage proposals.

How Many Mr Excel Thongs Have You Sold Through Your Cafe-Press Store?

The story.  A woman was complaining that her man was spending way too much time on the Mr Excel Message Board.  And she lure him away from the message board using the Mr Excel Thong.


Do You Think Microsoft Will Continue To Support VBA In The Future?

We have another 20 years of VBA Support.  Which will get us to the end of Mr Excel’s working life.

Scatterplot, Boxers, or Pie Chart Briefs?

No Comment.

What’s Next?

Do you have a question for Bill?  What question have you always wanted to ask?  Leave a note in the comments section below.

Rick Grantham
Follow Me


You may also like

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

October 26, 2014

Monte Carlo Simulation Formula in Excel – Tutorial and Download

September 17, 2012

The Excel Rollover Mini FAQ
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.