Excel - Analyze with advanced functions

Time Length Icon 45:00 Video Icon 108 videos

It is not always suitable to use PivotTables to analyze data. Discover another approach by using instead functions and conditional formatting to analyze tables. 

Means and methods:

  • The session is carried out remotely with a virtual classroom tool
  • Live interaction with a trainer enabling participants to ask questions

Training Objectives:

  • Use functions to retrieve data from your tables
  • Discover advanced conditional formatting uses 

Training content:

  • Functions if, COUNTIF, VLOOKUP,...
  • Calculations with dates
  • The matrix calculation
  • Use a formula to apply conditional formatting

To see the list of sessions, please use the button below or the navigation menu.

Session Tile

This course means attending a virtual class with a subject matter expert.

Votre participation n'est pas obligatoire pour visualiser les autres ressources, mais si vous souhaitez poser vos propres questions et avoir un échange en direct, c'est ici que cela se passe.