Excel - Analyze with advanced functions

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

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.