Pobierz kartę szkolenia

Review of new features in MS Excel 365

kod szkolenia: EX03_N365 / ENG AA 1d

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.

poziom Średnio zaawansowany

W celu uzyskania informacji skontaktuj się z działem handlowym. W celu uzyskania informacji skontaktuj się z działem handlowym.
800,00 PLN 984,00 PLN brutto

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

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
  5. Working with texts
    1. TEXTJOIN, TEXTSPLIT
    2. TEXTBEFORE, TEXTAFTER
    3. ARRAYTOTEXT
  6. Importing data from pictures
  7. Automatic data analysis
  8. Creating variables
    1. LET
  9. New navigation pane VIEW / NAWIGATION