Skip to main content

Excel: Formulas and functions

Version: Office 365
Duration: 1 day
Price incompany training: € 1100 VAT excl. / Terms for incompany training.

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

  • Entering formulas manually
  • Working with the function wizard
  • Using the help function
  • Absolute and Relative addressing ($)
  • Cell names

Part 2 Basic functions

  • Sum – Min – Max – Count – Counta – Countblank – Round – Average – Roundup – Rounddown …

Part 3 Date and Time Functions

  • Today – Now – Month – Year – Day – Weekday – Networkdays – Eomonth…

Part 4 Logical Functions

  • If – And – Or – Not – Iferror – Ifs – Switch – Let

Part 5 Search Functions

  • Vlookup – Hlookup – Xlookup – Match – Xmatch – Index – Offset – Address – Indirect

Part 6 Text functions

  • Left – Right – Mid – Upper – Lower – Find – Search – Len – Concatenate (&) – TextJoin – Proper – Value – Trim – Replace – Substitute
  • Splitting text easily with Flash Fill

Part 7 Informative functions

  • IsBlank – IsError – IsNumber – IsText

Part 8 Statistical functions

  • SumIf(s) – AverageIf(s) – Countif(s) – Large – Small – Rank.Avg – Rank.Eq

Part 9 Dynamic Array functions

  • Unique – Filter – Sort – SortBy – Sequence
  • Referring to a Spill range via #
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?