What’s New in Excel: Hands-On with the Latest Features Webinar
Overview
Stay up-to-date on the latest Excel updates with this interactive 2-hour webinar. You will be guided through using the newest features and enhancements in Excel for both desktop and web use. These features include VBA, macros, OLE, XLSM, UDF, ML, and machine learning. Whether you're a skilled Excel user or just someone looking to streamline your workflow, this webinar will help you unlock new possibilities by walking you through hands-on exercises while using real-world applications. We will discuss:
- Improvements made to conditional formatting for better data visualization
- The newest features and the opportunities they create
- Improving data analysis efficiency and streamlining workflows
Objective
To teach CPAs and other financial professionals how to utilize the latest updates and features of Excel in an effort to improve their professional capabilities, streamline their workflow, and save time.
Emphasis
- Improved search feature
- Dynamic arrays updates for smarter data handling
- Image import feature
- GROUPBY and PIVOTBY: New functions for creating summary reports with a single formula (powerful alternative to pivot tables)
- Checkboxes: Now generally available for simple checklists and more advanced lists
- LAMBDA function: Create your own custom functions for commonly used formulas
- Focus cell feature for improved navigation
- Share links to Sheet views in Excel for web
This course is included in the following subscriptions:
Need more than one course? Upgrade to a subscription and save.
View Subscriptions