Microsoft Office 2016: The Complete Guide (2015)

COMPARISONS: EXCEL 2016 FOR WINDOWS & FOR MAC

The shortcuts for Microsoft Excel 2016 for Mac are now similar to Windows Keyboard shortcuts, that is you can now press Ctrl+V to paste instead of CMD+V which Mac-book pro users were used to. Microsoft Excel for Windows has the leading standards in spreadsheet application as it relates to document compatibility, functionality and features. This results in Microsoft Excel for Windows being the point of measurement for all existing spreadsheet or similar applications. Both interfaces have features that are different from each other. Microsoft Excel 2016 for Mac can create pivot tables automatically.

There are many changes to the appearance that are a part of the effort to get Microsoft Excel 2016 for Mac into line with the Microsoft Excel for windows version. Just like with the other new Office apps the number of ribbons has been reduced in Microsoft Excel 2016 for Mac.

Drawbacks Microsoft Excel 2016 for Mac

With the changing needs of individuals and businesses, everyday software designers have to be improving their products in an attempt to satisfy these needs. Although Microsoft Excel 2016 for Mac has been improved, there is more that users are seeking and with no doubt the Microsoft Office for Mac team will attempt to deliver. The drawbacks are listed below:

While Microsoft Excel 2016 for Mac boasts the ability to create pivot tables and further splice them by adding filters, pivot tables do not create pivot charts.

The Power pivot that exists in Microsoft Excel for Windows is not offered in the new Microsoft Excel 2016 for Mac.

Persons or organizations working with large dataset will have to await the arrival of Quick Analysis or Find All in the next update of the Microsoft Office Suite for Mac.