{"id":631,"date":"2021-11-14T14:02:45","date_gmt":"2021-11-14T13:02:45","guid":{"rendered":"http:\/\/declick.be\/?page_id=631"},"modified":"2025-06-22T16:12:29","modified_gmt":"2025-06-22T14:12:29","slug":"8-excel-tableaux-croises-dynamiques","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/8-excel-tableaux-croises-dynamiques\/","title":{"rendered":"9. Excel &#8211; Tableaux crois\u00e9s dynamiques"},"content":{"rendered":"\n<p>L&rsquo;outil de synth\u00e9tisation les plus puissant d&rsquo;Excel. Gr\u00e2ce \u00e0 lui, vous pourrez obtenir des r\u00e9sultats de synth\u00e8se en quelques clics =&gt; \u00e0 conna\u00eetre absolument.<\/p>\n\n\n\n<p>Pour y arriver, vous pouvez t\u00e9l\u00e9charger les exercices ci-dessous :<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/TCD-Ex01.xlsx\">TCD-Ex01<\/a> : Quelques outils n\u00e9cessaires \u00e0 la cr\u00e9ation des liste de donn\u00e9es en Excel : les tableaux de donn\u00e9es, les listes d\u00e9roulantes, suppression des doublons + Comparaison entre diff\u00e9rentes m\u00e9thodes des synth\u00e9tisation des donn\u00e9es (utilisation des fonctions Excel &lt; > tableaux crois\u00e9s dynamiques) <\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/TCD-EX02.xlsx\">TCD-EX02<\/a> : \u00c9tude approfondie des TCD, propri\u00e9t\u00e9s diverses, regroupement, manipulations diverses, graphiques crois\u00e9s dynamique<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/TCD-Ex03.xlsx\">TCD-EX03<\/a> : \u00c9tude approfondie des TCD, exercices divers<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/TCD-Ex04.xlsx\">TCD-EX04<\/a> : Utilisation des listes, des fonctions + \u00c9tude des sous-totaux + Regroupements de donn\u00e9es provenant de diff\u00e9rents tableaux \u00e0 l&rsquo;aide de fonctions (ASSEMB.V, UNIQUE, TRIER, &#8230;)<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/11\/TCD-Ex05.xlsx\">TCD-EX05<\/a> : Cr\u00e9ation de TCD \u00e0 partir de donn\u00e9es de sources diff\u00e9rentes, ici Access<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/10\/TCD-Ex05-ATP.mdb\">TCD-EX05-ATP<\/a> : La base de donn\u00e9es Access utilis\u00e9e<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/TCD-Ex06.xlsx\">TCD-EX06<\/a> : Combinaison de plusieurs tableaux ayant de renseignements similaire en utilisant diff\u00e9rentes m\u00e9thodes (RechercheX, Relations dans un TCD, Power Query, Power Pivot), pour, par exemple, aller rechercher la ville d&rsquo;un client selon leCP dans un tableau qui reprend toutes les CP et villes.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>L&rsquo;outil de synth\u00e9tisation les plus puissant d&rsquo;Excel. Gr\u00e2ce \u00e0 lui, vous pourrez obtenir des r\u00e9sultats de synth\u00e8se en quelques clics =&gt; \u00e0 conna\u00eetre absolument. Pour y arriver, vous pouvez t\u00e9l\u00e9charger les exercices ci-dessous :&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-631","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/comments?post=631"}],"version-history":[{"count":20,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/631\/revisions"}],"predecessor-version":[{"id":2063,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/631\/revisions\/2063"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}