0
Author: |
Patricia McCarthy, MBA |
Course Length: |
Pages: 31 ||| Word Count: 6644 ||| Review Questions: 5 ||| Final Exam Questions: 10 |
CPE Credits: |
2.0 |
IRS Credits: |
0 |
Price: |
$17.95 |
Passing Score: |
70% |
Course Type: |
Text |
Technical Designation: |
NonTechnical |
Field Of Study: |
Computer Software & Applications |
Approved Audience: |
NASBA QAS - NASBA Registry |
Key Takeaways: |
This course explains how Excel dynamic arrays work and demonstrates functions such as SORT, FILTER, UNIQUE, and SEQUENCE that spill results into adjacent cells automatically.
|
Frequently Asked Questions: |
|
Description: |
The course introduces dynamic arrays. Excel dynamic arrays are one of the most significant improvements introduced in modern versions of Microsoft Excel. They fundamentally change how formulas work by allowing a single formula to return multiple values that automatically “spill” into adjacent cells. This replaces many older techniques involving array formulas, helper columns, and manual copying. No more typing and then pressing CSE. Now, when you write a formula in a cell and press Enter, the resulting value appears in that cell as well as neighboring cells. This filling in of neighboring cells is called spilling and the resulting answers are considered an array. Dynamic arrays are volatile as they update automatically when the source data is changed. Dynamic functions covered in this course include: SORT(), SORTBY(), FILTER(), UNIQUE() and STOCKHISTORY(). |
Usage Rank: |
20000 |
Release: |
2026 |
Version: |
1.0 |
Prerequisites: |
You need Excel 2021 or Microsoft 365 to use these functions. Click on Account in Excel and it will show you what version you have. If you are not sure, try typing in one of the functions mentioned in the description and see if Excel recognizes it. If it recognizes it, you should be all set. |
Experience Level: |
Overview |
Additional Contents: |
Complete, no additional material needed. |
Additional Links: |
Internal: Excel Magic Building Dynamic Formulas Video Course
Internal: Breaking Down Excel Formulas Video Course
External: Microsoft Support Dynamic Array Formulas and Spilled Array Behavior
External: Microsoft Support FILTER Function Documentation
|
Advance Preparation: |
None. |
Delivery Method: |
QAS Self Study |
Intended Participants: |
Anyone needing Continuing Professional Education (CPE). |
Revision Date: |
21-May-2026 |
NASBA Course Declaration: |
Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam. |
Keywords: |
Dynamic Array Formulas - A Powerful Excel Tool - CPE course for CPAs |
Learning Objectives: |
Course Learning Objectives Upon completion of this course, you should be able to:
|
Course Contents: |
Chapter 1 - Dynamic Array Formulas - A Powerful Excel Tool Course Learning Objectives Overview Dynamic Arrays Behind the Scenes Spilling Review Question Key Dynamic Array Functions SORT() SORTBY() FILTER() Multiple Filters Review Question/Exercise UNIQUE() Hashtag UNIQUE() and Hashtag # SEQUENCE () RANDARRAY() Conclusion- Dynamic Arrays Review Question Glossary |
Login/Register