Training: Excel – Giving visual impact to your spreadsheets

Ref. MOE-24
Not certifying


This training will allow participants to make their spreadsheets more visually impactful, using formatting automation.

Participant profiles

  • Users who want to improve their spreadsheet formatting skills


  • Set up complex conditional formatting
  • Modify and customize the theme of their worksheets
  • Use Sparkline charts


  • Basic knowledge of Excel

Course content

Module 1: Conditional Formatting

  • Setting up simple conditional formatting
  • Understanding and applying conditional formatting of different types
  • Managing conditional formatting rules
  • Setting up complex conditional formatting with formulas
  • Reproducing conditional formatting
  • Find cells with conditional formatting
  • Modify conditional formatting
  • Delete conditional formatting

Module 2: Themes

  • Understanding how themes work in Excel
  • Modifying a theme
  • Customizing a theme and save it
  • Understanding the difference between theme colors and standard colors

Module 3: Sparkline Charts

  • Create a sparkline chart
  • Highlight specific values in a sparkline chart
  • Display and customize axis settings


  • 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

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

jeu06apr09:00jeu12:00VirtuelVirtual Etiquettes de sessionMOE-24

mer17may09:00mer12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-24

mer17may09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-24

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