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 didn’t save your changes. This feature is demonstrated in Lesson 2-18 of our Essential Skills for Windows course. The Mac version never automatically uses Flash Fill, but you can invoke it manually when you want it. 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. This feature is demonstrated in Lesson 1-8 of our Essential Skills for Windows course. This setting is not available in the Mac version.

The Windows version of Excel 2019 enables you to set a default location for saving your files. Features available in Excel 2019 for Windows that are not available in Excel 2019 for Mac This information was true as of October 2017, but the product may have changed since this list was compiled. Important: Microsoft release regular updates that may implement missing features or change the way that Excel 2019 behaves. It only lists the differences relating to the skills taught in our Excel 2019 for Windows and Excel 2019 for Mac OS X courses. The list below is not a complete analysis of every difference between the Windows and Mac versions. You can find out more about the new Apple books by clicking here. We’ve 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. The Excel 2019 for Mac version has a reduced feature set and a radically different user interface to the Excel 2019 for Windows version.įor many years Mac users have asked us to create a version of our best-selling Excel courses for the Mac version of Excel. You could be forgiven for thinking that the (confusingly named) Excel 2016 for Mac (suitable only for Apple computers) was “just the same” as Excel 2016 for Windows.

Microsoft excel 2019 for mac