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