EasyGrades

Using IF with OR

Using IF with AND

Using IF

Nesting IF Functions

Naming

Nesting IF Functions Part 2

Using COUNTIF and COUNTIFS

Using AVERAGEIF and AVERAGEIFS

Using SUMIF and SUMIFS

Wildcards

Using IF with NOT

Data Validation - Error Messages

Data Validation - Input Messages

Data Validation - Dates

Data Validation - Circles

Data Validation - Lists

Data Validation - Numbers

Data Validation - Text

02 - How to Use Calculated Fields in PivotTables

03 - Grouping in PivotTables

04 - Changing the Operations in a PivotTable

05 - Changing the Format of Data Displayed in PivotTables

01 - How to Protect the Worksheet