In this informative webcast, Excel expert David Ringstrom, CPA, uncovers new features offered in Excel 2019. Many users sit out one or more versions of Excel, so David also highlights features added in Excel 2016 and 2013. If you're already using Excel 2019, you'll discover how to take advantages of its new capabilities. If you're considering a move to Excel 2019, the presentation can help you determine if it's right for you. In addition, David compares 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. David 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. You'll also discover some features only available in Office 365, but not Excel 2019. 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.
Why should you attend?
- Recall the most effective means for converting an obsolete .XLS workbook into modern .XLSX and .XLSM file formats.
- Identify the chart form in Excel 2019 and Office 365 that displays data geographically.
- Identify the closest alternative to the SWITCH worksheet function that's compatible in all versions of Excel.
Areas Covered in the Session:
- Embedding 3D models into Office 365 spreadsheets while seeing what's viewable in other versions of Excel.
- Mapping geographic data with just a couple of mouse clicks.
- Overcoming user interface annoyances by making simple adjustments to Excel's options.
- Learning about the MAXIFS function available in certain versions of Excel.
- Joining text together with space or other characters with the TEXTJOIN function in Excel 2019 and later.
- Using the Icons command in Office 365 to add emoji-style icons within spreadsheets.
- Streamlining the decision-making process with the IFS function in Office 365.
- Previewing the dynamic arrays functionality being rolled out over a series of months in Office 365.
- Deselecting one or more cells from within a selection of cells without having to start over again with the selection process.
- Visualizing data with a Funnel chart in Excel 2019 and Office 365.
- Preventing pivot tables from automatically resizing columns when you refresh or filter the data.
- Replacing unwieldy nested IF formulas with the SWITCH function in Excel 2019 and later.
Who can Benefit:
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.