On Premise debate you take, its a fact that at this point there are two Excel 2016 versions out there, and Im not talking about Professional, Home and so on First theres Excel 2016 with constant updates but mostly those updates are bug fixes and security patches.

But then theres Excel 2016 that comes as part of Office 365 and this one is now Excel 2016 and a half.

At this point, those that are Office 365 subscribers get a better version of Excel or to be politically correct a newer version of Excel since this one also gets functionality updates and at the point that the next version of Excel will be available, those running Excel as part of Office 365 subscription will basically already have one Im not going to list all the differences between the two versions, you can get a more or less complete list of those here, Ill only give you a scenario where two new functions in the 365 version in my humble opinion make a world of difference.

Office 2016 Versus 365 How To Control Cookies

To find out more, including how to control cookies, see here.

This enables you to change the commands shown on the default ribbon tabs and to create entirely new ribbon tabs.

The Excel 2016 for Mac version has a reduced feature set and a radically different user interface to the Excel 2016 for Windows version.

Weve finally done this with the release of our Excel 2016 Essential Skills and Expert Skills books specifically for the Apple Mac OS X version of Excel 2016.

You can find out more about the new Apple books by clicking here.

It only lists the differences relating to the skills taught in our Excel 2016 for Windows and Excel 2016 for Mac OS X courses.

This information was true as of October 2017, but the product may have changed since this list was compiled.

This was changed via an update in June 2016 that enabled the Quick Access Toolbar and Ribbon to be customized.

If you are not using Office 365 you may still find that you are unable to customize the Quick Access Toolbar.

This feature is not included in the Mac version, but there are OS X add-ins available that provide this functionality.

The Mac version only offers the drop-down menu for the Undo option, meaning you must redo actions on at a time.

If you are not using Office 365 you may still find that you do not have the add-in store feature.

The Mac version does not allow new Color Sets and Font Sets to be created, so themes can only be created from the preset options.

This is used in many different places throughout the Excel application to show a preview of the effect an option will have when you hover the mouse cursor over it.

For example, hovering the mouse cursor over a Theme will preview how the Theme would look if it was applied.

This feature is not available in the Mac version, although workbooks can still be compared by using the Arrange feature.

This feature is not available in the Mac version of Excel 2016.

The Mac version displays a small print preview that cannot be zoomed.

Chart filters do not exist in the Mac version, but you can still change the data that is displayed within a chart by using the Select Data Source dialog.

Protected view disables editing and other features to protect you from viruses.

Office 2016 Versus 365 Drivers Are Available

The Mac version can only connect to SQL Server data sources by default, but 3rd party drivers are available that enable other data sources to be used.

This can be useful in complex workbooks with many interconnected worksheets.

Office For Mac 2016 Versus 365