Excel - Analyze with advanced functions

Time Length Icon 45:00 Video Icon 108 videos
Like Icon
Button

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

Pour voir la liste des sessions merci de vous connecter via le bouton ci-dessous ou depuis le menu de navigation.

Session Tile

This course means attending a virtual class with a subject matter expert. Your attendance is not required to view other resources but under this format, an expert trainer will be able to answer your questions in real time.

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.