Excel
: Tableaux croisés dynamiques
Modalités :Intra - Inter - Présentiel
Coût de la formation :Nous contacter
'%20clip-path='url(%23clip-path)'%3e%3cpath%20id='Tracé_170'%20data-name='Tracé%20170'%20d='M19.045,14.028V24.408a1.473,1.473,0,0,1-1.472,1.472H1.828A1.473,1.473,0,0,1,.356,24.408V1.828A1.473,1.473,0,0,1,1.828.356H17.572a1.473,1.473,0,0,1,1.472,1.472v3.78'%20transform='translate(-0.059%20-0.059)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_171'%20data-name='Tracé%20171'%20d='M2.97,2.97V24.131h10.4L17.3,20.2v-3.1'%20transform='translate(-0.491%20-0.491)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_172'%20data-name='Tracé%20172'%20d='M9.039,12.307,7.308,14.14,6.471,13.3'%20transform='translate(-1.07%20-2.034)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_173'%20data-name='Tracé%20173'%20d='M9.039,18.422l-1.73,1.833-.837-.837'%20transform='translate(-1.07%20-3.045)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_174'%20data-name='Tracé%20174'%20d='M9.039,6.059,7.308,7.892l-.837-.837'%20transform='translate(-1.07%20-1.001)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_175'%20data-name='Tracé%20175'%20d='M13.852,15.782,15.9,17.831,27.473,6.258a.528.528,0,0,0,0-.745l-1.3-1.3a.527.527,0,0,0-.745,0Z'%20transform='translate(-2.29%20-0.67)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_176'%20data-name='Tracé%20176'%20d='M15.6,20.153l-.739.739-1.891.774-.465-.465-.466-.466.774-1.891.739-.74'%20transform='translate(-1.99%20-2.993)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cline%20id='Ligne_16'%20data-name='Ligne%2016'%20x1='0.977'%20y2='0.977'%20transform='translate(9.538%2018.208)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_177'%20data-name='Tracé%20177'%20d='M27.989,8.255l.483.483a1.2,1.2,0,0,1,0,1.7l-3.619,3.619'%20transform='translate(-4.109%20-1.364)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cline%20id='Ligne_17'%20data-name='Ligne%2017'%20x1='2.048'%20y1='2.048'%20transform='translate(20.046%206.629)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_178'%20data-name='Tracé%20178'%20d='M9.641,25.826,4.433,20.618v5.208Z'%20transform='translate(-0.733%20-3.408)'%20fill='%23e05012'/%3e%3c/g%3e%3c/svg%3e)
'%3e%3cg%20id='Groupe_3880'%20data-name='Groupe%203880'%20transform='translate(-0.417%20-0.417)'%3e%3cpath%20id='Tracé_163'%20data-name='Tracé%20163'%20d='M.417.417,10.569,10.569.72,20.417'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
La formation
Mise à jour: 20/07/2026
Objectifs
- Structurer des données pour faciliter leur exploitation
- Créer et personnaliser des tableaux croisés dynamiques
- Produire des analyses rapides et pertinentes
- Utiliser les graphiques croisés dynamiques pour visualiser les résultats
- Mettre en valeur les données grâce aux outils de mise en forme d’Excel
Durée de la formation
7h
Démarche Pédagogique
- Apports théoriques
- Exercices tout au long de la formation
- Un support de cours est remis à chaque participant
Moyens Pédagogiques
- Equipement de salle de formation
- Un ordinateur par participant
Évaluation
Exercices appliqués et corrigés tout au long de la formation
Programme
ORGANISER ET PREPARER LES DONNEES
- Identifier les bonnes pratiques pour structurer une base de données
- Corriger et fiabiliser les données importées
- Supprimer les erreurs fréquentes :
- cellules fusionnées
- espaces inutiles
- doublons éventuels
- Compléter ou transformer certaines informations pour améliorer l’analyse
- Convertir les données en tableau Excel dynamique
CREER DES TABLEAUX CROISES DYNAMIQUES
- Concevoir un tableau croisé dynamique à partir d’une base de données
- Ajouter et organiser les champs d’analyse
- Trier, filtrer et afficher les informations pertinentes
- Modifier les calculs :
- somme
- moyenne
- nombre
- minimum / maximum
- Réaliser des calculs en pourcentage ou en cumul
- Regrouper les données par date ou par tranche numérique
- Utiliser les segments et les chronologies pour filtrer rapidement
- Mettre à jour automatiquement les données
- Créer un graphique croisé dynamique associé
PERSONNALISER LA PRESENTATION DES ANALYSES
- Appliquer des styles et mises en forme adaptées
- Modifier la disposition du rapport
- Afficher ou masquer certains éléments
- Ajouter des sous-totaux et des totaux généraux
- Personnaliser les formats numériques
- Utiliser la mise en forme conditionnelle pour faire ressortir les indicateurs clés
- Exercices Pratiques Et Mises En Situation
- Réalisation de cas concrets
- Exercices guidés sur Excel
- Manipulations individuelles
- Création d’un tableau de synthèse complet à partir de données réelles
Public et Prérequis
Public Concerné
- tout public
Prérequis
Avoir les bases d’Excel : création de tableaux, formules simples, mise en forme
'%3e%3cg%20id='Groupe_3933'%20data-name='Groupe%203933'%20transform='translate(0%200)'%3e%3cpath%20id='Tracé_170'%20data-name='Tracé%20170'%20d='M41.961,30.793V53.9a3.278,3.278,0,0,1-3.278,3.278H3.634A3.278,3.278,0,0,1,.356,53.9V3.634A3.278,3.278,0,0,1,3.634.356H38.683a3.278,3.278,0,0,1,3.278,3.278V12.05'%20transform='translate(-0.356%20-0.356)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_171'%20data-name='Tracé%20171'%20d='M2.97,2.97V50.079H26.119l8.743-8.743v-6.89'%20transform='translate(1.887%201.887)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_175'%20data-name='Tracé%20175'%20d='M13.852,30.162l4.56,4.56L44.176,8.958a1.175,1.175,0,0,0,0-1.659l-2.9-2.9a1.173,1.173,0,0,0-1.658,0Z'%20transform='translate(11.226%202.819)'%20fill='none'%20stroke='%23fff'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_176'%20data-name='Tracé%20176'%20d='M19.967,22.665l-1.645,1.644-4.211,1.723L13.077,25,12.04,23.96l1.723-4.209L15.407,18.1'%20transform='translate(9.671%2014.876)'%20fill='none'%20stroke='%23fff'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cline%20id='Ligne_16'%20data-name='Ligne%2016'%20x1='2.176'%20y2='2.176'%20transform='translate(20.572%2039.872)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_177'%20data-name='Tracé%20177'%20d='M31.834,8.255,32.91,9.331a2.674,2.674,0,0,1,0,3.781l-8.057,8.057'%20transform='translate(20.667%206.423)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cline%20id='Ligne_17'%20data-name='Ligne%2017'%20x1='4.56'%20y1='4.56'%20transform='translate(43.964%2014.095)'%20fill='none'%20stroke='%23fff'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_178'%20data-name='Tracé%20178'%20d='M16.027,32.211,4.433,20.618V32.211Z'%20transform='translate(3.143%2017.033)'%20fill='%23eeeded'/%3e%3cline%20id='Ligne_25'%20data-name='Ligne%2025'%20x2='30.247'%20transform='translate(7.328%208.599)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_26'%20data-name='Ligne%2026'%20x2='30.247'%20transform='translate(7.328%2014.305)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_27'%20data-name='Ligne%2027'%20x2='23.969'%20transform='translate(7.328%2020.012)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_28'%20data-name='Ligne%2028'%20x2='17.691'%20transform='translate(7.328%2025.719)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_29'%20data-name='Ligne%2029'%20x2='11.984'%20transform='translate(7.328%2031.426)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
'%3e%3cg%20id='Groupe_3931'%20data-name='Groupe%203931'%20transform='translate(0%200)'%3e%3cpath%20id='Tracé_189'%20data-name='Tracé%20189'%20d='M48.525,24.619A23.906,23.906,0,1,0,24.619,48.526,23.906,23.906,0,0,0,48.525,24.619Z'%20transform='translate(-0.713%20-0.713)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_190'%20data-name='Tracé%20190'%20d='M49.983,45.512l8.725,8.724a3.163,3.163,0,0,1-4.473,4.473l-8.724-8.725'%20transform='translate(-3.891%20-3.891)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_191'%20data-name='Tracé%20191'%20d='M37.12,53.6A27.448,27.448,0,0,0,53.594,37.122'%20transform='translate(-3.296%20-3.296)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_23'%20data-name='Ligne%2023'%20y2='10.425'%20transform='translate(30.204%2030.026)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_24'%20data-name='Ligne%2024'%20y2='10.425'%20transform='translate(17.436%2030.026)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3ccircle%20id='Ellipse_3'%20data-name='Ellipse%203'%20cx='5.927'%20cy='5.927'%20r='5.927'%20transform='translate(17.979%206.09)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_192'%20data-name='Tracé%20192'%20d='M14.3,42.815V27.841a3.855,3.855,0,0,1,3.856-3.855H33.011a3.855,3.855,0,0,1,3.855,3.855V41.368'%20transform='translate(-1.677%20-2.364)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_193'%20data-name='Tracé%20193'%20d='M33.213,26.839H18.358a1.2,1.2,0,0,0-1.2,1.2v2.926a8.358,8.358,0,0,1,4.8-1.518h7.658a8.358,8.358,0,0,1,4.8,1.518h0V28.044a1.205,1.205,0,0,0-1.2-1.2'%20transform='translate(-1.879%20-2.567)'%20fill='%23eeeded'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
