- Lecture
- 4.1 Complex conditional statements
- 4.2 Conditional formatting of data
- 4.3 Sorting the data
- 4.4 Data Filtering
- 4.5 Working with lists and databases in Excel
Keywords
logical function, logical IF() statement, syntax for the IF function, function argument, AND() function, OR() function, conditional formatting, sorting, automatic sorting, custom sorting, filtering, simple filter, advanced filter, mask for filter data, list, database, field, record, field name, summary function with conditions - 4.1 Complex conditional statements
- Practical assignment 8
- Practical assignment 9
- Test to the topic 4