Description

You already work well with Excel and know the most popular Excel functions, such as SUM. But the more complex your work in Excel becomes, the more functions you need. And that's exactly what you'll learn in our course "Excel: Formulas and functions". After this course you'll no longer waste time figuring everything out yourself, and you'll be able to use functions and formulas as if you'd always done so.

Objectives

After this training:

• You'll work fluently with the basic functions of Excel

• You'll be familiar with a wide range of date and lookup functions, logical and informational functions, text functions...

• You'll know how to nest one function inside another

• You'll know how to best break down and understand a nested function

Target audience

Anyone who wants to learn to work more efficiently with functions and formulas in Excel.

Prerequisites

You have a good basic knowledge of Excel.

Contents

Formulas

• Entering formulas manually

• Working with the function wizard

• Using the help function

• absolute and relative cell referencing ($)

• Cell names

Basic functions

• SUM - MIN - MAX - COUNT - COUNTA - COUNTBLANK - ROUND - AVERAGE - ROUNDUP - ROUNDDOWN ...

Date and time functions

• TODAY - NOW - MONTH - YEAR - DAY - WEEKDAY - NETWORKDAYS - EOMONTH...

Logical functions

• IF - AND - OR - NOT - IFERROR - IFS - SWITCH - LET

Lookup functions

• VLOOKUP - HLOOKUP - XLOOKUP - MATCH - XMATCH - INDEX - OFFSET - ADDRESS - INDIRECT

Text functions

• LEFT - RIGHT - MID - UPPER - LOWER - FIND - SEARCH - LEN - CONCATENATE (&) - TEXTJOIN - PROPER - VALUE - TRIM - REPLACE - SUBSTITUTE - TEXTAFTER - TEXTBEFORE - TEXTSPLIT

• Splitting text easily with Flash Fill

Informational functions

• ISBLANK - ISERROR - ISNUMBER - ISTEXT

Statistical functions

• SUMIF(S) - AVERAGEIF(S) - COUNTIF(S) - LARGE - SMALL - RANK.AVG - RANK.EQ

Dynamic array functions

• UNIQUE - FILTER - SORT - SORTBY - SEQUENCE

• Referencing a range with #