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
microsoft-excel-seeklogo.com.png

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