• Icon Sur demande
  • Icon 3 h 30 mins
  • icon Formation à distance
  • Icon English
  • Icon IF092CJ
130,00 EUR

*

(+3% TVA)

Virtual classroom


In response to the current situation related to the coronavirus COVID-19, the House of Training is delighted to announce that this training is now accessible as a virtual class.


This format, perfectly adapted to any staff member aiming to develop their skills remotely, has various benefits:

  • It allows you to train yourself while avoiding any physical movement

  • Maximum efficiency is guaranteed due to an adaptation of session durations according to this kind of training

  • Regular interaction between the trainer and the learners is assured thanks to modern technology tools

Registration is easy!


If you wish to attend this training, please click on “S'inscrire” and choose “virtual classroom”.


In order to conveniently attend the virtual classroom, kindly review the following recommandations.

Objectives


  • Manage your spreadsheets in an efficient way

Programme


  • Manipulate large tables

    • Definition

    • Rules for building a list

    • Freeze panes, repeat headers …

    • Format as table

      • Table name

      • Add a totals row

    • Moving & selecting in an efficient way

    • Data validation

    • Find/replace data

  • Conditional Formatting

    • Apply a conditional formatting to cells

    • Create a rule

    • Manage the formatting rules: edit, delete

  • The flash fill

    • Automatically extract or combine data

    • Start flash fill automatically/manually

  • Managing sheets

    • Add, rename, delete a sheet

    • Move & copy a sheet

    • Set a color to the sheet tab

  • Create and manage links

  • Keyboard shortcuts

Prerequisites


  • Basic Excel skills

In collaboration with


Key Job

Lieu

Vous souhaitez rester à jour sur notre offre de formation ?

Vous avez une question ?
Nous avons des réponses !