Learn Excel from MrExcel - "How to Buy PowerPivot 2013": Podcast #1649

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Feb 19, 2013.
Starting on August 16, 2013, the stand-alone boxed edition of Excel 2013 now includes Power Pivot and Power View. Amazon currently sells this edition for $98: Amazon.com: Microsoft Excel 2013 Key Card (1PC/1User): Software

From Bill Jelen: "Microsoft marketing has made it incredibly difficult to buy Excel 2013 with PowerPivot. I've heard a lot of people say that they won't upgrade and will stick with Office 2010 forever, but this really isn't practical.

In today's video, I offer a workaround that will allow individuals or small companies to actually purchase Excel 2013 with PowerPivot 2013.
maxresdefault.jpg


Transcript of the video:
Learn Excel from MrExcel podcast episode 1649: How can I buy PowerPivot 2013?
Hey, everyone. Welcome back to the MrExcel netcast.
I'm reporting live from Bellevue, Washington here at the MVP Summit.
I have what I think is some important news.
We've been frustrated over the last week or so because the amount of complexity in buying Office 2013 is tremendous.
You know, I have a small business, I go to amazon.com.
They have the Home & Student, the Home & Business, Office Pro and if you've been watching the podcast, you've seen me talk about products such as PowerPivot, Power View.
I'm going to show GeoFlow soon, maybe Inquire.
There’s all these great add-ins and I want to make sure that I can get those add-ins.
You say, “Whoa, whoa, wait.
PowerPivot was free in Excel 2010.
I just had to go download it.” Well, no, not anymore.
You need a version of Office that includes that add-in.
You can't just go download it for free anymore.
When we started looking into this, we were slightly horrified that all of those offerings at Amazon did not include PowerPivot, Power View, GeoFlow, and Inquire.
Back in Excel 2003, that's the last time that Microsoft made this colossal mistake of separating out some features in Excel.
You could go buy the Standalone Box Edition and it would include all that stuff but the Standalone Box Edition at Amazon does not include the good stuff.
Well, I mean it includes lots of good stuff.
It includes VLOOKUP and charting and all the usual stuff but it doesn’t include PowerPivot, Power View, GeoFlow, and Inquire.
Microsoft you should start renting software.
I have a problem with renting software.
Right now, times are good, I'm selling books, everything is great, I'm happy to pay $ 399 right now and know that I’ll have a version of Office that I could use forever.
I don't want to pay some smaller amount and have to pay that again and again and again.
Maybe in a couple years no one will be buying books and I won't have the money to go out and buy Office.
I really like just buying the DVD and knowing that I can use it forever.
So you'll see Office 365 Home Premium-- heck I've pitched Office 365 Home Premium.
I’ve spent a lot of podcasts on that to my-- I had asked the question and they never answered.
Later on I learned Home Premium does not include the good stuff.
You have to go to Office 365 Midsize, the E3 plan $240 a year to get the good stuff.
By the way, that's not coming out until February 27th and today is February 19th or February 20th depending on when you get this post.
Yes, that really is a long pause because I just don't know what to say.
My friends who create Excel did not do this, right?
They are engineers.
They created great products.
I appreciate those products.
You will see me rave about those products.
It's someone else high up who puts the packages together who made what I believe to be the world's worst mistake right here.
The world's worst mistake.
Boy that's pretty serious.
Well, certainly in the top five.
Okay, now here's the thing.
They say well you can go out and do volume licensing.
Volume licensing if you get Office 2013 Pro Plus, then you get PowerPivot, Power View, GeoFlow, and Inquire and if you go to volume licensing and buy XL 2013 Standalone, right now it just has Excel but soon we'll be putting out an update that it has PowerPivot, Power View, GeoFlow, and Inquire.
But my rebuttal is, if I have to get volume licensing, I have to buy five copies.
Now, I don't know what the volume licensing price is but let's just estimate it's 399 times 5.
That means I have to spend $2,000 to get PowerPivot, Power View, GeoFlow, and Inquire.
Well hey, they are good products but if I’m just using PowerPivot to get, you know, to calculate a range or you know, MAX (x) minus MIN (x) that seems like a pretty steep price.
Now I need to send a shout-out to Ken Puls from excelguru.ca.
Ken is another MVP.
Ken knows about volume licensing and he has cracked the code.
To get into volume licensing you don't have to buy five copies of Office.
You have to buy five licenses.
Ken tipped me off.
I downloaded the entire 176-page list of volume licensing.
Ken suggested buy one copy of Office 2013 Pro Plus and four copies of Windows Vista DVD Playback pack.
These are about $9 each so now I pay for Office, great.
I pay a $36 upcharge just to get around the ridiculous licensing schemes that they have.
I can do that.
So let's say 399 for Office Pro, $36 for the four copies of this completely useless software.
By the way, if this catches on, Microsoft would be really perplexed when this product starts becoming their best seller because everyone starts buying four of them just to get Office Pro Plus as a volume licensing customer.
How do you become volume licensing?
Just go search for Microsoft Volume Licensing.
Pretty easy.
There's ‘Find a Vendor’.
I looked around my zip code.
There's a company just five miles away.
Give them a call and say, “Hey I want to become a volume licensing customer.
I'm ready to buy five licenses.
One license of Office 2013 Pro Plus and I watch a lot of DVDs I need four licenses of this DVD software.” You can be good to go.
Should it be this hard?
No, it absolutely should not.
This is silos.
You know, large companies have silos.
There's one department that does this and another department does this and they don't communicate well.
Here we have an example of where the people that put the packages together completely miss the fact that the Pro DVD needs to include those four add-ins but for right now thanks to Ken Puls we have a workaround.
Check out excelguru.ca.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,214,648
Messages
6,120,726
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top