From the course: Excel for Financial Planning and Analysis (FP&A)

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Introduction to dynamic arrays

Introduction to dynamic arrays - Microsoft Excel Tutorial

From the course: Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

Introduction to dynamic arrays

“

- [Instructor] In 2020, Microsoft introduced a series of new functions that really changed the game. They addressed many of the issues we have with Excel for FP&A, most notably that we historically had to get very involved in manual updates of files, formulas, and data ranges. This new functionality was appropriately named Dynamic Arrays. These arrays or ranges of data expand and contract in the Excel field with minimal human intervention. This means that we can get ranges of data to update almost automatically and accommodate the needs we have in financial planning and analysis. Now, to begin with, let's highlight what the Dynamic Array functions are, what they do, and what they replace from traditional Excel. Let's begin with SEQUENCE. SEQUENCE provides a dynamic range of numbers across a series of columns and rows. What does it replace? Well, it just simply replaces the need to do this manually. RANDARRAY.…

Contents