Guide to MrExcel.com Website
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
Latest Blog Posts
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…
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…
I will be joining the Excelapalooza speakers this year, providing six sessions at this three-day conference outside of Dallas, Texas. Reader…
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 – 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.
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
Find a complete collection of mugs, shirts, and the Excel function clock, visit our CafePress store.
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.
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.