The FILTER Function in Excel: Data, Financial Models, and the Multiverse

Learn more: https://breakingintowallstreet.com/ex...

You'll learn how to use the FILTER function in Excel in this tutorial for both data analysis and financial modeling.

Files & Resources:

https://breakingintowallstreet.com/kb...

Table of Contents:

0:00 Introduction
4:24 Part 1: FILTER with Multiple Criteria
7:28 Part 2: FILTER for PE Fund Modeling
12:31 Part 3: FILTER with the XIRR and IRR Functions
15:31 Part 4: How to Make This More Dynamic
19:27 Recap and Summary