This feature is demonstrated in Lesson 3-8 of our Essential Skills for Windows course.

Get Excel 2016 Mac Version Has

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

Get Excel 2016 Mac OS X Version

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

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

The list below is not a complete analysis of every difference between the Windows and Mac versions.

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

Important: Microsoft release regular updates that may implement missing features or change the way that Excel 2019 behaves.

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

Features available in Excel 2019 for Windows that are not available in Excel 2019 for Mac Default file location setting The Windows version of Excel 2019 enables you to set a default location for saving your files.

This feature is demonstrated in Lesson 1-8 of our Essential Skills for Windows course.

Automatic Flash Fill The Windows version of Excel 2019 tries to automatically detect when you are entering values that could be filled down and automatically uses Flash Fill where appropriate.

The Mac version never automatically uses Flash Fill, but you can invoke it manually when you want it.

This feature is demonstrated in Lesson 2-18 of our Essential Skills for Windows course.

Autosaved Versions of a workbook The Windows version of Excel 2019 automatically saves draft copies of your workbooks as you work, enabling you to retrieve an older version of a workbook even if you didnt save your changes.

This feature is demonstrated in Lesson 1-10 of our Essential Skills for Windows course.

Quick Analysis The Windows version of Excel 2019 shows a smart tag below selected cells that enables you to quickly create totals, charts, tables and sparklines.

This feature is demonstrated in Lesson 1-9 of our Expert Skills for Windows course.

The Mini Toolbar The Windows version of Excel 2019 shows a small toolbar when text is selected, allowing you to easily change font styles, sizes and colors.

Multi-item Clipboard The Windows version of Office 2019 includes a multi-item clipboard that allows you to copy and paste several different things at the same time.

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

This feature is demonstrated in Lesson 3-7 of our Essential Skills for Windows course.

Redo drop-down menu The Windows version of Excel 2019 offers a drop-down menu for both the Undo and Redo options, enabling multiple actions to be quickly undone or redone.

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

Get Excel 2016 For Mac