MS Excel for experts PLUS
training code: EX04_PLUS / ENG AA 3d / EN
Content of this training is mainly aimed at people that already are using MS Excel, but don’t use the newest features that are available in currently very popular MS Excel 365 version.
The training is designed for people with at least moderate experience with excel. Training doesn’t focus on any particular group of functions but instead in design to show new and more efficient ways of analyzing data in excel. If you are still using functions like VLOOKUP or IF this training will open your eyes for new and easier ways of working with excel with new functions and tools. Additionally, the training contains more advanced use cases allows to show how to use those new functionalities in more complex scenarios.
Caution: Training intended for individuals using Excel in Office 365 version.
- Learn about new functions
- Compare old functions with their new better versions
- Find out more about new Spill functionality
- Get a huge package of knowledge about new tools and functions that will help with day to day tasks
- Lear about very powerful LAMBDA function
- Speed up and simplify the process of creating formulas with ability to define variables
- Knowledge of how to use functions from CUBE group to work with data model
- More exercises to do on your own under trainers supervision that will allow you to get even more familiar with new knowledge
- Filtering and sorting
- FILTER – including partial text match and exclusions
- SORT, SORTBY
- Working with data ranges
- CHOSECOLS, CHOSEROWS
- UNIQUE
- TOROW, TOCOL
- SEQUENCE
- DROP, TAKE
- VSTACK, HSTACK
- Lookup functions
- XLOOKUP
- XMATCH
- CHOOSE
- Logical functions
- IFS
- SWITCH
- Aggregating functions
- GROUPBY
- PIVOTBY
- Working with texts
- TEXTJOIN, TEXTSPLIT
- TEXTBEFORE, TEXTAFTER
- ARRAYTOTEXT
- Regular expression functions
- REGEXTEST
- REGEXEXTRACT
- REGEXREPLACE
- Importing data from pictures
- Automatic data analysis
- Creating variables – LET function
- Creating custom functions without VBA – LAMBDA function
- LAMBDA helpers
- MAP
- REDUCE
- BYROW
- BYCOL
- SCAN
- ISOOMITED
- CUBE functions
- CUBESET
- CUBESETCOUNT
- CUBERANKEDMEMBER
- CUBEMEMBER
- CUBEVALUE
- CUBEKPIMEMBER
- New navigation pane VIEW / NAWIGATION
Medium to advanced level of knowledge about excel or attending EX03 training
English