MY ACCOUNT

Training: Excel – Analyze your data

Ref. MOE-23

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Analyze your data

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 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

Etiquette de cours

mer13Déc09:00mer12:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-23

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

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

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

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

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

mer21Fév09:00mer12:00VirtuelVirtual Etiquettes de sessionMOE-23

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

lun23Déc09:00lun12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-23

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

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

mer01Jan09:00mer12:00Genève, Route des Jeunes 33B, 1227 CarougeAnnulée Etiquettes de sessionMOE-23

X

X

X

X