Skip to main content

Microsoft Excel – Logical and Look-up Functions

Using Excel spreadsheets is an integral part of many roles. We have developed a series of half day remote tutor led training opportunities covering key aspects of Excel to enable you to’ pick and mix’ according to your requirements. As part of our suite of Excel courses, this will help you with logical and look-up functions.

Date
Scheduled according to demand
Price
£115 for Scomis Customers and £170 for non-customers
Duration
2.5 hours
Course type
Remote tutor led course

This course will cover:

  • IF function
  • Nested IF (with AND, OR)
  • LOOKUP functions: VLOOKUP, HLOOKUP
  • Workbook and worksheet protection