Overview

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 startingDynamic Array practical demonstrationThe world of Dynamic ArraysThe importance of tablesUnique Function, DataSort and "#"Dynamic drop-down menusFilter functionXLookupTransposed MatrXLookup: further information2nd Example3rd ExampleXLookupFilter function in-depth analysisChoose Col - BackslashFilter ranges of numbersExample with TransposeUniqueSortSort bySequenceRandom matrA ColStack Vert - Stack OrizSplit textRead functionLambda function

Skills

Reviews