Dynamic Arrays in Excel (On-Demand - CPABC)
Overview
Dynamic arrays can be a tremendous time-saver in Excel, but most business professionals remain unaware of what should be a commonly used tool. Learn the best practices for this tool by participating in this session.
This session was recorded from PD Nexus: Information Technology Insights (July 2026).Access expires 180 days from purchase date |
Content
Key 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
Course Content Created: July 2026
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.Presenter
Brian TankersleyAbout This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
After completing your purchase, go to mylms.bccpa.ca. Log in using your CPABC Online Services credentials. Click Go to Your Courses and Materials to access your Learning Center. Select your course title to begin.
Course Dates & Registration
- 0.75
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 2
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Dynamic Arrays in Excel (On-Demand - CPABC)
- 0.75
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 2
- Credits
Overview
Dynamic arrays can be a tremendous time-saver in Excel, but most business professionals remain unaware of what should be a commonly used tool. Learn the best practices for this tool by participating in this session.
This session was recorded from PD Nexus: Information Technology Insights (July 2026).Access expires 180 days from purchase date |
Content
Key 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
Course Content Created: July 2026
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.Presenter
Brian TankersleyAbout This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
After completing your purchase, go to mylms.bccpa.ca. Log in using your CPABC Online Services credentials. Click Go to Your Courses and Materials to access your Learning Center. Select your course title to begin.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.