The major topics that will be covered in this class include:
- Performing advanced searching & data retrieval with LOOKUP, INDEX & MATCH functions
- Speeding up worksheet creation with the INDIRECT function
- Testing conditions with the LOGICAL functions (IF, AND, OR, NOT)
- Using ERROR checking functions