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:
   • Excel SORT and SORTBY functions - the...  


Download Example files:
https://tinyurl.com/3czcrm3n

Time Stamps:
00:00 Introduction
00:31 FILTER function Basics
02:57 Using FILTER function with Excel tables
04:43 Dealing with errors when not finding filter results
05:23 Excel FILTER function with AND and OR criteria
10:23 Sorting the results using the SORT function
11:07 Selecting certain columns from the result of the Excel filter function
13:06 Using FILTER with a list of values as a criteria
14:58 FILTER function with a search keyword (Using wildcards with the FILTER function)
17:25 FILTER function in Excel - Availability
17:54 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