Excel: Functions and formulas

  • Duration: 1 day

Description

You know your way around Excel and you know the most popular Excel functions, such as SUM. However, the more complex your Excel tasks become, the more functions you need. These functions are exactly what you’ll learn in our ‘Excel: Formulas and functions’ training. After this training, you’ll no longer need to waste time looking up specific functions by yourself and you’ll be able to use functions and formulas as if you’ve been doing this for ages.

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 learn how to use Excel functions and formulas more efficiently.

Prerequisites

Good basic Excel knowledge is required.

Content

Part 1 Formulas

  • Type with the offered help
  • Use the Function Wizard
  • Use the Help function
  • Absolute and relative addressing ($)
  • Cell names

Part 2 Basic functions

Sum – Min – Max – Count – Counta – Countblank – Round – Average – SumIf(s) - AverageIf(s) - Countif – CountIfs – Roundup - Rounddown - …

Part 3 Date and Time Functions

? Today – Now – Month – Year – Day – Weekday – Datedif - …

Part 4 Logical Functions

If – And – Or – Not - Iferror

Part 5 Search Functions

Vlookup – Hlookup – Match – Index – Offset – Address – Indirect – …

Part 6 Text Functions

Left – Right – Mid – Upper – Lower – Find – Search – Len – Concatenate (&) – Proper – Value – Trim - …

  • Split text easily with Flash Fill

Part 7 Information Functions

Cell – IsBlank – IsError – IsNumber – IsText - …

Part 8 Statistical Functions

AverageA – MaxA – MinA – Large – Small - Rank - Rank.Avg - Rank.Eq

Request an offer



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

This training as in-company training?

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request