Course MS Excel 2007 Advanced English

Imprimer Retour

Goal

MS Excel 2007, Advanced is an advanced course that teaches you how to optimize your work on Microsoft Excel 2007. 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 2007 suite.

Prerequisites

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

Content

  • Improving the use of Microsoft Excel 2007.
  • 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 tables)
  • Creating simple and advanced pivot tables
  • Importing/Exporting data from/to other computer programs
  • Becoming familiar with recorded macros

Course Language

EN

Course material

  • Training material in supplement

Duration

2 day(s)

Our group lessons

Availability on request

General conditions of sales

If you have any difficulties with physical access or require any assistance please contact our teams.