Cours MS Excel Intermediate 2007 English

Imprimer Retour


MS Excel 2007 Intermediate is a course that teaches you how to efficiently use Microsoft Excel 2007. You optimize your use of tables, worksheets, workbooks, formulas and charts. This intermediate course on Microsoft Excel 2007 lasts two days and allows you to earn an excellent knowledge of this fundamental tool of the Microsoft Office 2007 suite.


  • Knowledge of the Windows environment
  • Having attended the Fundamentals of Microsoft Excel 2007 course or having an equivalent knowledge


  • Improve your knowledge of Microsoft Excel 2007.
  • Absolute and relative references
  • Naming a cell or a range of cells
  • Advanced conditional formatting
  • Simple and nested logical functions (IF, AND, OR)
  • Simple and advanced charts
  • Search functions (VLOOKUP, HLOOKUP)
  • Date functions
  • Creating a drop down list (Data validation tool)
  • Sorting data, setting automatic and advanced filters
  • Subtotals and group functionalities
  • Cell, Worksheet and Workbook protection
  • Introduction to Pivot Tables

Langue du cours


Support de cours

  • Training support in supplement


2 jour(s)

Nos cours collectifs

Disponibilité sur demande

Conditions générales de vente

Pour toute problématique d'accès ou de situation de handicap merci de contacter nos équipes.