The 10 Best (and 3 worst) Features in Excel 2019 (Completed)

In this presentation, Excel expert David Ringstrom, CPA, focuses on the 10 best and 3 worst new features in Excel 2019. The presentation focuses on new features that don’t exist in previous perpetual licensed versions of Excel. Office 365 users had early access to all features released in Excel 2019. Learn how to take advantage of new capabilities if you’re already using Excel 2019, or determine if you should move from an earlier version to the latest version. David also compares Excel 2019 to the Office 365 version of Excel, which is about to receive a complete overhaul of its calculation engine that will markedly differentiate it from all previous versions of Microsoft Excel.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Who Should Attend
Practitioners using Excel 2019 or considering upgrading to Excel 2019.

Topics Covered

• Deselecting one or more cells from within a selection of cells without having to start over again with the selection process
• Preventing pivot tables from automatically resizing columns when you refresh or filter the data
• Learning about the MAXIFS function available in certain versions of Excel
• Learning about the MINIFS function available in Excel 2019 and Office 365
• Streamlining the decision-making process with the IFS function in Office 365
• Creating structured decision-making formulas with the SWITCH function
• Combining text together with the CONCAT function, which breaks away from the constraints of Excel's CONCATENATE function
• Concatenating text in new ways with the TEXTJOIN function
• Uncovering worksheet functions by way of the AutoComplete feature that allows you to identify functions based on letters that appear anywhere in the function name
• Mapping geographic data with just a couple of mouse clicks
• Visualizing data with a Funnel chart, which is available in Excel 2019 and Office 365
• Noticing how Excel 2019 and Office 365 no longer hector you as to whether you wish to save a .CSV file, especially when you've already saved it
• Overcoming user interface annoyances by making simple adjustments to Excel's options
• Exploring the threaded comments feature available in Office 365 (but not Excel 2019 and earlier)
• Investigating the Dynamic Array functionality rolling out in Office 365 that represents the first significant overhaul to Excel's calculation engine in 30 years, which isn't available in Excel 2019

Learning Objectives

• Define how you can easily map geographic data
• Identify the number of criteria pairs that you can specify in the MAXIFS function
• Identify which versions of Excel offer the Funnel Chart feature

Level
Basic

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Software & Applications (1 hour)

Program Prerequisites
Practitioners using Excel 2019 or considering upgrading to Excel 2019.

Advance Preparation
None