On-Demand
Taking Advantage of Array Formulas in Excel 2025-26
CPE: 2
Overview
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions.
Product Code
1000004337
Credit Type
CPE: 2CPE-Non-Technical: 2Format
Online Self-Study
Intended Audience
This course is designed for CPAs, other financial professionals who regularly use Microsoft Excel for data analysis, financial modeling, or complex calculations.
NASBA Field of Study
Computer Software & Applications
Level of Difficulty
Intermediate
Prerequisites
None
Advance Preparation
Participants should have a basic understanding of Microsoft Excel.
Learning Objectives
Major Subjects
- Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.
- Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.
- Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.
- Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.
- Using Array Constants: This section teaches how to simplify the use of static values called Array Constants.
Faculty
Bryan L. Smith
Bryan is the owner of DataSmith Pro, LLC, where he helps accounting, tax, and financial professionals use technology to improve accuracy and efficiency. A Certified Information Systems Auditor (CISA) with over 40 years of experience, Bryan specializes in Excel design, spreadsheet accuracy, and data analysis. He has audited thousands of spreadsheets and developed courses on Excel, Microsoft Power BI, and data analytics. Bryan has trained profes...
More about Bryan L. SmithAdditional Details
This On-Demand course is provided through our partnership with DataSmith Pro.