Cours MS Excel Intermediate 2010 English

Imprimer Retour

Objectif

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

Pré-requis

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

Contenu

  • Improving the knowledge of Microsoft Excel 2010.
  • 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, sparklines
  • Search functions (VLOOKUP, HLOOKUP)
  • Date functions
  • Creating a drop down list (Data validation tool)
  • Sorting, automatic and advanced filters
  • Subtotals and group functionalities
  • Protection methods for cells, worksheets, workbooks
  • Introduction to Pivot tables

Langue du cours

EN

Support de cours

  • Training support in supplement

15.- CHF

Durée

2 jour(s)

Nos cours collectifs

Aucune session programmée

Conditions générales de vente