Training: Excel – Analyze your data

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

Description

This Excel course will allow participants to analyze their data using pivot tables, filters and data extractions.

Participant profiles

  • Users who analyze data in Excel

Objectives

  • Filter and extract data from a database
  • Create pivot tables
  • Perform calculations in a pivot table
  • Create pivot charts
  • Use slicers and timelines

Prerequisites

  • Good knowledge of Excel, including items listed in the course listed below: Excel – Preparing for data analysis

Course content

Module 1: Filtering and extracting data

  • Use the advanced filter
  • Set up your criteria zones
  • Define the extraction zone

Module 2: Inserting a pivot table

  • Prepare the data
  • Inserting a pivot table
  • Adding fields to a pivot table
  • Reorganize the fields in a pivot table
  • Delete fields from the pivot table
  • Refresh a pivot table

Module 3: Field settings

  • Modify summarizing in a pivot table
  • Use a calculated field in a pivot table
  • Insert a calculated field in a pivot table

Module 4: Pivot Charts

  • Create a pivot chart
  • Add and customize chart elements
  • Modify the format of pivot charts

Module 5: Using Slicers and Timelines

  • Insert a slicer
  • Insert a timeline
  • Manage slicer settings
  • Manage report connections

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
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Complete documentation in digital format
  • Skills report showing your progress

mer21Juin09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

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

mer26juil09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

mer26juil09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 LausanneFeatured Etiquettes de sessionMOE-23

mer30Aoû09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

mer30Aoû09:00mer12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-23

mer04Oct09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

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

mer08Nov09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

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

mer13Déc09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

mer13Déc09:00mer12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-23

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