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.
Learning Objectives
  • Identify what the IFS worksheet function will return in noncompatible versions of Excel.
  • Explore the functionality the Flash Fill feature offers.
  • Identify the chart form in Excel 2019 and Office 365 that displays data geographically.
Last updated/reviewed: May 4, 2022
3 Reviews (13 ratings)

Reviews

4
Member's Profile
Good info. Print Screen + crop is an odd choice when we have paste picture and snip tools (not to mention what's cropped remains hidden and could embarrass someone if revealed). I really like the new functions and hope I can find a use for them. I think the new dynamic array stuff is not yet available on my 365 because it didn't work.

4
Member's Profile
Good class with insights into different and newer features. Thanks for the fun...

4
Anonymous Author
Nice and quick overview of certain Excel features. Good tips

Prerequisites
Course Complexity: Intermediate

Prerequisite: Basic Proficiency with Excel

Advanced Preparation: None

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Best and Worst Features of Excel 201911:11
  MAXIFS Function (2019+)9:26
  IFS Function (2019+)6:34
  SWITCH Function (Excel 2019+)10:40
  Map Charts (Excel 2019+)10:41
  Threaded Comments (Office 365)8:05
Continuous Play
  Excel Efficiency: Best and Worst Features of Excel 201956:37
Supporting Materials
  Slides: Excel Efficiency: Best and Worst Features of Excel 2019PDF
  Workbook: Excel Efficiency: Best and Worst Features of Excel 2019XLXS
  Excel Efficiency: Best and Worst Features of Excel 2019 Glossary/IndexPDF
Review And Test
  REVIEW QUESTIONSquiz
 FINAL EXAMexam