From the course: Advanced Excel for Financial Planning and Analysis (FP&A)
Join today to access over 24,900 courses taught by industry experts.
Combining user-defined functions for use in FP&A - Microsoft Excel Tutorial
From the course: Advanced Excel for Financial Planning and Analysis (FP&A)
Combining user-defined functions for use in FP&A
- [Instructor] What if I told you that Excel can now simulate a rolling forecast with one formula, no dragging, no copy pasting, no fragile links, no nested IF statements. With Lambda and the Lambda helper function called SCAN we can now build logic that behaves like a loop. It calculates values across time one period at a time, and for FP&A, this is remarkably useful. Let's unpack this formula. Here in G16, I am using a LET function. Remember, LET wraps together a number of different variables that we can name, and then I can compute multiple entries within this one single formula. Let's demystify what's happening here. To begin equals LET, open parentheses. This is all blank over here, which signals to me and the end user that there is more formula down here. Next, I'm creating for name number one, the variable name total. I'm assigning total to this somewhat lengthy formula. Let's begin with SCAN. If you remember, SCAN is a Lambda helper function. This is essentially going to run a…
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.