Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: * Operator (AND)
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Hard
Wayground Content
FREE Resource
The video tutorial explains how to use the filter function in Excel to filter data based on logical criteria. It covers the use of the plus operator for OR logic and the Asterix operator for AND logic. The tutorial demonstrates how to apply filters with multiple criteria, create and name tables for dynamic data updates, and finalize filter formulas to ensure they update automatically when new data is added.
Read more
1 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What new insight or understanding did you gain from this video?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
