Microsoft Excel Further Formulas
Half Day

This module is designed for delegates who are very familiar with formulas and wish to take their knowledge to a higher level using the IF function, alongside nested functions and IF’s. This will allow for logical testing of large volumes of data.

Course format: Half day, max capacity 6

Session topics

​

• Indirect

• Dependant Lists

• Data validation

• Formatting as a Table

• Renaming Table

• Using Table names/column names in formula

• Format as table with named ranges

• IF and Nested If (or Ifs)

• Count If

• Sum If

• AND/OR/IF