You’ll learn about the new features and capabilities offered in Excel 2019 in this on-demand webcast presented by Excel expert David Ringstrom, CPA. Many users sit out one or more versions of Excel, so David will highlight the features added in Excel 2016 and 2013 as well. If you’re already using Excel 2019, you’ll learn how to take advantage of new capabilities. Or, if you’re considering moving to Excel 2019, the presentation can help you determine if it’s right for you. David also will compare Excel 2019 to the subscription-based Office 365 version of Excel, which, unlike perpetually licensed products such as Excel 2019, sometimes evolves as often as monthly.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. He draws your attention to any differences in the older versions of Excel (2016, 2013, and earlier) during the presentation as well as in his detailed handouts. In addition, David provides an Excel workbook that includes most of the examples used in the course. You’ll also discover some features only available in Office 365, but not in Excel 2019.

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 Would Be Interested in This Course:

Practitioners who wish to learn about the new features in Excel 2019 or those who are considering moving from an earlier version to this latest version.

Topics Covered:

• Illustrating financial statements with the Waterfall chart in Excel 2016 and later.
• Visualizing data with a Funnel chart in Excel 2019 and Office 365.
• Streamlining the decision-making process with the IFS function in Office 365.
• Surfacing hidden Excel commands instantly by way of the Tell Me feature in Excel 2016 and later.
• Exploring the Forecast Sheet feature in Excel 2016 and later that can extrapolate trends based on existing data in your spreadsheets. 
• Converting an obsolete .XLS workbook into the modern .XLSX or .XLSM file formats.
• Jump-starting pivot tables by way of the Recommended PivotTables feature in Excel 2013 and later.
• Using the Sunburst chart in Excel 2016 and later for displaying hierarchical data in a circular chart.
• Modernizing tasks that involve combining text with the CONCAT function in Excel 2019 and later.
• Joining text together with space or other characters with the TEXTJOIN function in Excel 2019 and later.
• Preventing pivot tables from automatically resizing columns when you refresh or filter the data.
• Unearthing worksheet functions with the AutoComplete feature in Excel 2016 and later.