Date: 12/17/2024
Time: 3:00 PM - 5:00 PM EST
CPE Credit: 2 hours

Maximize Excel: What's New in Microsoft 365
Presented by David H. Ringstrom, CPA
 
Event Date/Time: 02/10/23 12:00 PM Eastern
Duration: 100 minutes
 
In this presentation author and Excel expert David H. Ringstrom, CPA will get you up to speed on the latest additions to Microsoft 365.You'll see new features such as the Navigation task pane, self-updating stock quotes, brand new worksheet functions and much more. Microsoft pushes out updates to Microsoft 365 users in waves, so you may not have all of the functionality in this presentation today, but it will be arriving on your desk in the coming months.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
 
Microsoft 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 2021, Excel 2019, and so on.
 
Who should attend:
Practitioners seeking to state up to date with the latest improvements in Microsoft 365.
 
Topics 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.
 
• Create your own custom worksheet functions without writing any code in Microsoft 365 with the LAMBDA function.
 
• Documenting IF functions by using LET to assign nicknames to the inputs.
 
• Embedding images into worksheet cells with the IMAGE function instead of having the graphics float above the worksheet.
 
• Extracting text before or after a delimiter with the TEXTBEFORE and TEXTAFTER functions.
 
• Keep or remove rows from the start or end of an array with the TAKE and DROP functions.
 
• Linking charts to dynamic array results to create self-updating charts without using programming code.
 
• Moving LAMBDA functions between workbooks.
 
• Navigating through workbooks and identifying non-blank worksheet cells with the Navigation task pane in Microsoft 365.
 
• Splitting text into multiple cells based up on a separator that you specify with the TEXTSPLIT function.
 
• Stack different ranges of cells vertically or horizontally with the VSTACK and HSTACK functions.
 
• Streamline formula writing with by creating nicknames for repetitive values with the LET function in Microsoft 365.
 
Learning objectives:
• State where you can view LAMBDA functions available in a given workbook.
• Identify a circumstance where the LET function will return #NAME?.
• State which menu tab contains the Navigation task pane command.
 
 
Level:
Basic
 
Format:
Group: Internet-based
 
Instructional Method:
Live webcast
 
NASBA Field of Study:
Computer Software & Applications (2 hours)
 
Program Prerequisites:
 
 
Advance Preparation: