Excel: Functions and formulas

  • Course types: Calendar course / In company
  • Version: Office 2010/2013/2016
  • Takes place in: Antwerp, Brussels
  • Duration: 1 day
  • Price: € 365 VAT excl. / Cheaper course?

"Very fascinating course. This course has shown me that often there is an easy way to achieve the same results."
Bernard Philippe – Elia Asset NV

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.

Choose a date and location

Objectives

After this training, you’ll:

  • be able to use Excel’s basic functions fluently
  • be familiar with a large number of date and search functions, logical and information functions, text functions, ...
  • know how to integrate a function into another function (embedded function)
  • know how to break down and understand an embedded function

Target Group

Everyone who wants to learn how to use Excel functions and formulas more efficiently.

Prerequisites

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 address ($)
  • 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

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

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

 

Choose a date and location

€ 365 VAT excl.
Cheaper course?

Requesting a quotation

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

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com