Training: Excel – Dynamic Array formulas

Ref. MOE-25
Duration:
0.5
 day
Exam:
Not certifying
Level:
Advanced

Description

This course will enable participants to use dynamic array formulas, increasing their ability to analyze data and create dynamic lists.

Participant profiles

  • Users who have to analyze data in Excel
  • Users who want to improve their knowledge of Excel functions

Objectives

  • Use dynamic array functions
  • Set up dynamic data validation

Prerequisites

  • Good knowledge of Excel functions

Course content

Module 1: Dynamic array Functions

  • Knowing the usefulness of dynamic array functions
  • Entering a dynamic array function
  • Evaluate a part of a dynamic array function
  • Using SORT, SINGLE, TRANSPOSE
  • Using VLOOKUP, HLOOKUP and XLOOKUP in dynamic array  mode
  • The LET function

Module 2: Dynamic data validation

  • Use dynamic array functions to filter data
  • Use filtered data to validate data

Documentation

  • Digital course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

  • As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
  • Explore all our Microsoft Office courses by clicking here
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Complete in digital format
  • Achievement Badge

lun10Juin09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-25

lun10Juin09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-25

lun15juil09:00lun12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-25

lun15juil09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-25

lun19Aoû09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-25

lun19Aoû09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-25

lun23Sep09:00lun12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-25

lun23Sep09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-25

lun28Oct09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-25

lun28Oct09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-25

lun02Déc09:00lun12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-25

lun02Déc09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-25

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X