+233 54 123 9290

support@festman.io

Office 365 - Working with Dynamic Arrays

(1)

100 Students

43 Lectures

Thomas Festus Cudjoe

Instructor

What Will You Learn?

Learn how to use dynamic array functions such as FILTER, SORT, UNIQUE, and SEQUENCE to manipulate and analyze data more efficiently.

Apply multiple filtering criteria using FILTER and AND, OR, Addition operator etc.

Perform 2-way look up using XLOOK UP

Merge and Append tables using VSTACK and HSTACK.

Unstacking Data

Splitting and joining data

Gain hands-on experience by practicing with real-world examples and exercises to solidify their learning.

About This Course

This course is hands-on course designed to help you master
the new dynamic array functions in Excel and how you can leverage them to
improve your reporting and analytics in Excel.

This course covers all the dynamic array functions including
SORT, SORTBY, XLOOKUP, FILTER, SEQUENCE etc.

At the time of recording this course, the dynamic arrays are
available in Excel for Microsoft 365, Excel for the web(free), Excel 2021,
Excel 2019 and Excel for Android or iPhones.

In case you don't have office 365 or Excel 2019 and later
versions, we have included the exercise files for Excel online which is free.

LEARNING OBJECTIVES

· Understand the concept of dynamic arrays and how
they differ from traditional Excel formulas.

·
Learn how to use dynamic array functions such as
FILTER, SORT, UNIQUE, and SEQUENCE to manipulate and analyze data more
efficiently.

·
Apply multiple filtering criteria using FILTER
and AND, OR, Addition operator etc

·
Perform a 2-way look-up using XLOOK UP

·
Merge and Append tables using VSTACK and HSTACK.

·
Unstacking Data

·
Splitting and joining data

·
Gain hands-on experience by practicing with
real-world examples and exercises to solidify their learning.

FAQ

Check the frequently asked questions about this course.

What are the requirements to take the course?

No prior knowledge is required to take this course. However, basic knowledge of Excel functions will be an added advantage.

Can I download the Excel files for the course?

Yes! All the exercise files in this course are downloadable. However, sharing the files with 3rd parties is against our policy.

How long do I have to complete the course?

This course is self-paced so you can complete it at your own pace. You can access the course on your PC or mobile device. You have lifetime access to the course. Though the course can be completed at your own pace, we encourage our students to access the course and learn as soon as possible. You never know when opportunity will knock so make hay while the sun shines.

How do I earn my certificate?

To receive a verifiable certificate for this course, you must complete all the video lessons, quizzes, and final assessments if any. Make sure to mark all the lessons as passed on the course learning page.

Is the certificate verifiable?

Absolutely! Your certificate can be verified by anyone on our certificate validation page using your unique certificate ID. Certificates can be verified via https://festman.io/certificate_validation.

Do I pay any additional fee for the certificate?

Certificates are free as far as you have met the requirements to earn that certificate.

Can I get in touch with the instructor if I have questions or need support?

Sure! Even though the course is self-paced, our instructors are closer to you than you think. Our instructors are always available to support you on every step of the way. You can book a meeting with the instructor or send an email on the instructor’s page. We also have a course forum where you can connect with other students and ask questions or get help. In summary, these are the options available for support: 👨‍👩‍👧‍👦 Course forum 📧 Email Support 📽️ Live meeting with instructor

Thomas Festus Cudjoe

(20)

35 Courses

2217 Students

Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence. He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics. At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.

Book a Meeting

Recent Reviews

See what students are saying about the course.

More Reviews

Samuel Mensah 1 Apr 2023

Curriculum Overview

This course includes 2 modules, 43 lessons, and 0:16 hours of materials.

Introduction

42 Parts | 0:14 Hours

Getting started

Study Duration 1 Minutes

Attachments 0

Introduction to Dynamic arrays

Introduction to Dynamic array functions.

Study Duration 5 Minutes

Attachments 0

Access the exercise files

How to access the Office 365 Online

Volume 7.31 MB

Exercise file

Download the exercise file for practice.

Volume 3.76 MB

Introduction to Excel Online

Learn how to access Excel online if you do not have office 365.

Study Duration 5 Minutes

Attachments 0

Introduction to Office 365

Volume 10.98 MB

Exercise file: Excel online

Access the exercise files online.

Study Duration 1 Minutes

Attachments 0

What you should know

Volume 9.13 MB

The UNIQUE Function

Volume 33.94 MB

The SORT BY Function

Volume 29.23 MB

The SORT BY Function Example 2

Volume 22.34 MB

The SORT BY Function Example 3

Volume 15.37 MB

SORT BY Vs SORT

Volume 20.17 MB

The FILTER Function

Volume 39.01 MB

Showing Top N with FILTER

Volume 26.70 MB

Multiple FILTERS - AND

Volume 40.34 MB

Multiple FILTERS - AND Example 2

Volume 41.83 MB

Multiple FILTERS - OR

Volume 39.05 MB

The XLOOK UP Function

Volume 54.54 MB

XLOOK UP with Wildcards

Volume 36.80 MB

XLOOK UP - 2 way Lookup

Volume 28.41 MB

XLOOK UP - 2 way Lookup Example 2

Volume 22.41 MB

XLOOK UP - Approximate Match

Volume 19.31 MB

XLOOK UP - Approximate Match Example 2

Volume 17.82 MB

The TEXTSPLIT function 1

Volume 16.59 MB

The TEXTSPLIT function 2

Volume 10.60 MB

The TEXTBEFORE function

Volume 21.79 MB

The TEXTAFTER function

Volume 13.09 MB

The VSTACK function

Volume 40.63 MB

The HSTACK function

Volume 8.00 MB

The SEQUENCE function

Volume 18.18 MB

The SEQUENCE function 2

Volume 19.20 MB

The SEQUENCE function 3

Volume 47.98 MB

The RANDARRAY function

Volume 30.97 MB

The TOCOL function

Volume 21.43 MB

The TOROW function

Volume 15.82 MB

The WRAPROWS function

Volume 19.94 MB

The WRAPROWS function 2

Volume 18.12 MB

The WRAPROWS function 3

Volume 22.10 MB

The WRAPCOLS function

Volume 38.12 MB

Final Challenge

Final course challenge

Study Duration 2 Minutes

Attachments 0

Final Challenge solution

Volume 177.95 KB MB

🎉Congratulations

1 Parts | 0:02 Hours

Course review and certificate

Course review

Study Duration 2 Minutes

Attachments 0

Certificates

1 Parts

Course Certificate

If you pass all the lessons in this course, you will receive this certificate.

Type Course Certificate

Please log in to leave a comment.

5.00

1 Reviews

Content Quality (5)

Instructor Skills (5)

Value for Money (5)

Support Quality (5)

Samuel Mensah

1 Apr 2023 01:47 pm

Office 365 - Working with Dynamic Arrays

This Course Includes

Downloadable Content

Official Certificate

Instructor Support

Course Forum

Favorite

Report Content

Course Specifications

Sections

Lessons

Capacity

Unlimited

Duration

2:05 Hours

Students

100

Created Date

29 Mar 2023

Updated Date

13 Dec 2025

Thomas Festus Cudjoe

Founder & Lead Instructor

(20)

Profile

Send Course as Gift

Send as a gift to friends

Subscribe to Our Newsletter

Receive expert insights, course updates, and learning resources directly in your inbox and get notified

Let’s get started now!

Take the First Step in Tech!

Explore courses

Learn

Self paced courses Career tracks Bootcamps Certificate Validation Pricing

Explore

Microsoft Excel Power BI SQL Generative AI Python

Contact Us

1st Floor, World Trade Centre, Accra

+233 54 123 9290

support@festman.io

Office 365 - Working with Dynamic Arrays

What Will You Learn?

About This Course

FAQ

Thomas Festus Cudjoe

Recent Reviews

Curriculum Overview

Course Certificate

Leave a Comment

Reply to Comment

Comments Approval

Samuel Mensah

Reply to Review

Submit Reply

This Course Includes

Course Specifications

Send Course as Gift

Tags

Subscribe to Our Newsletter