Office 365 - Working with Dynamic Arrays
in Microsoft Excel EssentialsWhat 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
Comments (0)
Getting started
Introduction to Dynamic array functions.
How to access the Office 365 Online
Download the exercise file for practice.
Learn how to access Excel online if you do not have office 365.
Access the exercise files online.
To apply your newly acquired skills, you are required to complete this final challenge workbook and submit for review.
Download the attached workbook and complete it. Each workbook has data and the instructions on the task you need to perform on the data. Complete all the tasks and submit for review.
Upon completion of the project, upload it on Google drive and share ONLY the link with the instructor. Copy and paste the LINK in the description. Do not attach the file.
Also, make sure the file is not restricted so set it to anyone with the link.
Course review
.png){kind=small}
.png){kind=small}
.png)