Training: Excel – Dynamic Array formulas

Ref. MOE-25

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Eligible

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

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

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