Realdolmen Education

Details

Excel Advanced Functions and Formulas: Logical – Lookup (VILT - Virtual Instructor Led Training)

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

0.2 day(s)

Prerequisites

A good knowledge of the basics of Excel is required (file management, edit data, structure of a sheet, formatting). You also need some knowledge of simple functions and formulas and the use of absolute, relative and mixed cell references. You can follow your training ‘HOM013 – Excel Basic Functions & Formulas’ to master them before following this session

Description

Excel contains a lot of built in functions spread over different categories. This session will teach you how to use some functions from the categories logical functions and lookup functions. .

Contents

  • Logical functions
    • IF
    • AND, OR and XOR
    • IFS (Excel 2019, Excel 365)
    • SWITCH (Excel 2019, Excel 365)
  • Lookup functions
    • VLOOKUP and HLOOKUP
    • LOOKUP
    • INDEX and MATCH
    • CHOOSE