Best Places to Trick or Treat Using Excel Power Map

Check out this great use of Excel 2013 Power Map to find the best places to trick or treat:

October 31, 2013 at 9:11 am Leave a comment

Does A-Z Sort Speed VLOOKUP?

Does sorting your VLOOKUP table A-Z speed up the VLOOKUP calc time? No! Instead, try sorting by popularity. Or, use Charles Williams trick with 2 True VLOOKUPs.

Continue Reading September 23, 2013 at 9:39 am Leave a comment

Live MrExcel Seminar in Daytona Beach or Ft Myers

Bill Jelen returns to doing live seminars with 2 events in Daytona Beach and Ft Myers Florida.

Continue Reading August 30, 2013 at 9:50 am Leave a comment

Local Power Pivot User Groups

Do you want to learn more about Power Pivot? Rob Collie is trying to gauge interest of people who would join a local user group. Drop in at his page to register your city.



August 21, 2013 at 12:22 pm Leave a comment

Even Excel 2013 Non-Commercial Includes Power Pivot

My contacts at Microsoft have confirmed that any stand-alone boxed version of Excel 2013 will include Power Pivot.

While Microsoft sees this as a single SKU, actually carries three such SKUs:

  • A non-commercial version of Excel. List Price $80. Currently less than $72. Sold as a key card here.
  • A stand-alone Excel 2013. List Price $109. Currently $98 as a key card. Sold here.
  • A stand-alone Excel 2013. List Price $109. Currently $99.99 for instant download. Sold here.

The non-commercial license is not to be used in revenue activities. It might be great for students or people who want to track millions of records around the home.

August 20, 2013 at 9:29 am Leave a comment

Power Pivot and Power View 2013 Now Included with Excel 2013 Standalone Box Edition

Big breaking news today from Microsoft. You can finally buy Power Pivot 2013 in a box.

Boxed Edition Of Excel 2013

Starting today, if you purchase the full boxed edition of Excel 2013 (currently $98 at, the download will include Excel 2013, plus Power Pivot 2013 and Power View 2013. It will presumably include the rest of the Power BI stack once those get released. If you previously purchased the Excel 2013 boxed edition, at the next update of Office, you will get the full version.

Why is this big news? Since February 2013, there was no way to buy a boxed edition from a retailer that included Power Pivot. Everything you could buy at Amazon did not include Power Pivot. You either had to license Office 365 Pro Plus at $12 a month, or go through Volume Licensing (E3 or E4) package to get Power Pivot. This was incredibly frustrating, since Power Pivot is so powerful, particularly for people without big I.T. departments.

Note that as of today, none of the boxed editions of Office 2013 include Power Pivot. It is only the boxed edition of Excel. This is roughly symmetrical with Excel 2003, when the boxed edition of Excel 2003 included some high-end features that were not in Office 2003 Standard.

To purchase from, follow this link.

Update Aug 20, 2013: Microsoft confirmed that the $79 non-commercial version of Excel *does* include Power Pivot. This SKU is for home use.

For confirmation of this story, see this Microsoft blog post which was edited today to include Excel 2013 Stand-alone.

August 16, 2013 at 8:00 pm Leave a comment

Registration Closing Aug 16 for PowerPivot Pro School

Signups Close Friday Aug 16

Rob Collie from has put together a great team of guest lecturers for his PowerPivotPro School. I am honored to be in this list:

  • Denny Lee, co-author of Professional Microsoft PowerPivot for Excel and SharePoint
  • Miguel Escobar, translator of DAX Formulas para PowerPivot
  • Kasper de Jonge, SQL Server client tools at Microsoft
  • Zack Barresse, Excel MVP and author of the upcoming book on Excel tables
  • Bill Jelen, Excel MVP and author of PowerPivot for the Data Analyst

By signing up, you get full access to the course for the next 12 months. But you have to sign up by Friday, August 16, 2013.  Head over to PowerPivotPro School to register.

August 15, 2013 at 9:37 am Leave a comment

Older Posts

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 735 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive