(Information is Beautiful)

Untangling Excel versions

Excel 2013 upgrade by itself adds (these are just the BI ones):

  • PowerView dashboarding (ProPlus only)
  • Inquire (ProPlus only)
  • Quick Analysis tool (ProPlus only)
  • More data sources
  • Flash Fill
  • Slicers


BTW, there are no compatibility issues between Excel 2010 and 2013 files. You don’t even have to save it to an older version.


With Office 365 Enterprise plans, we can’t get a standard version of office, but if we could, here is the BI-specific difference:

Business intelligence: Explore different views of data with a click. Conduct a cross-tab analysis of large datasets for a 360° view. Predict trends by quickly charting historical trends. Scan spreadsheets for errors, hidden info, broken links, and inconsistencies. View audit trail of changes in spreadsheet.”





“Prerequisites: Requires Microsoft Office Professional Plus 2013 or Office 365 ProPlus.”




“The PowerPivot add-in for Excel 2013 is only available with Office Professional Plus 2013. You must choose the Office 365 ProPlus or Office 365 Enterprise trial for download and installation in order to use the PowerPivot add-in for Excel 2013.”

Also works with Excel 2010 as an add-in.


Data Explorer


“Requires Microsoft Office 2013

Also works with Excel 2010 as an add-in.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s