(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

http://office.microsoft.com/en-us/excel-help/what-s-new-in-excel-2013-HA102809308.aspx

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.”

http://office.microsoft.com/en-us/buy/microsoft-office-volume-licensing-suites-comparison-FX101825637.aspx

 

GeoFlow

http://office.microsoft.com/en-us/download-geoflow-for-excel-FX104036784.aspx

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

 

PowerPivot

http://office.microsoft.com/sites/preview/en-us/excel/download-powerpivot-HA101959985.aspx

“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

http://office.microsoft.com/en-us/excel/download-data-explorer-for-excel-FX104018616.aspx

“Requires Microsoft Office 2013

Also works with Excel 2010 as an add-in.

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s