Bill Jelen

Bill Jelen’s Followers (82)

member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
member photo
Jared
7,857 books | 218 friends

Reva Lucia
1,944 books | 190 friends

Loretta
584 books | 62 friends

IPG  In...
1,104 books | 441 friends

Nichola...
777 books | 36 friends

Lisa
1,099 books | 45 friends

Ivan
1,002 books | 4 friends

Jeff
243 books | 175 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.13 · 1,076 ratings · 84 reviews · 100 distinct worksSimilar authors
VBA and Macros: Microsoft E...

by
3.99 avg rating — 85 ratings — published 2010 — 5 editions
Rate this book
Clear rating
Microsoft Excel 2010 in Depth

4.09 avg rating — 65 ratings — published 2010 — 3 editions
Rate this book
Clear rating
PowerPivot for the Data Ana...

4.17 avg rating — 60 ratings — published 2010 — 5 editions
Rate this book
Clear rating
Excel Gurus Gone Wild: Do t...

3.98 avg rating — 57 ratings — published 2008 — 7 editions
Rate this book
Clear rating
Excel 2013 Pivot Table Data...

by
4.09 avg rating — 43 ratings — published 2013 — 4 editions
Rate this book
Clear rating
Pivot Table Data Crunching

by
3.86 avg rating — 43 ratings — published 2001 — 4 editions
Rate this book
Clear rating
PowerPivot Alchemy: Pattern...

by
4.10 avg rating — 39 ratings — published 2013 — 5 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
Excel 2016 VBA and Macros (...

by
4.38 avg rating — 29 ratings — published 2015 — 3 editions
Rate this book
Clear rating
Pivot Table Data Crunching ...

by
3.79 avg rating — 33 ratings — published 2006 — 2 editions
Rate this book
Clear rating
More books by Bill Jelen…

Group Report Sections

The grouping feature feels backwards. What if I have report headings above each section and I need to group the data below the heading?
 •  0 comments  •  flag
Share on Twitter
Published on September 22, 2022 02:00
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

Group Report Sections

The grouping feature feels backwards. What if I have report headings above each section and I need to group the data below the heading?
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…
Quotes by Bill Jelen  (?)
Quotes are added by the Goodreads community and are not verified by Goodreads. (Learn more)

“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.