Current Status

Not Enrolled

Price

155 $

Get Started

Excel 365

How to use dynamic matrix functions

Analysis of complex data is now accessible to everyone. create reports using simple functions. The introduction of dynamic matrices is Excel’s biggest change in years.

Objectives :

  • Introduction to Excel 365
  • New functions for dynamic matrices
  • Impact of dynamic matrices on existing functions
  • New functions compatible with dynamic matrices
  • See examples of uses

Duration : 7 hours

Requirements :

  • Microsoft 365 version user
  • No other requirements for this intermediate level training

Course Content

Before beginning ( Duration 04:28 )
Review of main functions 3 Topics
Introduction 1 Topic
Dynamic array formulas 2 Topics
New lookup functions 2 Topics
Excel 365