If you're upgrading to Excel 2019 for Mac from Excel 2016 for Mac, you'll still have all the features you're used to—and you'll notice a few new ones as well!
We continue to make improvements with Excel, and its native functions.
This new function is like CONCATENATE, but better. First of all, it's shorter and easier to type. But it also supports range references, in addition to cell references.
Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else "catch all" if none of the conditions are met.
This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the "else" is returned.
This function combines text from multiple ranges, and each item is separated by a delimiter that you specify.
You can create a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Watch a quick map chart video here.
Funnel charts show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel.
Workbook Statistics provides an overview of the content of a workbook, to help you more easily discover its contents. You'll find it on the Ribbon, on the Review tab.
Ever selected too many cells or the wrong ones? You can now deselect extraneous cells without having to start over.
Want to take a look your PivotTable data across years, quarters, months or even days? Easily filter a PivotTable with a timeline filter by sliding the date range.
Customize the Ribbon
We've extended Ribbon customization to Excel 2019 for Mac. You can set preferences for the Quick Access toolbar, and personalize the Ribbon the way you want it. You can change default tabs, or create custom tabs and custom groups to contain your frequently used commands.
See and restore previous versions
You can now look back and see previous versions of a workbook, and even restore one if you like.
Break the language barrier
Translate words, phrases, or sentences to another language with Microsoft Translator. You can do this from the Review tab in the ribbon.
One-click fixes for accessibility issues
The Accessibility Checker is better than ever with updated support for international standards, and handy recommendations to make your documents more accessible.