Instructor for this course
more

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: November 23, 2019

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 .
Course Syllabus
INTRODUCTION AND OVERVIEW
  11:11Best and Worst Features of Excel 2019
  9:26MAXIFS Function (2019+)
  6:34IFS Function (2019+)
  10:40SWITCH Function (Excel 2019+)
  10:41Map Charts (Excel 2019+)
  8:05Threaded Comments (Office 365)
Continuous Play
  56:37Excel Efficiency: Best and Worst Features of Excel 2019
Supporting Materials
  PDFSlides: Excel Efficiency: Best and Worst Features of Excel 2019
  XLXSWorkbook: Excel Efficiency: Best and Worst Features of Excel 2019
  PDFExcel Efficiency: Best and Worst Features of Excel 2019 Glossary/Index
Review And Test
  quizREVIEW QUESTIONS
 examFINAL EXAM