Skip to main content

Microsoft Excel – Logical and Look-up Functions (C)

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. If you have no experience of creating formulas please attend the Formulas and Functions (A) course first.

Time
13.30 - 16.30
Price
£115 for Scomis Customers and £150 for non-customers
Duration
3 hours
Course type
Remote tutor led course

This course will cover:

  • Logical functions: IF (with AND/OR)
  • Nested IF functions
  • LOOKUP functions: XLOOKUP, VLOOKUP, HLOOKUP
  • Understanding error messages