MICROSOFT EXCEL 2019 (MAC)

New features

The Excel development team continues to make improvements to the application and its native functions.

CONCAT

This new feature is similar to concatenating, but better. First of all, it's shorter and easier to type. But it also supports range references, in addition to cell references. More information about Concat.

MORE.IF

Tired of typing complicated nested IF functions? The MORE.IF function is the solution. With this function, conditions are tested in the order specified by the user. If the test is passed, the result is returned. If none of the conditions are met, it is also possible to specify to identify all instances. More information on the MORE.IF function.

SWITCH

This function evaluates an expression against a list of values in order and returns the first matching result. If it does not find a matching result, it returns the specified alternate value. More information on the SWITCH function.

The assistant can't proceed with the translation as the provided text "TESTO.UNISCI" doesn't contain any specific context or meaning in Italian. Please provide a valid and meaningful sentence or text.

This function combines the text of multiple ranges, separating each element with a delimiter specified by the user. More information on the TEXT.JOIN function.

New charts

Map Charts

It is possible to create a map chart to compare values and display categories in various geographical areas. This type of chart is useful when the data includes geographical areas, such as countries/geographical areas, states, counties, or postal codes. Watch a quick map chart video.

Excel Map Chart with Value Data

Funnel charts

Funnel charts display values for multiple stages of a process. For example, you can use a funnel chart to visualize the number of sales opportunities in a sales pipeline. Typically, the values gradually decrease, giving the chart the appearance of a funnel.

Funnel chart showing a sales pipeline, with the stages in the first column and the values in the second.

General Improvements

Workbook Statistics

Workbook Statistics provides an overview of the contents of a workbook to make it easier to discover them. It is found on the multifunction bar, in the Review tab.

Workbook Statistics Dialog Window

Precision selection

Has it ever happened that you selected too many cells or the wrong cells? Now it is possible to deselect unwanted cells without having to start over.

Temporal Sequence Filters

To examine the pivot table data related to certain years, quarters, months, or even days, easily filter a pivot table with a timeline filter by sliding the date range.

Customize the multifunction bar

The customization of the multifunction bar in Excel 2019 for Mac has been extended. It is possible to set preferences for the quick access bar and customize the multifunction bar in the desired way. You can create default tabs or customized tabs and groups in which to include the most frequently used commands.

View and restore previous versions

Now it is possible to go back and view previous versions of a work folder, restoring one if necessary.

Breaking down language barriers

Translate words, phrases, or sentences into another language with Microsoft Translator. You can do this from the Review tab of the ribbon.

Translator button with an English word and its French translation

One-click corrections for accessibility issues

Accessibility verification has further improved thanks to updated support for international standards and useful tips to make documents more accessible.

System Requirements:

Processor: Dual-core processor/recent macOS

Operating system: macOS Monterey (12), macOS Big Sur (11), macOS Catalina (10.15), and macOS Mojave (10.14).

Memory: 4 GB of RAM for Mac

Hard disk space: 10 GB for Mac

Screen: 1280 x 800 for Mac

Graphics: A DirectX 10 graphics card is required for hardware acceleration of PC graphics.