Bill Jelen

year in books
Juan Go...
280 books | 16 friends

IPG  In...
1,103 books | 414 friends

Shawna
59,357 books | 1,258 friends

Sally
2,772 books | 1,902 friends

Ivan
864 books | 4 friends

Loretta
506 books | 62 friends

Jeff
202 books | 172 friends

Lisa
1,014 books | 44 friends

More friends…

Bill Jelen

Goodreads Author


Born
in Salem, Ohio, The United States
Website

Twitter

Genre

Member Since
September 2007

URL


Bill Jelen is the host of MrExcel.com and the author of 50 books about Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and Guerrilla Data Analysis Using Microsoft Excel. He writes monthly Excel columns for Strategic Finance magazine.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
His has produced over 2000 episodes of his daily video podcast Learn Excel from MrExcel.
Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held co
...more

To ask Bill Jelen questions, please sign up.

Popular Answered Questions

Bill Jelen I start blasting Bruce Springteen's Born to Run album. When I wrote the monster 1400 page Excel 2013 In Depth book, the Born to Run playlist (all albu…moreI start blasting Bruce Springteen's Born to Run album. When I wrote the monster 1400 page Excel 2013 In Depth book, the Born to Run playlist (all album tracks plus 7 podcast episodes) was played 46 times.(less)
Average rating: 4.14 · 1,032 ratings · 83 reviews · 97 distinct worksSimilar authors
Microsoft Excel 2010 in Depth

4.11 avg rating — 64 ratings — published 2010 — 3 editions
Rate this book
Clear rating
VBA and Macros: Microsoft E...

by
really liked it 4.00 avg rating — 81 ratings — published 2010 — 4 editions
Rate this book
Clear rating
PowerPivot for the Data Ana...

4.17 avg rating — 60 ratings — published 2010 — 6 editions
Rate this book
Clear rating
Pivot Table Data Crunching

by
3.83 avg rating — 40 ratings — published 2001 — 5 editions
Rate this book
Clear rating
Excel 2013 Pivot Table Data...

by
4.12 avg rating — 42 ratings — published 2013 — 5 editions
Rate this book
Clear rating
Excel Gurus Gone Wild: Do t...

3.96 avg rating — 56 ratings — published 2008 — 7 editions
Rate this book
Clear rating
Pivot Table Data Crunching:...

by
4.16 avg rating — 37 ratings — published 2010 — 4 editions
Rate this book
Clear rating
VBA and Macros for Microsof...

4.30 avg rating — 27 ratings — published 2004 — 3 editions
Rate this book
Clear rating
Pivot Table Data Crunching ...

by
3.79 avg rating — 33 ratings — published 2006 — 3 editions
Rate this book
Clear rating
VBA and Macros for Microsof...

by
4.05 avg rating — 22 ratings — published 2007
Rate this book
Clear rating
More books by Bill Jelen…

Run A Macro From A Shortcut Key

You recorded a macro but forgot to assign it to a shortcut key. Now you need to change the shortcut key used for the macro. Excel documents the shortcut key used when recording a macro in the comments at the top of the macro. However, changing the comment in the macro does not have any effect on the actual shortcut key used. Read more of this blog post »
 •  0 comments  •  flag
Share on Twitter
Published on May 07, 2021 02:00

Upcoming Events

No scheduled events. Add an event.

Analytics Stories...
Rate this book
Clear rating

 
Endurance: A Year...
Rate this book
Clear rating

 

Bill’s Recent Updates

Bill Jelen wrote a new blog post

Run A Macro From A Shortcut Key

You recorded a macro but forgot to assign it to a shortcut key. Now you need to change the shortcut key used for the macro. Excel documents the shortc Read more of this blog post »
Bill Jelen has read
MrExcel LIVe by Bill Jelen
Rate this book
Clear rating
Bill Jelen has read
The Absolute Guide to Dashboarding and Reporting with Power BI by Kasper de Jonge
Rate this book
Clear rating
Bill Jelen has read
Power Excel 2019 with MrExcel by Bill Jelen
Rate this book
Clear rating
Bill Jelen has read
Excel 2019 – Business Basics  Beyond by Chris Smitty Smith
Rate this book
Clear rating
Bill Jelen has read
MrExcel LX The Holy Grail of Excel Tips by Bill Jelen
Rate this book
Clear rating
Bill Jelen has read
Introduction To Financial Modelling by Liam Bastick
Rate this book
Clear rating
Bill Jelen has read
Excel Insights by 20 Excel MVPs
Rate this book
Clear rating
Bill Jelen is currently reading
Continuing Financial Modelling by Liam Bastick
Rate this book
Clear rating
Bill Jelen has read
Power Friending by Amber Mac
Rate this book
Clear rating
More of Bill's books…
“273 Ctrl+Ditto copies the formula without changing the reference.”
Bill Jelen, Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved

“Famous designer Erik Spiekermann released a font called Axel that he designed for on screen use in spreadsheets.”
Bill Jelen, Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved

“I have to tell you, if you can make a room full of CPAs ooh and ahh, you know that you’ve got some good karma going.”
Bill Jelen, Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved




No comments have been added yet.