Master the FILTER function in Excel with 5 simple steps.
👉 Take our Excel course: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/edohxmkf8t
Learn how to master the FILTER formula in Excel. When used correctly, the filter function is one of the most powerful functions in excel. So let me show you how to use it using 4 examples from easy to hard, plus one bonus example at the end you might find surprising! First we'll go over a simple filter and compare it with the filter too. Then, we'll filter with more than one criteria with AND or OR conditions. Thirdly, we'll use the VSTACK and CHOOSECOLS formulas to add dynamic headers. Forth, we'll use an advanced filter to find the average if a certain condition is true. Finally, we'll create an approximate search with the ISBLANK, SEARCH, and FILTER functions.
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Simple FILTER Formula
2:02 - FILTER with Multiple Conditions
4:14 - FILTER Headers
6:34 - Multiple Formulas
8:04 - Approximate FILTER