In this Excel 2021 Advanced tutorial video, we discuss how to use the FILTER dynamic array function in Excel to filter data based on logic. In this specific example, we teach you how to use the * operator (AND 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 a free, 30-day trial to Simon Sez IT ►https://bit.ly/3B5o3DK

Take a look at the latest training courses from Simon Sez IT
https://www.simonsezit.com/courses/

Check out our Excel 2021 Tutorials for Intermediate Users playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Watch more popular Microsoft tutorials from Simon Sez IT:

Microsoft PowerPoint 2021 Tutorial (4-Hour Course for Beginners)
►https://youtu.be/LEe8OKhfJWw
Microsoft Word 2021 for Beginners (4-Hour Course)
►https://youtu.be/wy7Hj84MCeA
Microsoft Excel 2021/365 Tutorial (4.5+ Hours Beginner Course)
►https://youtu.be/Lvk45S3j7Y8
Microsoft Outlook 2021/365 Tutorial (2+ Hours Beginner Course)
►https://youtu.be/ZZQyzOewYNE
Microsoft Excel 2021/365 Tutorial (5-Hour Intermediate Course)
►https://youtu.be/oN82Umc9MCQ

Other, free Microsoft playlists 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

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining

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 ;-)