From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

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

Using the SEQUENCE function

Using the SEQUENCE function - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Using the SEQUENCE function

“

- [Speaker] Let's take a look at our first array function by starting with a SEQUENCE. This function is the bedrock of many dynamic model calculations, especially when working with timelines. So let's look at a few examples of how to build a sequence and how we can use it in our models. So this is how we build it. Just go into SEQUENCE and let's say we want to have 10 rows down like that. So very simply, it starts from one and goes through to 10. If we have a look at the dialogue box by hitting this insert function icon at the top, you can see that there are a couple more options that we can put in here. You can ask it to have a couple of columns. So if you leave it as blank, it will not add any columns. We can add it to two. We could ask it to start at a different number. Let's say we can ask it to start at 100, and we can ask it to step in increments of five. There we go. So that is how we use it. One of the things that we know about financial modeling is that it is not very good…

Contents