MY ACCOUNT

IT Pro

>

MS Office

>

Management

>

Multimedia

>

Development

>

Collaborative tools

>

Soft skills

>

Digital Marketing

>

ALL TRAININGS

Training: Excel – Dashboards in Excel

Ref. MOE-26

Download PDF

Duration:
0.5
 day
Exam:
Not certifying
Level:
Advanced
Funding:
Temptraining

Description

This training will enable participants to create dashboards that are easily understood and used by everyone.

Participant profiles

  • Users who analyze data in Excel and present it to others

Objectives

  • Set up a dashboard
  • Create specific charts such as maps or gauges
  • Set up the dashboard to facilitate the use of data

Prerequisites

  • Knowledge of data analysis, charts and formatting in Excel

Course content

Module 1: Dashboards

  • Understand the purpose of a dashboard
  • Determine what values to show on your dashboard
  • Preparing the data

Module 2: Charts

  • Adding geographic data
  • Creating a map chart
  • Inserting a scatter chart
  • Inserting gauge type charts

Module 3: Finalizing the dashboard

  • Setting up data on the dashboard
  • Adding slicers and timelines
  • Final formatting

Documentation

  • 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

lun17apr09:00lun12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-26

lun17apr09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-26

mar30may09:00mar12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-26

mar30may09:00mar12:00VirtuelVirtual Etiquettes de sessionMOE-26

  • ITTA
    Route des jeunes 33 Bis, Entrée B,
    1227 Carouge, Suisse

Horaires d’ouverture

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

Contactez-nous

  • ITTA
    Route des jeunes 33 Bis, Entrée B,
    1227 Carouge, Suisse

Votre demande

Opening hours

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

Contact us

  • ITTA
    Route des jeunes 33B,
    1227 Carouge, Suisse

Your request

X
X
X
X