Training: Excel – Giving visual impact to your spreadsheets

Ref. MOE-24
Duration:
0.5
 day
Exam:
Not certifying
Level:
Advanced

Description

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

Objectives

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

Prerequisites

  • 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

Documentation

  • Digital course material 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
  • Explore all our Microsoft Office courses by clicking here
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Complete in digital format
  • Achievement Badge

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

mer27Mar09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-24

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

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

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

mer05Juin09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-24

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

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

mer14Aoû09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-24

mer14Aoû09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-24

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

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

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

mer23Oct09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-24

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

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

lun23Déc09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-24

lun23Déc09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-24

mer01Jan09:00mer12:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-24

mer01Jan09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 LausanneAnnulée Etiquettes de sessionMOE-24

Horaires d’ouverture

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

Contactez-nous

Votre demande

Opening hours

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

Contact us

Your request

X
X
X
X