Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel

  • 3h 12m
  • Bill Jelen
  • Tickling Keys
  • 2009

Drawn from actual excel conundrums posted on the author's website, 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.

About the Author

Bill Jelen is an Excel expert at www.mrexcel.com, a regular on TechTV Canada's Call for Help, and a video podcaster who is regularly listed in the iTunes top 50. He is the author of Learn Excel from Mr. Excel, Pivot Table Data Crunching, and 14 titles in the Excel for Professionals series. He lives in Akron, Ohio.

In this Book

  • Formulas
  • Techniques
  • Macros
  • Train Your Staff