12/04/2024
11 am PT / 12 pm MT / 1 pm CT / 2 pm ET
*approximate length: 45 minutes to 1 hour
Presenter: David Ringstrom, CPA
Excel for Microsoft 365 is a subscription-based version of Excel, which means new features appear on an ongoing basis. In this presentation, author and Excel expert David Ringstrom, CPA brings you up to speed on the latest improvements in Excel for Microsoft 365. David will explain how Microsoft 365 users are subdivided into channels, which means certain users may not see some new features until months after others do. The topics below show a typical assortment of what will be covered. David always updates the presentation right before presenting the material so that you can be up to date on the latest changes and improvements in Excel for Microsoft 365.
David is the author of “Exploring Microsoft Excel's Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features”. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.
Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.
Who should attend: Professionals seeking to stay up to date on new features and functions in Excel for Microsoft 365.
Topics typically covered:
- Assemble a new collection of data by specifying the rows or columns to extract from another data set with the CHOOSEROWS and CHOOSECOLS functions
- Filtering based upon two or more conditions with the FILTER function in Excel 2021 and Microsoft 365
- Crafting self-resizing formulas with the new Spilled Range Operator in Excel 2021 and Microsoft 365
- Stack different ranges of cells vertically or horizontally with the VSTACK and HSTACK functions
- Streamline formula writing by creating nicknames for repetitive values with the LET function in Microsoft 365
- Splitting text into multiple cells based upon a separator that you specify with the TEXTSPLIT function
- Linking charts to dynamic array results to create self-updating charts without using programming code
- Embedding images into worksheet cells with the IMAGE function instead of having the graphics float above the worksheet.
- Exploring the risks and benefits of participating in the Beta Channel program in Excel for Microsoft 365.
- Navigating through workbooks and identifying non-blank worksheet cells with the Navigation task pane in Microsoft 365.
- Retrieving geographic information directly into Excel spreadsheets with the Geography data type.
- Displaying subsets of data dynamically by way of the new FILTER worksheet function.
Learning objectives:
- Identify the section on Excel's Home menu where the Microsoft Insider command appears, if available
- Recognize which version(s) of Excel offers the FILTER function
- Identify the feature that allows you to separate data into multiple columns
Level: Intermediate
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.