From the course: Advanced Excel for Financial Planning and Analysis (FP&A)
Join today to access over 24,900 courses taught by industry experts.
SEQUENCE and dynamic DATE arrays - Microsoft Excel Tutorial
From the course: Advanced Excel for Financial Planning and Analysis (FP&A)
SEQUENCE and dynamic DATE arrays
- [Instructor] Let's go up here to row 34, specifically cell G34. Here I'm using a very clean but extremely powerful dynamic array function, SEQUENCE. There are four elements to pay attention to: rows, columns, start, and step. So in other words, what I'm doing in this calculation is saying I want a dynamic array that is one row tall. I want this to be 12 columns to the right, starting at one and increasing by one. When I hit Enter, I end up with a dynamic array starting with black font. Then as I scroll, it's gray going from a one all the way to 12. We're going to be using the SEQUENCE function again and again throughout the rest of our course. Now, I'm going to bring us down here to G41, and if you recall from a prior lesson, I can stitch together dates based upon the elements of year, month, and day. But if you may recall from a prior lesson, I have a problem here. I'm putting a zero, which means it's going to grab the last date of the month, but not the current month, the prior…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.