Microsoft Excel 2019 Features

“Welcome to Excel” tour

Microsoft now provides beginners with a Welcome to Excel tour upon launching the application. This tour is always available from the File menu, allowing you to return to it whenever you need a refresher of some of the new features found in Excel 2019. This tour is especially useful if you’ve just started using newer generations of Microsoft Office. The tour includes detailed instructions on how to use features such as Flash Fill and Quick Analysis, and even introduces you to the creation of charts.

Additionally, with Excel’s new version, Microsoft has aimed at putting the users in control of the work they’re doing. As a result of this decision, the new display and layout of the program are easy to read, navigate, and use.

New and improved functions

It’s impossible to think of a new Excel release without new functions. Excel 2019  received new, beneficial functions that help you accelerate your work speed and make your experience with the software more pleasant. In total, six new functions have been added to Excel in the 2019 release, however, some of these are only improvements to previously existing functions.

These new functions boost productiveness and make it less difficult and time-consuming to get work done within Excel. Functions make your work faster, even if you’re managing large databases that would otherwise require a lot of time and expert attention.

The new functions include the following:

• • CONCAT: This new function is like the already existing CONCATENATE, but better. To begin with, it is shorter and less difficult to write. Mainly, it supports cell references, as well as range references.
• • IFS: This new function acts as a test to confirm that one or more conditions are met. If so, it returns a value that directly corresponds to the initial true condition. As well, the new IFS function takes the place of many nested IF statements, making it a lot easier to read multiple conditions.
• • MAXIFS: This new function produces the maximum value among a number of specific cells.
• • MINIFS: Similar to the MAXIFS function, this one produces the minimum value among a number of specific cells.
• • SWITCH: This new function takes an individual value and puts it against a list of other values, producing the first corresponding match in that list.
• • TEXTJOIN: This new function allows users to combine text from a range of multiple cells, separating them by delimiters that you set.

Use new charts to visualize data

Another great addition to the new version of Excel is the ability to insert new chart models directly onto spreadsheets. Two entirely new charts come with Excel 2019, under the names Map charts and Funnel charts.

The Map chart is very self-explanatory, you are able to create a chart that displays categories and volumes all through geographical places. This includes international locations, states, counties or even postal codes.

The Funnel chart indicates values as the duration of your data progresses. Due to the fact that the values become lower or higher as time passes, the bars of your statistics start to resemble a funnel, which explains the name of this chart type.

Digital ink improvements

Many Office applications have seen improvements to digital inking. A new, fully customizable set of digital pens, pencils, and highlighters help you draw out your ideas or highlight parts of your projects. There’s an Excel-specific feature known as Ink Equation, which allows you to use handwritten math equations and have them implemented in your workbook.

Apply visual effects to your ink and make it either stand out more or make it subtle. Convert your ink drawings into shapes and use an on-hand feature called Ink Replay to rewind and play how your inking was made. This allows you to share the flow and process of inking with others.

Templates

Whenever you make a new document, you have the ability to pick from an extensive library of pre-built and installed templates in Excel. This doesn’t strip you from the ability to create an ordinary blank worksheet to get the job done from scratch, but can certainly help to give yourself a headstart.

Templates cover a broad variety of topics and offer unique designs and solutions to help you get started on a project much faster. Categories include finance templates, templates for tracking tasks or even planning events. You might even find templates with readily available charts and other elements.

More accessible than ever before

Excel 2019 introduces a feature to locate accessibility problems within your file. The Accessibility Checker allows you to overview suggestions pointers and enforce them into your document in a single click. It proposes adjustments with the goal of making sure that your work is without difficulty readable and editable for those who may have a hard time perceiving it without additional aid. Even if someone has disabilities that hinder with their ability to form a complete appreciation of your work, applying the suggested changes can help them in perceiving your document.

Easier, versatile sharing options

A feature called Shared with Me lets you access every OneDrive file that has been sent to you, without the need to find the actual email message it was attached with.

A highly requested new feature is saving to recent folders, which once accessed, opens up a list of your recently used folders where you can quickly save your document to. In your shared workbooks, you can review and even restore the changes other people have made to the file, allowing you to easily correct or retrieve parts that have been modified.

General improvements

With the new version of Excel, Microsoft has managed to fix some of the small nuances that customers regularly complained about. This includes better autocomplete, customizable themes, improved translating services, and better recovery methods for retrieving lost data.