Vous avez déjà un compte client ORSYS
Se connecter
Vous êtes nouveau chez ORSYS
Créer un compte
Vous ne souhaitez pas créer de compte
Poursuivre sans me connecter

Course : Excel: Building Your Skills

version 2016/2013/2010 remote TOSA® certification optional

Excel: Building Your Skills

version 2016/2013/2010 remote TOSA® certification optional

Average of customer reviews Average of customer reviews Average of customer reviews Average of customer reviews
4,5 / 5




INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Available in English on request

Ref. LMX
  1d - 7h00
Price : 500 CHF E.T.

Download in PDF format

Share this course by email






Teaching objectives
At the end of the training, the participant will be able to:
Consolidate your initial knowledge of Excel.
Master essential shortcuts
Use calculation formulas and functions
Analyze data and understand pivot tables

Certification
If registering for the TOSA® certification option, you must do so at the same time as course registration. The exam is made up of a 60-minute adaptive test with 35 exercises. The result indicates your skill level. Merely taking the course is not sufficient to achieve a maximum score. The exam must be both scheduled and then taken online within 4 weeks following the start of your session.

Practical details
Hands-on work
Discussions, experience-sharing, demonstrations, tutorials, and real cases.
Teaching methods
Active learning based on examples, demonstrations, experience-sharing, real cases, and an evaluation of what was learned from the training.

Course schedule

1
Effectively using shortcuts and essential commands

  • Mastering best practices and shortcuts: Avoid dead ends.
  • Knowing fast, effective, useful commands.
Hands-on work
Learn about and register for the TOSA® certification option. Discovering and applying useful shortcuts and best practices of use.

2
Designing an Excel table

  • Designing a simple table and laying it out.
  • Mastering the features of a structured table.
  • Presenting a data list.
  • Identifying the pros and cons of a structured table and a data list. Selection criteria.
  • Presenting and printing a table, a list.
  • Using Excel themes and styles.
Hands-on work
Creating and laying out a table. Designing filters and data lists. Applying formulas and functions.

3
Mastering calculation formulas and functions

  • Building your knowledge of simple operations: + - * / operators.
  • Mastering formulas with parentheses and percentages.
  • Using the $ character in formulas.
  • Paste link or paste values.
  • Copy and paste: Understanding how to copy formulas.
  • Discovering calculation functions: Common statistics (AVERAGE, COUNT, or COUNTA).
  • Creating calculation formulas in common management tables.
Hands-on work
Creating and editing computing formulas. Observations of differences in results.

4
Analyzing data

  • Getting to know pivot tables: Creating, updating, and formatting them.
  • Understanding and using report filters.
  • Choosing analysis fields and values.
  • Editing value field parameters. Choosing types of calculations.
  • Managing row and column labels.
  • Understanding the principle of data analysis in pivot tables.
  • Formating: The “Format as Table” command.
  • Online option: Schedule and take the TOSA® exam within 4 weeks.
Hands-on work
Creating pivot tables and analyzing data.


Customer reviews
4,5 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed. (Translated by Deepl)
DYLAN G.
15/12/25
5 / 5

formation intéressante, un jour de plus serait parfait pour approfondir.
AURÉLIE M.
15/12/25
5 / 5

Mes attentes sont celles de la formation, revenir aux bases puis développerMerci
LEA D.
15/12/25
5 / 5

Formation très complète pour consolider les bases sur Excel ! Formatrice dynamique et agréable

> Show more comments


Dates and locations

Dernières places
Date garantie en présentiel ou à distance
Session garantie
On 25 March 2026 *
FR
Remote class
Registration
On 29 April 2026
FR
Remote class
Registration
On 27 May 2026
FR
Remote class
Registration
On 24 June 2026
FR
Remote class
Registration
On 28 September 2026
FR
Remote class
Registration
On 26 October 2026
FR
Remote class
Registration
On 23 November 2026
FR
Remote class
Registration
On 14 December 2026
FR
Remote class
Registration