The arrival of new 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 replaces 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.

Professional charting with new charts

Another great addition with 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.

Enjoy the improved file tab interface with 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 while also having the ability to create an ordinary blank worksheet to get the job done from scratch.

Templates cover a broad variety of topics and offer unique designs 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.

“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.

Improvements to digital ink

Most of the Office 2019 applications have gotten improvements to digital inking, and Excel isn’t an exception. A new, fully customizable set of digital tools such as pens, pencils, and highlighters have been added to the app. Draw or write your ideas and comments directly in your spreadsheet, or highlight parts by hand.

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 your ink drawings with others.

The Excel-specific feature known as Ink Equation also allows you to use handwritten math equations and have them implemented in your workbook.

Save time with the SmartArt gallery

Excel 2019 introduces a SmartArt feature which gives access to high quality, customizable visual elements to users. You could almost call them mini-templates for different parts of your spreadsheet. These assets consist of shapes, lists, process charts, cycle charts and hierarchy charts to show item relations, as well as relationship charts, matrixes, and pyramids.

Better accessibility

Excel 2019 introduces a feature to locate accessibility problems. The Accessibility Checker allows you to get suggestions and enforce them into your document with one click of a button. It proposes adjustments with the goal of making sure that your work is without difficulty readable and editable.

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. In shared workbooks, you can review and restore the changes other people made to the file, allowing you to easily correct or retrieve parts that were modified.

A highly requested new feature is saving to recent folders. You’ll always see a list of your recently used folders where you can quickly save your document to.

 System Requirements

• • Memory: 2GB of RAM with  Windows; 4GB with macOS
• • Computer Processor: 1.6GHz + with Windows; Intel processor for macOS
• • Display: 1280 x 768 resolution with Windows; 1280 x 800 with macOS
• • Operating System: Windows 10 or Newer for Windows; 1 of the 3 most recent versions of macOS
• • Browser: New versions of Microsoft Edge, Internet Explorer, Safari, Chrome, or Firefox
• • Internet: A stable internet connection