Description
What you’ll learn
-
The use of the new Dynamic Array formulas and their enormous convenience to speed up your work on Microsoft Excel 365
-
We will discover the main great innovations brought by Excel 365 compared to old versions of Excel (Excel legacy)
-
The new array functions: unique, sort data, sort data by, sequence, random array, Xlookup , filter, a col, stack Vert – stack Horiz, split text
-
Further information on the Xlookup function
-
Insights into the filter function
-
The new Let & Lambda programming functions
Do you already have an excellent level of Excel but would like to learn more?
Maybe discovering all the great innovations brought by Microsoft 365 including the new Dynamic Array formulas and the let and lambda programming ones?
Then this is the course for you! Sign up now to start your learning journey!
Excel has revolutionized the way you work on your spreadsheets, making the experience much more efficient in the latest versions (2021 and 365).
I will guide you to discover the main advanced features of Excel through videos and guided exercises.
So, what are we waiting for? I am waiting for you!
NB: to follow this course you must have Excel version 365 or 2021. Versions prior to these do not support the innovative features covered by this course.
Subjects:
-
Thanks and some information before starting
-
Dynamic Array practical demonstration
-
The world of Dynamic Arrays
-
The importance of tables
-
Unique Function, DataSort and “#”
-
Dynamic drop-down menus
-
Filter function
-
XLookup
-
Transposed Matr
-
XLookup: further information
-
2nd Example
-
3rd Example
-
XLookup
-
Filter function in-depth analysis
-
Choose Col – Backslash
-
Filter ranges of numbers
-
Example with Transpose
-
Unique
-
Sort
-
Sort by
-
Sequence
-
Random matr
-
A Col
-
Stack Vert – Stack Oriz
-
Split text
-
Read function
-
Lambda function
Who this course is for:
- Anyone who wants to take a leap forward in using Microsoft Excel by greatly speeding up their work
- Anyone dealing with especially large Microsoft Excel files
- Anyone who deals with Microsoft Excel files to do data analysis and draw conclusions
Reviews
There are no reviews yet.