Guide to MrExcel.com Website

Excel Resources

Excel Forum – Get your Excel question answered by the MrExcel community
MrExcel Blog – Articles about Excel
MrExcel Video Podcast – Over 1900 short videos about Excel
Excel Daily News – Daily recap of new articles about Excel from around the web
Visual Learning about Excel – Full-color, slide-based training with self-checks

Excel Products

Excel Books – We offer many books about Excel
Excel e-Books – Download a DRM-Free e-book immediately after purchase
Excel CDs – Training CDs
Excel Mall – Utilities from around the web
Become an Affiliate – Earn referral fees for promoting our e-books

Excel Training

Upcoming Power Excel Live – Attend one of Bill’s live seminars
Book a Power Excel Seminar – for IMA, IIA chapters
Orlando-area Speaker – Have Bill appear at your Walt Disney World area event
Onsite Training for Employees – Hire Smitty for multi-day training

Excel Consulting

Consulting – VBA or Java development in Excel or Access
Emergency Excel Help – Telephone support

Latest Blog Posts

 MrExcel Blog

UserVoice – What is your Idea to Improve Excel?

I just returned from the Microsoft MVP Summit where I spent a few days with the Excel team. Would you like a way to communicate your Excel i…

On Excel’s 30th Anniversary, Power Query is a Game-Changer

Today, September 30, 2015 is the 30th anniversary of Microsoft Excel. Version 1.0 debuted for the Mac on September 30, 1985. Excel, of cours…

Excelapalooza Discount Coupon

I will be joining the Excelapalooza speakers this year, providing six sessions at this three-day conference outside of Dallas, Texas. Reader…

Top 10 Excel Songs on YouTube

Joe Chirilov is a long-time project manager on the Excel team. He summed it up best when he noted: “One of the perks of working on an awesom…

Articles About Excel

Excel Articles – Over 2000 tutorials about Excel
Original Message Board Archive – 12,000 Excel Q&A from the early years of our Excel forum
Book Excerpts – Selected topics from our Excel books
Forum Hot Topics – Others post their questions and our community works through the answer. Browse our favorite solutions
Office Articles – Anne Troy’s collection of tips for Office

Purchase Training & Learn On Your Computer

Bill’s entire Power Excel seminar is available on DVD-ROM or for Instant Download.
Bill’s Excel Macros & VBA course is available on DVD-ROM or for Instant Download.
Mynda Treacy offers an Amazing Excel Dashboard Course.
Comprehensive Pivot Table course from MyExcelOnline.com. Save 10% with coupon code MREXCEL.
Rob Collie offers a comprehensive Power Pivot University.

Books – Bill’s Best-Selling Excel Books

Power Excel with MrExcel – 567 Excel Mysteries Solved
MrExcel XL – 40 Greatest Excel Tips – Full-color, fun & informative. With jokes, cocktails, tweets, and more.
Excel 2016 In Depth – Full-color guide to Excel 2016 from QUE.

Books – Power Pivot, Power Query, Power BI

Power Pivot and Power BI – The 2nd edition of Rob Collie’s guide to Power Pivot, Power Query, Power BI.
Learn to Write DAX – Hands-on guide to writing DAX formulas in Power Pivot and Power BI from Matt Allington.
M is for (Data) Monkey – The world’s best-selling guide to Power Query and the M language.
Power Pivot Alchemy – Covers Power Pivot, Power Map, Power Query.
Dashboarding and Reporting with Power Pivot and Excel – Guide to Power Pivot and Power View

Books – Our Favorite Authors

Excel Simulations – Fun uses for Excel, from Gambling to Genetics.
Ctrl+Shift+Enter – Amazing guide to array formulas in Excel.
More Excel Outside the Box – Cool techniques from Excel MVP Bob Umlas.
Guerrilla Data Analysis Using Excel – Subtotals, pivot tables, VLOOKUP.
Excel Tables – A guide to using Ctrl+T in Excel.

Learn Excel VBA Macros

Excel 2016 VBA & Macros Book – For the Excel expert who wants to learn VBA.
LiveLessons Excel Macros DVD-ROM – Bill’s one-day VBA course.
Holy Macro! 2,500 VBA Examples – CD with 2,500 Excel VBA Snippets.
Excel 2013 VBA CD-ROM – Slide-based visual training on VBA.

Excel Add-Ins

Speed up your spreadsheets using Fast Excel V3 from Charles “Fast” Williams.
Convert PDF to Excel or Word using Able2Extract. It is annoying how people use PDF now to ensure that you can not change their data. This easy-to-use utility will grab data from PDF files and quickly send it to Excel or Word. The Pro version can even take the super-hard-to-crack PDF files where all of the text is saved as an image and convert it to Excel. Check out my review of the product with screenshots.
Create amazing 5-D Scatterplots (3-D + size + color) using 5-D Chart Add-In.
If you are tired of Intuit’s Quicken, check out
XLYourFinances for a $29.95 Excel-based tool for managing your finances.

Fun Excel Products

watch

Find a complete collection of mugs, shirts, and the Excel function clock, visit our CafePress store.

 

 

MrExcel Information

Need a book shipped to the UK? Check out Excel Bookstore.co.uk
Looking for Excel books written in another language? See our international titles.
View our past Challenge of the Month
ExcelBookstore.com offers many Excel books.

grfics

Bill Jelen is proud to have been named 2003 Computer America Guest of the Year.
Bill made 86 appearances on TechTV’s Call for Help and The Lab with Leo Laporte. While these episodes originally aired from 2005 to 2008, they may still be seen in syndication. If you are looking for show notes from an episode, visit my complete list of TechTV appearances.

Check out the free cool spreadsheets developed by the MrExcel community. Donate yours too!
Check out our photo album of various people we’ve met from the MrExcel community.
Can You Total That Diagonally For Me? – Seasoned Excel veterans will appreciate this feature, which looks at the bizarre and seemingly impossible requests handed down from real managers.
I am honored to have received the Excel black belt from Colo and the Road to the Cell Masters.

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided “as is” and we do not guarantee that they can be used in all situations. This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com running. You can earn a commission for sales leads that you send to us by joining our affiliate program. View my Privacy Policy.

 

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations. This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com running. You can earn a commission for sales leads that you send to us by joining our affiliate program. View my Privacy Policy.

Excel ® is a registered trademark of the Microsoft Corporation.

MrExcel ® is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2016 by MrExcel Consulting | All rights reserved