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 feature is an improved version of the CONCATENATE function. First of all, it's shorter and easier to type. Moreover, it also supports range references in addition to cell references.

MORE.IF

Tired of typing complex 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's also possible to specify to identify 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.IF, but it 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.

As an AI, I need the actual text to translate from Italian to English. Can you please provide the text?

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

New Charts

Advanced Visual Elements

Scalable Vector Graphics (SVG)

It is possible to 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

It is possible to 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 work folders. Just insert a 3D model and then rotate it by 360 degrees.

Improvements to pen input

New pen input effects

Customizable and portable pen set

New Playback Input Pen Button

Lasso selection at your fingertips

Converting pen drawings into shapes

Use the Surface Pen to select and edit objects

Improved accessibility features

Useful sounds that improve accessibility

Simpler Sharing

Insert recent links

View and restore changes in shared work folders

Save quickly in recent folders

General Improvements

Precision Selection

Quick access to superscript and subscript formats

Improved Auto-Completion

New themes

Breaking down language barriers

Support for CSV format (UTF-8)

Improvements to pivot tables

Automatic detection of relationships

Creation, modification and deletion of custom measurements

Automatic temporal grouping

Drill-down buttons of pivot charts

Searches in the pivot table

Smart Renaming

Numerous improvements for usability

Multiple Selection Data Filter

Faster OLAP Pivot Tables

Improved query efficiency

Reduction of the number of queries

Smarter Caches

Updates to Power Pivot

Saving the display of the relationship diagram as an image

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

Power Pivot - Improvement of the Edit Relationship dialog box

Selection of tables with keyboard movement

Selection of columns by moving between columns

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

Corrections that improve the overall user experience of modeling

Publish in Power BI

New and Improved Connectors

Improved Transformations

General Improvements

System requirements:

Operating system: Windows 10 and Windows 11

RAM Memory: at least 2 GB of RAM

Hard drive: at least 3 GB of available memory

Display: at least 1.024 * 768 pixel resolution

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

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

.NET Version: At least .NET 3.5