When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models
Profectus Academy Profectus Academy
4.16K subscribers
1,699 views
0

 Published On Premiered Feb 25, 2022

In this video you will learn the following

- How to use scan() function to model data with annual and sequential growth rates
- Building a Bank overdraft / revolver corkscrew model in dynamic array
- How to work with the reduce() function
- How to model rolling averages using reduce function

show more

Share/Embed