What's New Microsoft 365 in 2024 (Completed)

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 Covered

• Utilizing regular expressions (regex), which are sequences of characters that define search patterns for matching, locating, and managing text by way of the REGEXTEST, REGEXEXTRACT, and REGEXREPLACE functions
• Adding interactivity to worksheets with the Checkbox feature
• Documenting IF functions by using LET to assign nicknames to the inputs
• Leveraging the power of artificial intelligence in Excel with Microsoft Copilot
• Process data sets that exceed the 1,048,576 row limitation by using Python in Excel
• Automating repetitive tasks with Office Scripts
• Manipulating text with the TEXTBEFORE, TEXTAFTER, and TEXTSPLIT functions
• Reshaping data with array manipulation functions such as VSTACK, HSTACK, CHOOSECOLS, and CHOOSEROWS
• Linking charts to dynamic array results to create self-updating charts without using programming code
• Selecting or removing data from arrays or lists with the TAKE and DROP functions, respectively
• Rearranging data into columns or rows with functions such as TOCOL, WRAPCOLS, TOROW, and WRAPROWs
• Exploring the risks and benefits of participating in the Beta Channel program in Excel for Microsoft 365

Learning Objectives

• Demonstrate how to utilize regular expressions (regex) to match, locate, and manage text using the REGEXTEST, REGEXEXTRACT, and REGEXREPLACE functions
• Describe how to automate repetitive tasks with Office Scripts
• Recall how to process big data sets by using Python in Excel

Level
Intermediate

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
Prior experience with Microsoft Excel is recommended.

Advance Preparation
None