About Bill Jelen

http://www.mrexcel.com

Posts by Bill Jelen:

Full Slate of Excel Bloggers at PASS Business Analytics Conference

               

There is an amazing line-up of speakers at this year’s PASS Business Analytics Conference. You might read blogs by some or all of these speakers: Bob Phillips, Ken Puls, Jordan Goldmeier, Matt Allington, Rob Collie, Chandoo, Avi Singh, Rick Grantham, Oz du Soleil, Chris Webb, Jen Stirrup, Jen Underwood, Kasper de Jonge, Igor Peev. I am(…)

Help fund and be a part of my 40th book: MrExcel XL

               

Do you remember: Led Zeppelin II Chicago III Rocky IV Star Wars V I am about to write my 40th book. MrExcel XL (yep, “40” in Roman is “XL”) In a crazy bid to build buzz, I am pre-selling the book and everyone who buys gets their name in the book. Funds are used to pay for upgrading the book(…)

Free Fresh Excel Content For Your Blog or Website

               

There is a great discussion at the MrExcel forum about using Excel forums to increase your knowledge of Excel. Board member TinaP summarized it this way: “Books got me started with Excel knowledge, but the forums educated me.”. Most people who use Excel 40 hours a week don’t realize which powerful tools they do not(…)

Why Haven’t You Adopted Power Pivot Yet?

               

It is late 2014, almost 4 years after PowerPivot reached general availability. This product is a game-changer. It enables people to do dramatically more powerful analyses than regular pivot tables. Yet, when I walk into a room full of 100 people who opted to come to a Power Excel with MrExcel seminar, there are only(…)

Make Font Red If It Meets a Condition – Without Conditional Formatting

               

Before there was conditional formatting, there was custom number formatting. You can still add a condition to your custom number formats. Select the range of cells. Press Ctrl+1 to open the Format Cells dialog. Select the Number tab. Choose Custom from the bottom of the list. In the Type box, enter a format such as(…)

Learn Excel from MrExcel