Extracting data, including searching using: text, numeric, date and time, Boolean operators (AND, OR, NOT), >, <, =, >=, <=, contains, starts with, ends with

Transforming and cleaning data to extract meaningful information

apply conditional formulas, for example: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, MAXIF, MAXIFS and MINIF, MINIFS