Training: Excel – PowerPivot

Ref. MOE-44
Duration:
2
 days
Exam:
Not certifying
Level:
Expert

Description

This course teaches how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports.

Participant profiles

  • Advanced Excel users
  • Users that want to gain familiarity with PowerPivot to build compelling reports

Objectives

  • Explore every aspect of using Microsoft PowerPivot

Prerequisites

  • General Excel and Report building skills
  • To have the equivalent knowledge or to have followed the trainings: Excel – Preparing for data analysis and Excel – Analyze your data

Course content

Module 1: Introduction to PowerPivot 

  • Adding the PowerPivot Add-In to Excel
  • Introduction to PowerPivot

Module 2: PowerPivot Data Sources 

  • Importing Excel and Access files
  • Importing CSV files

Module 3: Creating Reports with PowerPivot 

  • Creating Pivot Tables
  • Modifying the Pivot Table Structure
  • Setting up row, column, page and data fields
  • Creating grouping criteria
  • Creating calculated fields
  • Automatic sorting and filtering
  • Using segments
  • Formatting the pivot table
  • Pivot charts

Module 4: Performance Indicators (KPI) 

  • Creating a calculated field
  • Creating a KPI
  • Modifying a KPI
  • Use in pivot tables

Module 5: Advanced DAX functions

  • Using DATE and TIME functions
  • Using STATISTICAL functions
  • Using VALUE functions
  • Using LOGICAL and INFORMATION functions
  • Using TEXT functions

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 1'200.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement Badge

jeu15Juin(Juin 15)09:00ven16(Juin 16)17:00VirtuelVirtual Etiquettes de sessionMOE-44

jeu15Juin(Juin 15)09:00ven16(Juin 16)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-44

jeu20juil(juil 20)09:00ven21(juil 21)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-44

jeu20juil(juil 20)09:00ven21(juil 21)17:00VirtuelVirtual Etiquettes de sessionMOE-44

jeu24Aoû(Aoû 24)09:00ven25(Aoû 25)17:00VirtuelVirtual Etiquettes de sessionMOE-44

jeu24Aoû(Aoû 24)09:00ven25(Aoû 25)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-44

jeu28Sep(Sep 28)09:00ven29(Sep 29)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-44

jeu28Sep(Sep 28)09:00ven29(Sep 29)17:00VirtuelVirtual Etiquettes de sessionMOE-44

jeu02Nov(Nov 2)09:00ven03(Nov 3)17:00VirtuelVirtual Etiquettes de sessionMOE-44

jeu02Nov(Nov 2)09:00ven03(Nov 3)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-44

jeu07Déc(Déc 7)09:00ven08(Déc 8)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-44

jeu07Déc(Déc 7)09:00ven08(Déc 8)17:00VirtuelVirtual Etiquettes de sessionMOE-44

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