Excel: Functions

Remote training

Version: Microsoft 365
Duration: 1/2 day (09:00-12:30 or 13:30-17:00)
Price training (excl. VAT) starting at: €725
Number of people: 1-12p

Description

Everyone knows the most popular Excel functions, SUM, AVERAGE and COUNT. But if it’s all you know, you’ll never get where you need to go. Because as your worksheets expand and become more complex, you’ll have to use other functions and formulas. After completing the remote training Excel Functions, you’ll master the most popular functions. And the formulas that are relatively unknown and unloved.

Objectives

After our training you will:

    • Be able to work smoothly with Excel’s basic functions
    • Be familiar with a great number of date and search functions, logical and information functions, text functions, …
    • Know how to functions integrate in each other (nested function)
    • Know how to break down and understand a nested function

Target Group

Everyone who wants to use Excel functions to work with Excel.

Prerequisites

A decent knowledge of the Excel basics is required.

Content

Part 1 Formulas

  • Type with the offered help
  • Use the Function Wizard
  • Use 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 Search 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 – …

Book this training

Let's start a conversation!

Team Xylos is ready to meet you