Virtual
K2’s Mastering Advanced Excel Functions 26-27
Date: June 8, 2026
Time: 8 – 11:30 a.m. PT
CPE: 4
Member
$175.00
Nonmember
$229.00
Members, log in to access your discount.
Overview
Are you ready to move past Excel’s simple functions, such as SUM? If so, participate in this session to learn about many of Excel’s advanced functions, including XLOOKUP, SUMIFS, and SWITCH. You’ll also learn about the revolutionary Dynamic Arrays feature.
Product Code
1000004803-138445
Credit Type
CPE: 4CPE-Non-Technical: 4NASBA Field of Study
Computer Software & Applications
Level of Difficulty
Intermediate
Prerequisites
Fundamental knowledge of Excel 2019 or newer
Advance Preparation
None
Learning Objectives
Major Subjects
- Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays
- How to use “legacy” features and functions such as AGGREGATE
- Creating effective forecasts in Excel
Other Dates
Faculty
Thomas G. Stephens Jr
Tommy Stephens received a Bachelor of Science in Business Administration degree (Major in Accounting) from Auburn University in 1985. In 1992, he earned a Master of Science degree (Major in Finance) from Georgia State University in Atlanta. Presently, Tommy is a Certified Public Accountant, a Certified Information Technology Professional, and a Chartered Global Management Accountant. During his professional career, Tommy has gained valuable ex...
More about Thomas G. Stephens JrAdditional Details
This prerecorded broadcast is provided through our partnership with K2 Enterprises. Instructor will be available via the chat feature.