Description

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 advantages 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 Microsoft 365 version of Excel, which, unlike perpetually licensed products such as Excel 2019, sometimes evolves as often as monthly. Topics Covered:
  • Illustrating financial statements with the Waterfall chart in Excel 2016 and later.
  • Visualizing data with a Funnel chart in Excel 2019 and Microsoft 365.
  • Streamlining the decision-making process with the IFS function in Microsoft 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.
Learning Objectives:
  • State what the IFS worksheet function will return in noncompatible versions of Excel.
  • State the functionality the Flash Fill feature offers.
  • Identify the chart form in Excel 2019 and Microsoft 365 that displays data geographically.