TRAINING ADVANCED EXCEL Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich

The goals of this advanced Excel course are:

To become proficient in search functions, database functions, the If function and nested formulas; to create advanced pivot tables; to customise the Excel environment; and to design macros.

Participants
Open to everyone.

Course requirements
Knowledge of pivot tables, proficiency in advanced calculation functions (the conditional, date and text functions).

Practical exercises
This Advanced Excel course, which is based on realistic simulation exercises and a comparison of different practices, will equip participants with techniques that can be used directly.

Programme for the advanced Excel course

  • Managing documents
  • Creating, modifying and saving an Excel document
  • Automatic saving
  • Choosing the destination directory
  • Entering data and calculation formulas
  • Entering, changing, correcting, copying and moving data
  • Creating calculation formulas: operators (+, -, *, /)
  • Using basic features: sum, average, count, conditional, etc.
  • Using relative and absolute references
  • Logical and search functions
  • DATE and TIME functions
  • Formatting
  • Formatting cells
  • Conditional formatting
  • Customising the number format
  • Printing documents
  • Print preview
  • Inserting a page break
  • Layout (orientation, headers, footers, etc.)
  • Managing headers
  • Charts
  • Chart wizard
  • Modifying and customising charts
  • Work group mode
  • Working on spreadsheets
  • Linking sheets
  • Linking workbooks
  • Data analysis
  • Using automatic filters
  • Sorting and subtotals
  • Elaborate filters
  • Pivot tables
  • Tools
  • Target value
  • The solver
  • Scenario manager
  • Recording macros
  • Macro recording
  • Assigning a button to a macro.
  • Running macros: keyboard shortcuts, toolbar, etc.

Course diploma / certificate

A certificate is obtained at the conclusion of the Advanced Excel course.

Similar types of training courses:

Our trainings can be provided tailor-made for your organization or organized in-company.

Are you looking for an in-company training? Download our training catalog.

If you are rather interested in tailored training…
Please fill in the form below, we will gladly give you more information about our tailored trainings:

All our courses can be delivered in English, French, German, Swiss German, Italian, or Spanish.

All our services are available in Switzerland: Geneva, Zürich, Vaud, Neuchâtel, Fribourg and Valais.