Cours MS Excel 2010 Advanced English
Imprimer RetourObjectif
MS Excel 2010 Advanced is an advanced course that teaches you how to optimize your work on Microsoft Excel 2010. You will enhance your knowledge on tables, worksheets, workbooks, formulas, charts, analysis tools and solver. This course lasts two days and allows you to perfectly master this fundamental tool of the Microsoft Office 2010 suite.
Pré-requis
- Knowledge of the Windows environment
- Having attended the Intermediate or Business Microsoft Excel 2010 course or having an equivalent knowledge
Contenu
- Improving the use of Microsoft Excel 2010.
- Using search functions (Vlookup, Index, Match)
- Using database formulas (Dsum, Daverage, Dmax, etc.)
- Using conditional sum and count functions
- Using text functions
- Using formula auditing tools
- Nest functions
- Managing multi-worksheets workbooks
- Consolidating data
- Using analysis tools (Goal Seek, Solver, Scenario Manager, Data Table)
- Creating simple and advanced Pivot tables
- Importing/Exporting data from/to other computer programs
- Becoming familiar with recorded macros
Langue du cours
EN
Support de cours
- Training support in supplement
Durée
2 jour(s)
Nos cours collectifs
Disponibilité sur demande
Pour toute problématique d'accès ou de situation de handicap merci de contacter nos équipes.