Statut actuel

Non-inscrit

Tarif

425 $

Commencer

Excel 365

Using Dynamic Array Functions in Excel

Overview:

With dynamic array functions, analyzing complex data is now easier than ever, enabling users to create powerful reports with simple formulas. This training introduces dynamic arrays—one of Excel’s most significant advancements in recent years.

Objectives:

  • Introduction to Excel 365’s dynamic array capabilities
  • Explore new functions designed for dynamic arrays
  • Understand the impact of dynamic arrays on existing functions
  • Learn about new functions compatible with dynamic arrays
  • Review practical examples and use cases

Duration: Approximately 6 hours

Prerequisites:

  • Microsoft 365 user
  • No additional prerequisites; suitable for intermediate-level users.

Contenu de la Formation

Before beginning ( Duration 04:28 )
Review of main functions 3 Chapitres
Introduction 1 Chapitre
Contenu de la Leçon
0% Terminé 0/1 Etapes
Dynamic array formulas 2 Chapitres
New lookup functions 2 Chapitres
Excel 365