In this practical webinar, you will learn techniques from Excel expert, David Ringstrom, CPA, to bring you up to speed on new features in Excel 2019. Because many Excel users sit out one or more versions, this presentation also highlights features added in Excel 2016 and 2013, as well as the new capabilities offered in Excel 2019. This webinar will assist you in determining if you should move up from an earlier version of Excel.
You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. Any differences in the older versions of Excel (2016, 2013, and earlier) will be highlighted during the presentation, as well as in detailed handouts. You’ll also discover some features only available in Office 365, but not in Excel 2019. You will receive an Excel workbook that includes most of the examples used during the webinar.
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.
You will learn how to:
- Use the Icons command in Office 365 to add emoji-style icons within spreadsheets
- Prevent pivot tables from automatically resizing columns when you refresh or filter the data
- Streamline the decision-making process with the IFS function in Office 365
- Use Box and Whisker charts in Excel 2019 and later to show data by quartiles and to identify outliers
- Visualize data with a Funnel chart in Excel 2019 and Office 365
- Reveal worksheet functions with the AutoComplete feature in Excel 2019 and later
- Edit .PDF documents in Word 2013 and later—useful for unlocking data you wish to edit in Excel
- Map geographic data with just a couple of mouse clicks
- Describe the MINIFS function available in Excel 2019 and Office 365
- Embed 3D models into Office 365 spreadsheets while seeing what’s viewable in other versions of Excel
- Use the Treemap chart in Excel 2019 and later to visualize data based on relative size
- Surface hidden Excel commands instantly by way of the Tell Me feature in Excel 2019 and later
Upon course completion, you will be able to:
- Determine the most effective means for converting an obsolete .XLS workbook into modern .XLSX or .XLSM file formats
- Identify the chart form in Excel 2019 and Office 365 that displays data geographically
- Determine the closest alternative to the SWITCH worksheet function that is compatible in all versions of Excel
Suggested Audience: 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.
Program Level: Intermediate
Credit Type: Self-Study credit (Please note that to receive Self-Study credit you will need to complete a final exam after viewing the webinar.)
Field of Study: Computer Software & Applications