MS Office Excel Training - Conditional formatting


MS Office Excel Training - Conditional formatting in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

ID : 653

Goal : Learn every MS Excel 2007 and 2010 conditional formatting features by using basic or advanced criteria.

Audience : Users needing to quickly outline specific data by using specific formatting.

Prerequisites : Know MS Windows envrionment and at least 30 MS Excel data list or database functions.

Goals :
  • Introduction
  • Define conditional formatting
  • Conditional formatting with cells (value)
  • Conditional formatting with formulas
  • Conditional formatting with customized formatting
  • Conditional formatting with KPI (3, 4 or 5 levels)
  • Conditional formatting with percentiles
  • Conditional formatting with percents
  • Use conditional formatting in filters
  • Use conditional formatting in lists
  • Use conditional formatting in pivot tables and tructure follow up
  • Create personnalized KPIs with if formula and Webdings or Wingdings font
  • Training Conclusion
Suggested duration for presentiel training (days) : 1
Suggested duration for on-line training (days) : 1.2

Daily price in face-to-face : 225 CHF
Daily price in remote : 108 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 1125 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

  • Title : Excel 2007: The Missing Manual
  • Author(s) : Matthew MacDonald
  • Pages : 856
  • ISBN : 0596527594

Tags : ms excel training, ms excel 2007 training, conditional formatting, business intelligience, kpi, bi.