Training: Excel – Preparing for data analysis

Ref. MOE-13
Not certifying


This Excel course will provide participants with the knowledge and skills necessary to prepare their data for analysis. They will learn how to use data tables, perform sorting, or use flash fill.

Participant profiles

  • Users who analyze data in Excel


  • Work with a data table
  • Import and export data
  • Master the data entered in a table


  • Basic knowledge of Excel

Course content

Module 1: Data tables

  • Use the Table function
  • Convert a table into a data range
  • Using the Fill button
  • Using the Flash Fill button
  • Performing simple, multi-criteria and custom sorting
  • Removing duplicates

Module 2: Importing and exporting data

  • Import external data (txt, csv files, data from the web)
  • Configure the imported columns
  • Export and share data

Module 3: Data entry in a table

  • Create and manage drop-down lists
  • Mastering data validation
  • Identify erroneous data in a table


  • Digital courseware included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

  • As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • An online skills assessment test before and after your course so that you can evaluate your progress

jeu20apr09:00jeu12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-13

jeu20apr09:00jeu12:00VirtuelVirtual Etiquettes de sessionMOE-13

jeu01jun09:00jeu12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-13

jeu01jun09:00jeu12:00VirtuelVirtual Etiquettes de sessionMOE-13

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.


Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request