Excel - Analyze with advanced functions

Time Length Icon 45:00 Video Icon 40 videos
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

To view the list of sessions, click the below button or go to navigation menu to login.

Session Tile

Live interaction with a trainer enabling participants to ask questions

Your participation is not mandatory to view other resources, but if you want to ask your own questions and have a live exchange, this is where it happens.