MICROSOFT EXCEL 2019 (WINDOWS)

Product Information "Microsoft Excel 2019"

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

CONCAT

This new function is an improved version of the CONCATENATE function. First of all, it is shorter and easier to type. In addition, it also supports references to a range in addition to cell references.

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 locate all instances.

MAX.MORE.IF

This function returns the largest number in a range that meets one or more criteria.

MIN.MORE.IF

This function is similar to MAX.MORE.IF, but returns the smallest number in a range that meets one or more criteria.

SWITCH

This function evaluates an expression against a list of values in order and returns the first corresponding result. If it does not find a corresponding result, it returns the specified alternative value.

TEXT.JOIN

This function joins the text of multiple ranges, separating each element with a delimiter specified by the user.

New charts

Advanced visual elements

Scalable Vector Graphics (SVG)

You can enhance the visual impact of documents, worksheets, and presentations by inserting SVG (Scalable Vector Graphics) elements with applied filters.

Slide with examples of SVG filters

Convert SVG icons into shapes

You can transform all SVG icons and images into Office shapes to change their color, size or texture.

Insert 3D models to see everything in the right perspective

Use 3D to enhance the visual and creative impact of your workbooks. Just insert a 3D model and then rotate it 360 degrees.

Pen input improvements

New pen input effects

Customizable and portable pen sets

New Pen Input Playback button

Handy lasso selection

Convert pen drawings into shapes

Use the Surface pen to select and edit objects

Improved accessibility features

Useful sounds that improve accessibility

Easier sharing

Insert recent links

View and restore changes in shared workbooks

Quickly save to recent folders

General improvements

Precision selection

Quick access to superscript and subscript formats

Improved autocomplete

New themes

Breaking down language barriers

Support for CSV format (UTF-8)

Pivot table improvements

Automatic relationship detection

Creation, editing and deletion of custom measures

Automatic time grouping

Pivot chart drill-down buttons

Searches in the pivot table

Smart renaming

Numerous usability improvements

Multi-selection data filter

Faster OLAP pivot tables

Greater query efficiency

Reduction in the number of queries

Smarter caches

Updates to Power Pivot

Save the relationships diagram view as an image

Faster and more accurate data relationships with the improved Edit Relationship dialog

Power Pivot - Improved Edit Relationship dialog

Selecting tables with keyboard navigation

Selecting columns by moving between columns

Automatic suggestion of the column with the same name in both tables

Fixes that improve the overall modeling user experience

Publish to Power BI

New and improved connectors

Improved transformations

General improvements

System requirements:

Operating system: Windows 10 and Windows 11

RAM: at least 2 GB of RAM

Hard disk: at least 3 GB of available memory

Display: at least 1.024 * 768 pixels resolution

Graphics card: DirectX 10 support is required for the GPU-accelerated interface

Browser: the current version of Internet Explorer, Chrome, Firefox, Microsoft Edge or Safari

.NET version: At least .NET 3.5