Training: Excel – Dynamic Array formulas

Ref. MOE-25

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Temptraining

Home > Trainings > Office Automation > Spreadsheet > Excel – Dynamic Array formulas

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