In this Excel 2021 Advanced tutorial video, we discuss how to use a new dynamic array function in Excel, the FILTER function, to filter data based on logic. In this specific example, we teach you how to use the + operator (OR logic).

To see the full course that this video came from, go here: ️https://www.simonsezit.com/courses/microsoft/excel-2021-advanced-online-course/

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

Check out our FREE 300+ hour training course playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Watch more popular tutorials from Simon Sez IT:

Microsoft Office 2021 and Office 365 Training Tutorials playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Excel 2021 Tutorials for Beginners playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

PivotTable training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)