This page is dedicated to the best selling, most helpful Excel products from MrExcel, found at The MrExcel Store. Links for products will deliver you to the ‘Information’ page for the products – not the MrExcel Store Page. Pressure sales are passé and of no value to you, our loyal patrons; informed decisions are encouraged.
Please Note: The content of this page will change from time to time based on the popularity of particular products or the introduction of New Products from MrExcel and Holy Macro! Books.
If you view the ‘Learn Excel from MrExcel’ Podcast Series, then you’ve certainly seen this sponsoring paragraph, “…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!” But there is more to it!
Many Excel books try to go in a serial fashion through every single Excel option. These books are tough to use. No one at my dinner table ever uses the word “concatenation” in dinner conversation. How would you know to turn to the chapter on concatenation when you need to learn how to join a column of first names with a column of last names?
This book offers 512 real-life business problems. Each topic starts with a problem and then provides a strategy for solving the problem. Some topics may offer additional details, alternate strategies, results, gotchas, and other elements, as appropriate to the topic. You will never have to go hunting for “Concatenation”. Instead, turn to the topic on “How to join two text columns”. To continue reading, click here.
“VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” by Bill ‘MrExcel’ Jelen
“A Brilliant, Media-Rich How-To in the realm of VLOOKUP!”
From ‘MrExcel Labs’, this Enhanced eBook is designed *exclusively for the iPad*. This e-publication Includes text, audio, and video; a media-rich and in-depth look at the Excel VLOOKUP by Bill Jelen. To read more, click here.
The 2500 VBA Examples CD is an amazing resource. A joint project between Germany’s Hans W. Herber, Tom Urtis, and MrExcel, the CD is the most comprehensive reference on Excel VBA available today. Check out the solutions available on the CD. Originally published by Microsoft MVP Hans Herber in German. This CD is a best-seller in Europe. Painstakingly translated to English by the MrExcel team.
Every example is completely indexed and searchable. To read more, click here.