Remote training Excel: Functions

  • Version: Office 2016/ Office 365
  • Duration: Half a day
  • Price open training: € 255 VAT excl. / Cheaper course?

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.

Choose a date and location

Objectives

How do you get to master Excel functions? Training in the functions that you find yourself desperately trying to understand! 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

Good basic Excel knowledge 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 - ...

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info open training course

The practical info and applicable cancellation conditions related to this open training course.

 

Choose a date and location

€ 255 VAT excl.
Cheaper course?

Would you like to organize this online training/webinar for your employees?

We transform your requirements into the perfect solution.

Request

Associated courses