Remote training Excel: Functions and formulas

  • Course types: Custom webinar
  • Duration: Half a day

Description

Everyone knows the most popular Excel function, SUM. 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 and Formulas, you’ll master the most popular functions. And the formulas that are relatively unknown and unloved.

Objectives

How do you get to master Excel formulas? Training in the formulas and 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 and formulas 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
  • 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

Requesting a quotation

Would you like to organize this webinar for your employees? We transform your requirements into the perfect solution.

Request

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com

Associated courses