Description

Anyone who works with Excel is naturally familiar with the popular SUM, AVERAGE and COUNT functions. But these functions alone won't get you very far. As your spreadsheets grow and become more complex, you'll need to use more advanced functions too. In this online training, you'll gain a deeper understanding of the most commonly used functions to lighten your workload in Excel — plus a few formulas that are relatively unknown.

Objectives

After this training:

• You'll work confidently with Excel's basic functions

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

• 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 use functions to work more efficiently in Excel.

Prerequisites

Participants have a good basic knowledge of Excel or have completed the Excel basics training.

Contents

Part 1: Formulas

• Typing formulas yourself with the help of built-in assistance

• Working with the function wizard

• Using the help function

Part 2: Basic functions

• SUMIF(S) – AVERAGEIF(S) – COUNTIF(S) – ROUNDUP – …

Part 3: Date and time functions

• TODAY – NOW – MONTH – YEAR – DAY – WEEKDAY

Part 4: Logical functions

• IF – AND – OR – IFERROR

Part 5: Lookup functions

• VLOOKUP – MATCH – INDEX

Part 6: Text functions (optional)

• LEFT – RIGHT – MID – UPPER – LOWER – SEARCH – LEN – CONCATENATE (&) – VALUE – TRIM – …

Part 7: Information functions (optional)

• ISBLANK – ISNUMBER – …

Part 8: Office 365 functions (optional)

• XLOOKUP – FILTER – UNIQUE – SORT – …