K2's Dynamic Arrays in Excel
Monday, June 15, 2026
Noon-1 p.m. Central
1 CPE (1 non-technical)
Course code: 26WA-3420
View pricing
Dynamic arrays can be a tremendous time-saver in Excel, but most business professionals remain unaware of what should be a commonly used tool. With dynamic arrays you can reduce the time you spend creating and updating formulas and improve your accuracy at the same time. You can also take advantage of some innovative features associated with dynamic arrays to automate many calculations and data entry tasks. If you've yet to discover dynamic arrays, make plans to participate in this session to learn how you can take advantage of this terrific feature. If you're ready to transform your data into actionable insights and finally get the reports you need, this session is your game-changer. Join us and take control of your QuickBooks Online reporting like never before!
Major subjects
-
Differentiating between dynamic arrays and traditional Excel formulas.
-
Identifying which functions support dynamic arrays.
-
Using dynamic arrays to link data from external data sources.
Learning objectives
-
Compare dynamic arrays to traditional formulas.
-
Use dynamic arrays to automate traditional calculations.
-
Identify examples of how you can use dynamic arrays to access external data.
Who should take this program?
- Business professionals seeking to take full advantage dynamic arrays.
Pricing
|
Standard Member Fee |
$39.00
|
 Standard Nonmember Fee |
$39.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$39.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Instructor
Tommy Stephens, CPA, CITP, CGMA
Location
Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (1.0)
Level
Intermediate
Format
Group Internet Based
Sponsor
NASBA ID#: 107810
Prerequisites
Prereq.
Fundamental knowledge of computer operations
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business
days before the event start date.
Learn more
Search CPE catalog
