Course Information
Dynamic Arrays in Excel
Course Information
| Title: | Dynamic Arrays in Excel |
|---|---|
| Category: | Computer Software |
| Field of Study: | Computer Software and Applications |
| Course Code: | M035 |
| CPE Credits: | 2.0 |
| Price: | 19.95 |
Description
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().
Delivery Method: Online Interactive Self Study
Level: Overview
Prerequisites: None
Advanced Preparation: None
Course Details
Category: Computer Software
Field of Study: Computer Software and Applications
Passing Score: 70%
Technical Details: CA, FL: Computer Software and Applications are technical subjects TX: Computer Software and Applications are non-technical subject for TX. NY: Advisory Services includes Computer Software and Application
For More Detail:
If you are unable to view PDF then right click the mouse and click save link as
Objectives
Objectives:
- Differentiate between an array and a dynamic array
- Recognize how dynamic arrays work
- Differentiate between different dynamic array functions
- Recognize how a hashtag works with dynamic arrays
For More Objectives:
If you are unable to view PDF then right click the mouse and click save link as
Profession
NASBA: Yes
QAS: Yes
CPA: Suitable for all CPAs
IRS: No IRS credit for Enrolled Agents.
Profession Identifiers: CPA