Excel 365 Functions 2

Overview

This course will help delegates broaden their knowledge of Excel 365 Functions.  As well as IF, this course covers functions which are new in this version of Excel, including IFS and XLOOKUP (a superior version of VLOOKUP), and dynamic arrays, which mark the biggest change to Excel formulas in 30 years.

This course will enable you to

use XLOOKUP to perform lookups in tables of data.  Delegates will also be able to enter and edit dynamic array formulas and use the FILTER, UNIQUE and SORT functions.

Compatibility issues
Which versions of Excel will new functions work with?
Publish Excel worksheets as pdf

Take decisions with IF and IFS
Construct a logical test
Write a formula using the IF function
Combine multiple tests with IFS

Look up data with XLOOKUP
Advantages of XLOOKUP over VLOOKUP
Write formulas using XLOOKUP
Retrieve multiple columns of data with one formula

Dynamic array formulas
Understand dynamic arrays and spill
Deal with the #SPILL! error

FILTER
Use the FILTER function to extract data matching a condition
Understand the advantages over conventional filters

SORT and SORTBY
Generate a dynamic sorted list from a data table

UNIQUE
Generate a dynamic list of unique values from a data table

Who is the Course aimed at

those who want to broaden their knowledge of Excel 365 functions.  Delegates should be familiar with entering simple formulas, copying formulas with AutoFill, and locking cells with $ signs.