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

Mergers & Inquisitions / Breaking Into Wall Street · Beginner ·📊 Data Analytics & Business Intelligence ·10mo ago

About this lesson

Learn more: https://breakingintowallstreet.com/excel-vba/?utm_medium=yt&utm_source=yt&utm_campaign=yt37 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/excel/excel-filter-function/ 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

Original Description

Learn more: https://breakingintowallstreet.com/excel-vba/?utm_medium=yt&utm_source=yt&utm_campaign=yt37 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/excel/excel-filter-function/ 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
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
This Theorem Is So Obvious It Feels Like Cheating
Learn the Pigeonhole Principle, a fundamental theorem in data science and mathematics that can help you solve complex problems with ease
Medium · Data Science
 📰
Dosen Pasti Muji! Mengolah Data Tugas Akhir Udah Nggak Perlu Ribet Dengan Power BI!
Simplify data processing for final projects with Power BI, no more switching between apps
Medium · Data Science
 📰
Radio Said Audiences Preferred Men. The Data Told a Different Story
Data analysis of airplay in Ireland and the UK reveals that audiences prefer female artists, contrary to radio industry assumptions
Medium · Data Science
 📰
Data Analysis Is Not Just for Data Analysts: Why Every Professional Should Learn to Think with Data
Learn to think with data to make informed decisions, regardless of your profession
Medium · Data Science

Chapters (6)

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
Up next
What is Data Mesh Explained with Examples
VLR Software Training
Watch →