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