MS Excel for experts

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.

• 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

Medium to advanced level of knowledge about excel or attending EX03 training

Polish or English

1. Filtering and sorting
   1. FILTER
   2. SORT, SORTBY
2. Working with data ranges
   1. CHOSECOLS, CHOSEROWS
   2. UNIQUE
   3. TOROW, TOCOL
   4. SEQUENCE
   5. DROP, TAKE
   6. VSTACK, HSTACK
3. Lookup functions
   1. XLOOKUP
4. Logical functions
   1. IFS
   2. SWITCH
5. Working with texts
   1. TEXTJOIN, TEXTSPLIT
   2. TEXTBEFORE, TEXTAFTER
   3. ARRAYTOTEXT
6. Importing data from pictures
7. Automatic data analysis
8. Creating variables – LET function
9. Creating custom functions without VBA – LAMBDA function
10. LAMBDA helpers
    1. MAP
    2. REDUCE
    3. BYROW
    4. BYCOL
    5. SCAN
    6. ISOOMITED
11. CUBE functions
    1. CUBESET
    2. CUBESETCOUNT
    3. CUBERANKEDMEMBER
    4. CUBESETCOUNT
    5. CUBEMEMBER
    6. CUBEVALUE
    7. CUBEKPIMEMBER
12. New navigation pane VIEW / NAWIGATION