Live Replay WebinarIntermediate level

K2’s Dynamic Arrays In Excel

Name: K2’s Dynamic Arrays In Excel
Price: 50.00 USD
Availability: InStock
Rating: 4.88 (8 reviews)

★★★★★ 4.9 · 8 attendee ratings

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.

CPE Credits1

Length50 min

Field of Study Computer Software and Applications

Instructor Tommy Stephens

Learning objectives

Upon completing this course, you should be able to:

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

Major topics

Differentiating between dynamic arrays and traditional Excel formulas Identifying which functions support dynamic arrays Using dynamic arrays to link data from external data sources

Who this is for

Business professionals seeking to take full advantage of dynamic arrays

Prerequisites: Fundamental knowledge of computer operations

What's included

Every registration comes with the course materials — yours to keep.

Course handout PDF
Demonstration & sample files XLSX

Course details

Recommended CPE credit: 1 — Computer Software and Applications
Field of study: Computer Software and Applications
Program level: Intermediate
Delivery method: Group Internet Based
Prerequisites: Fundamental knowledge of computer operations
Advance preparation: None
Length: 50 min
Course number: 26c-dyarrays
Provider: K2 Enterprises

CPE Today (Devmatics, LLC) 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 (Sponsor ID 167619). 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, nasbaregistry.org. For information about our refund, complaint, and program cancellation policies, see Company Policies or contact [email protected].

Every way to take this course

On its own

Live Replay Webinar Attend the next scheduled rebroadcast — full live CPE credit · 1 credits · 50 min

$50 Add to Cart

As part of a multi-day event

These seminars include this course on their agenda. One registration covers the event — you attend this course on its scheduled day, plus everything else that day offers.

Dec 1

Winter Multi-State Technology Conference Conference · Nov 30 – Dec 1, 2026 · Online · this course runs Dec 1, 2026 · event offers up to 16 credits

$250/day View event

Your instructor

Tommy Stephens

Partner · K2 Enterprises · ★ 4.6 instructor rating

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. In 1995, Tommy began...

Full profile →