top of page

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

Wireless Computer Accessories

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


bottom of page