Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel

by Bill Jelen

Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL's, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other questions have produced results that have even surprised the Excel development team.

Genres: Computers, Nonfiction

224 pages, Paperback

First published October 1, 2008

About the author

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 company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for
readers all over the world.

Reviews

[☘Misericordia☘ ⚡ϟ⚡⛈⚡☁ ❇️❤❣ · Rating 5 out of 5]

A teensy-wheensy tadsy dated booksy but a lot of great ideas that could be transplanted into any further versions of XLSX. Really love the style of explaining things and the visually oriented layout.

[Mark Polino · Rating 3 out of 5]

I know a lot about Excel but I know that Mr. Excel, Bill Jelen knows a lot more. In Excel Gurus Gone Wild Bill tackles some crazy stuff that can be done with Excel. I started out thinking that this book was over even my head but as the book went I found more and more items that I know and use regularly and while I may not use some of the specific tips, tI will use a number of the techniques to tackle other problems. As Bill explains, this is not a book for the casual Excel user.

[Bill Jelen]

Hard-core Excel

[Themistocles · Rating 3 out of 5]

Although a bit old, I thought I'd give this book a try.

The examples shown in it show some real genius at work; however, they deal with real arcane tasks that almost no one, ever, will ever need. True, you can learn things from the logic behind the solutions, but the same could be done with more 'common' (we're talking about niches here, anyhow) tasks.

The book has an appendix with a great guide to all the Excel functions which is really helpful, but the rest is good almost only for the wow factor.

[John · Rating 2 out of 5]

A bit dated, but I did find some useful tricks and tips.

[Jon Von der heyden · Rating 5 out of 5]

I love this book. What a great idea, to dig into the big hitters archives of favourite threads and put together a book of said favourite threads! These are the topics that impressed the MrExcel forum MVP's. Not only does this book cover some great solutions to weird problems, but it also covers the many many concepts that are so important to get to grips with. Studying each article will help the reader achieve real "guru" status!

[Yi Peng · Rating 5 out of 5]

Interesting problems solved with creative usage of formulas, functions and VBA and macros. Enjoyed it from cover to cover.

[สวิตต์ เนาวรัตน์จิรวัฒน์]

ok