Glossary term
What is Criteria?
In Apex Flow Academy, "Criteria" means: The rule a conditional formula uses to decide which rows count, such as Market or 30 or more. It is taught in Microsoft Excel: Beginner to Advanced. Related terms include Exact and approximate match, Helper column, Lookup and key and PivotTable. Every Apex Flow Academy course lists the official sources it checked.
- 1 course teaches it
- plain-word definition
The facts
What is Criteria?
The rule a conditional formula uses to decide which rows count, such as Market or 30 or more.
Where is Criteria taught?
Criteria is defined in Microsoft Excel: Beginner to Advanced.
Which lessons cover Criteria?
These lessons name it in their title or objectives:
- Microsoft Excel: Beginner to Advanced, lesson 3.1: Totals with conditions: SUMIFS, COUNTIFS and AVERAGEIFS
Which terms are related to Criteria?
Next to Criteria in the course glossaries: Exact and approximate match, Helper column, Lookup and key, PivotTable, Tidy list, Slicer, Table and Spill.
Exact and approximate matchHelper columnLookup and keyPivotTableTidy listSlicerTableSpill
The hard questions, answered straight
Bold questions people really ask. Each answer comes from the course data or a settled Academy fact.
Do I need experience before I learn Criteria?
It depends on the course. Each course that teaches it lists its own prerequisites, and all are listed at beginner level:
- Microsoft Excel: Beginner to Advanced: No earlier spreadsheet experience is needed.