159,969 views
👇🏻Click on the link below for the example file https://www.oppadu.com/FILTER-%ED%95%... ⭐️What if you're using a previous version of Excel and need the FILTER function? Shortcut to the xFILTER function add-on https://www.oppadu.com/product/%EC%97... ⭐We have opened the Oppa Do Excel We Can Do membership channel. / @oppadu 00:00 Excel FILTER function lecture starts 01:51 Learn the basics of using the FILTER function 05:06 Dynamically filter by referencing cells 07:13 Filtering multiple conditions 08:58 Troubleshooting multi-condition filtering 10:54 Search for similar matching conditions 12:54 3D search, filtering with multiple search conditions 18:20 Creating summary tables and dynamic charts An all-purpose function that anyone who uses Office 365 can use! Learn how to use the FILTER function step by step, from basics to advanced applications. ❤️ Oppa Do Excel Official Website: https://www.oppadu.com 📚 Go to Excel Community: https://www.oppadu.com/question #ExcelFILTERFunction #ExcelFunctionLecture #OppaDoExcel #ExcelPracticalLecture #OfficeWorkerExcel #PracticalExcel #ExcelLecture Night Out by LiQWYD / liqwyd Creative Commons — Attribution 3.0 Unported — CC BY 3.0 http://creativecommons.org/licenses/b... Music promoted by Audio Library • Night Out – LiQWYD (No Copyright Music) Bensound - Energy - • Video Creative Commons — Attribution 3.0 Unported— CC BY 3.0