Excel FILTER function tutorial | Beginner to Advanced
In this video, we explain the Excel FILTER function. We start by explaining the basics of the FILTER function in Excel, and we show how to use it with Excel tables, then we show how to deal with errors that we might face when using the Excel FILTER function. Afterwards, we show how to use the Excel FILTER function with multiple criteria of AND or OR or a mix of both.
We Also show advanced tricks of using the Excel FILTER function, such as using a list of values as the criteria, and filtering by using a search keyword or text.
Watch our video explaining the SORT and SORTBY functions:
• SORT function vs SORTBY function in e...
Download Example files:
https://tinyurl.com/3czcrm3n
Time Stamps:
00:00 Introduction to the Excel FILTER function
00:31 Excel FILTER function Basics
02:57 Using Excel FILTER function with Excel tables
04:43 Dealing with errors when not finding filter results using Excel FILTER function
05:23 Excel FILTER function with AND and OR criteria
10:23 Sorting the results using the SORT function combined with the Excel FILTER function
11:07 Selecting certain columns from the result of the Excel filter function
13:06 Using the Excel FILTER function with a list of values as a criteria
14:58 Excel FILTER function with a search keyword (Using wildcards with the FILTER function)
17:25 Excel FILTER function - Availability
17:54 Excel FILTER function - Conclusion
GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)
https://tinyurl.com/4ayp2457
Follow us on Social Media:
Facebook: / excelbonanza
Twitter: / excelbonanza
Follow me on Linkedin: / abdelrahman-abdou-60240150
Instagram: / excelbonanza1
TikTok: / excelbonanza
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com
****My online Excel Courses****
https://www.excelbonanza.com/courses/
#filterfunction #filter #excelformula
