What version of Office 365 has the best Excel experience?
June 07, 2019 - by Bill Jelen
Which version of Office 365 should you buy? If you spend 20, 30, 40, or more hours a week in Excel, there are three specific choices that will work.
Microsoft marketing has made it super-confusing to figure out which version of Office is the right one for you. In most companies, your I.T. department is going to make the decision, but as an Exceller, it is critical that you provide input to the I.T. department.
These are the versions that you should consider:
Office 365 Pro Plus is US $12 per month per user. Along with Excel, you get Power Pivot, Power Query, Inquire, and 3D Maps. This covers Office installed on up to five PCs. It includes Word, Excel, PowerPoint, Outlook, and OneDrive. When you visit the landing page, the important paragraph is the third one under All Features.
Office 365 Enterprise E3 is $20 per month per user. It also includes Excel tools such as Power Pivot, Power Query, Inquire, and 3D Maps. It can be installed on five PCs. It includes Word, Excel, PowerPoint, Outlook, OneDrive, OneNote, Publisher, SharePoint, Access, and Teams. The magic paragraph is found when you scroll 53% down the page:
Office 365 Enterprise E5 is $35 per month per user. It includes everything in Enterprise E3 plus a Power BI Pro subscription for live dashboards. There is no “magic paragraph” on this landing page, but the Excel team in Redmond assures me that it includes everything in Enterprise E3.
These are the versions that an Exceller should never consider:
Never consider Office 365 Enterprise/E1. This $8 a month plan offers Office on five phones or tablets. This is not the real Excel. Anyone beyond a casual user will not be able to function with this.
Office 2019 is already obsolete. It does not have any features introduced in the last nine months of Excel 2018 nor anything released in Office 2019. Avoid these at all costs: Office 2019 Home & Student. Office 2019 Home & Business. Office 2019. You will be missing: Artificial Intelligence with Ideas, Geography Data Types. Stock Data Types. Exchange Rates. Awesome new functions like SORT, SORTBY, FILTER, UNIQUE, RANDARRAY, and SEQUENCE.
If you need the cool Excel tools like Inquire and Power Pivot, do not consider Office 365 for Business, or Office 365 Business Premium. These plans at $8.25 a month and $12.50 a month do not include the power tools for Excel.
If you need the cool Excel tools like Inquire and Power Pivot, do not consider Office 365 Home nor Office 365 Personal as your only version of Excel. These plans at $99.99 per year or $69.99 per year do not include the power tools for Excel. You can probably survive if you have Office 365 ProPlus at work and Office 365 Home at home.