{"id":5934,"date":"2023-07-24T14:28:42","date_gmt":"2023-07-24T12:28:42","guid":{"rendered":"https:\/\/xylos.dbf-beta.be\/trainings\/excel-jongler-avec-des-pivottables\/"},"modified":"2025-12-08T09:45:12","modified_gmt":"2025-12-08T08:45:12","slug":"excel-jongler-avec-des-pivottables","status":"publish","type":"trainings","link":"https:\/\/xylos.com\/fr\/formations\/microsoft-365\/excel\/excel-jongler-avec-des-pivottables\/","title":{"rendered":"Excel: PivotTables"},"content":{"rendered":"<div class=\"nectar-video-wrap row-bg-layer position-loaded\" data-bg-alignment=\"\">\n<div class=\"nectar-video-inner\">\n<h2>Description<\/h2>\n<div class=\"contentOmschrijving\">\n<div class=\"contentOmschrijving\">\n<div class=\"contentOmschrijving\">\n<p>Vous travaillez avec une grande liste de donn\u00e9es dans Excel ? Pour vous y retrouver, les tableaux crois\u00e9s dynamiques vous offrent une jolie vue d\u2019ensemble de vos donn\u00e9es rassembl\u00e9es. Apr\u00e8s cette partie, vous savez du premier coup d\u2019\u0153il combien d\u2019\u00e9l\u00e9ments r\u00e9pondent \u00e0 une condition sp\u00e9cifique. Vous apprenez aussi \u00e0 faire des analyses \u00e0 l\u2019aide de diff\u00e9rents param\u00e8tres, tels que la langue, la r\u00e9gion ou n\u2019importe quelle colonne de votre tableau. Bref, optimisez l\u2019analyse de vos donn\u00e9es gr\u00e2ce aux \u00e9normes atouts des tableaux crois\u00e9s dynamiques Excel.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"contentObjectieven\">\n<h2>Objectifs<\/h2>\n<h4>Apr\u00e8s cette formation \u00e0 distance Excel PivotTables :<\/h4>\n<div class=\"contentObjectieven\">\n<div class=\"contentObjectieven\">\n<ul>\n<li>Vous \u00e9tablissez les bonnes bases pour cr\u00e9er des PivotTables<\/li>\n<li>Vous connaissez la force des PivotTables<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"contentDoelgroep\">\n<h2>Groupe cible<\/h2>\n<div class=\"contentDoelgroep\">\n<div class=\"contentDoelgroep\">\n<div class=\"contentDoelgroep\">\n<p>Employ\u00e9s qui travaillent r\u00e9guli\u00e8rement avec des listes de donn\u00e9es dans Excel et veulent analyser leurs donn\u00e9es.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"row_col_wrap_12 col span_12 dark left\">\n<div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n<div class=\"vc_column-inner\">\n<div class=\"wpb_wrapper\">\n<div id=\"fws_64bab3c90d651\" class=\"wpb_row vc_row-fluid vc_row inner_row\" data-midnight=\"\" data-column-margin=\"default\">\n<div class=\"row_col_wrap_12_inner col span_12 left\">\n<div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col child_column padding-10-percent inherit_tablet inherit_phone \" data-padding-pos=\"right\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n<div class=\"vc_column-inner\">\n<div class=\"wpb_wrapper\">\n<div class=\"wpb_text_column wpb_content_element \">\n<div class=\"wpb_wrapper\">\n<div class=\"contentVoorkennis\">\n<h2>Pr\u00e9requis<\/h2>\n<div class=\"contentVoorkennis\">\n<div class=\"contentVoorkennis\">\n<div class=\"contentVoorkennis\">\n<div class=\"contentVoorkennis\">\n<div class=\"contentVoorkennis\">\n<div class=\"contentVoorkennis\">\n<div class=\"contentVoorkennis\">\n<p>Les participants ont suivi le cours <a href=\"https:\/\/xylos.com\/fr\/formations\/microsoft-365\/excel\/excel-travailler-avec-des-listes-et-des-tableaux\/\" target=\"_blank\" rel=\"noopener\">Excel \u00ab listes et tableaux<\/a> \u00bb ou poss\u00e8dent des connaissances \u00e9quivalentes.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"contentInhoud\">\n<h2>Contenu<\/h2>\n<h4><em>Travailler avec des PivotTables<\/em><\/h4>\n<ul>\n<li>Utiliser des Recommended PivotTables<\/li>\n<li>Les diff\u00e9rentes parties d&rsquo;un tableau crois\u00e9 dynamique : les champs de filtre, les champs de ligne, les champs de colonne et les valeurs.<\/li>\n<li>Disposition et structure d&rsquo;un tableau crois\u00e9 dynamique : style, disposition des calculs, disposition du rapport (compact, contour, tabulaire)<\/li>\n<li>Sous-totaux : activation, suppression, activation uniquement pour certains champs<\/li>\n<li>Visualisation diff\u00e9rente des calculs : % du total g\u00e9n\u00e9ral, % du total des lignes, etc.<\/li>\n<li>Regrouper des donn\u00e9es : texte, dates, chiffres<\/li>\n<li>Qu\u2019est-ce que le PivotCache ?<\/li>\n<li>Filtrer les tableaux crois\u00e9s dynamiques \u00e0 l&rsquo;aide de slicers (slicers g\u00e9n\u00e9raux et slicers temporels)<\/li>\n<li><strong>Introduction \u00e0 Power Pivot<\/strong> : cr\u00e9er un PivotTable bas\u00e9 sur plusieurs tableaux<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"featured_media":15453,"parent":6795,"menu_order":55,"template":"","tools":[],"type-training":[68,66],"training-software":[65],"class_list":["post-5934","trainings","type-trainings","status-publish","has-post-thumbnail","hentry","type-training-formation-a-distance","type-training-formation-classique","training-software-microsoft-365"],"_links":{"self":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/trainings\/5934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/trainings"}],"about":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/types\/trainings"}],"up":[{"embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/trainings\/6795"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/media\/15453"}],"wp:attachment":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/media?parent=5934"}],"wp:term":[{"taxonomy":"tools","embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/tools?post=5934"},{"taxonomy":"type-training","embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/type-training?post=5934"},{"taxonomy":"training-software","embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/training-software?post=5934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}