GHS (GH₵)
GH₵
Ghanaian cedi
€
Euro Member Countries
₦
Nigeria Naira
$
United States Dollar
Your cart is empty
Empty notifications
Login Register
Office 365 - Working with Dynamic Arrays

Office 365 - Working with Dynamic Arrays

in Microsoft Excel Essentials
5.00
(1 Ratings)
Created by THOMAS FESTUS CUDJOE

What you will 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

No prior knowledge is required to take this course. However, basic knowledge of Excel functions will be an added advantage.
Yes! All the exercise files in this course are downloadable. However, sharing the files with 3rd parties is against our policy.
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.
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.
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.
Certificates are free as far as you have met the requirements to earn that certificate.
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

Comments (0)

Getting started

1 Min
Attachments:

Introduction to Dynamic array functions.

5 Min
Attachments:

How to access the Office 365 Online

7.31 MB MB

Download the exercise file for practice.

3.76 MB

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

5 Min
Attachments:
10.98 MB MB

Access the exercise files online.

1 Min
Attachments:
9.13 MB MB
33.94 MB MB
29.23 MB MB
22.34 MB MB
15.37 MB MB
20.17 MB MB
39.01 MB MB
26.70 MB MB
40.34 MB MB
41.83 MB MB
39.05 MB MB
54.54 MB MB
36.80 MB MB
28.41 MB MB
22.41 MB MB
19.31 MB MB
17.82 MB MB
16.59 MB MB
10.60 MB MB
21.79 MB MB
13.09 MB MB
40.63 MB MB
8.00 MB MB
18.18 MB MB
19.20 MB MB
47.98 MB MB
30.97 MB MB
21.43 MB MB
15.82 MB MB
19.94 MB MB
18.12 MB MB
22.10 MB MB
38.12 MB MB

Final course challenge

2 Min
Attachments:
177.95 KB MB

Course review

2 Min
Attachments:
5.00
1 Reviews
Content quality (5)
Instructor skills (5)
Purchase worth (5)
Support quality (5)

Reviews (1)

Content quality
Instructor skills
Purchase worth
Support quality
Samuel Mensah
1 Apr 2023 | 13:47
Reply
GH₵199
Access with Membership
5 Days money back guarantee
This Course includes:
Downloadable content
Official certificate
Instructor support
Favorite
Share

Gift this course

Send this course as a gift to your friends

Course specifications

Capacity:
Unlimited
Duration:
2:05 Hours
Students:
96
Files:
37
Created Date:
29 Mar 2023
THOMAS FESTUS CUDJOE

THOMAS FESTUS CUDJOE

Microsoft Data Platform MVP | Certified Trainer
4.67
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert
Profile Book a Meeting

Tags

excel data analysis office 365
Bootcamp

Report course

Please describe about the report short and clearly.

Share

Share course with your friends

https://festman.io/course/New-Functions-Dynamic-Arrays
telegram Telegram whatsapp Whatsapp facebook Facebook twitter Twitter

Buy with points

18 Weeks Business Intelligence and Data Analytics

18 Weeks Business Intelligence and Data Analytics

Learn advanced Excel, Power BI, SQL and AI. Become a Business Intelligence Analyst or Data Analyst.

Learn more