Webinar Details $199
- Webinar Date: December 18, 2025
- Webinar Time: 12:00 pm - 1:40 pm EST live
- Webinar Length: 100 Minutes
- Guest Speaker: Derek Henry
- Topic: Software, Business Administration, Business Skills, Taxation and Accounting, Purchasing
- Credit: CPE 2.00, ATATX 1.50, ATAAA 1.50, ATAOP 1.75, IAAP 2.00, ISM 1.50, QPANJ 2.00, ATAPU 1.50
-
Are you still inputting Excel formulas one cell at a time? If you haven’t explored what’s new in Excel over the past few years, you’re missing out on powerful, time-saving features that can dramatically improve your workflow. Modern Excel offers a suite of dynamic functions designed to simplify your tasks, enhance accuracy, and make your spreadsheets more intelligent.
In this webinar, you’ll discover how to leverage Excel’s new dynamic array functions, which can automatically spill results across multiple cells—eliminating the need for repetitive formulas. You’ll also learn updated methods for referencing cells, explore underused but powerful functions, and even create your own custom functions to solve more complex problems. Whether you're a seasoned Excel user or looking to expand your capabilities, this session will unlock new efficiencies and possibilities in your spreadsheets.
Your Benefits for Attending:- Learn how to correctly use modern referencing symbols in Excel for more efficient formula creation
- Discover powerful but often overlooked Excel functions that can simplify your work
- Understand and apply dynamic array formulas to reduce redundancy and enhance your data analysis
- Gain practical tips on creating custom functions to handle advanced or unique spreadsheet needs
- Explore how dynamic functions can evolve with your dataset, minimizing manual updates
This session is ideal for professionals who want to streamline their Excel processes, reduce errors, and gain more control over how their data behaves. If you work with spreadsheets regularly, these new functions can transform the way you work.
Level: Intermediate
Format: Live webcast
Instructional Method: Group: Internet-based
NASBA Field of Study: Computer Software & Applications (2 hours)
Program Prerequisites: None
Advance Preparation: None
-
Derek Henry, CPA, CFE
Derek is an accomplished speaker, trainer, consultant, and developer with over 20 years of experience in public accounting, corporate accounting/finance, and software pre-sales. Over that time, he has taught, managed, and mentored hundreds of people on how to work with more efficiency, accountabilit [...]
CPE Credit
Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or training@auroratrainingadvantage.com.
ATATX Credit
Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.ATAAA Credit
Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.ATAOP Credit
Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.IAAP Credit
Aurora Training Advantage has reviewed the content of this program and believes it aligns with the CAP Body of Knowledge. We estimate this program may qualify for 1 recertification point(s), based on 1 point per 1 hour of eligible training. Final determination of applicability rests with the CAP designee, who is responsible for documenting alignment for recertification purposes.
ISM Credit
This program may be used for Continuing Education Hours (CEH) toward recertification for programs offered by the Institute for Supply Management®, including the Certified Professional in Supply Management® and Certified Professional in Supplier Diversity®.
QPANJ Credit
Qualified Purchasing Agent - New Jersey
ATAPU Credit
Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in purchasing.