{"id":1951,"date":"2025-01-15T15:46:49","date_gmt":"2025-01-15T14:46:49","guid":{"rendered":"https:\/\/declick.be\/?page_id=1951"},"modified":"2025-01-16T09:06:50","modified_gmt":"2025-01-16T08:06:50","slug":"walagri-arvesta-tcd-t-donnees-graphiques","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/walagri-arvesta-tcd-t-donnees-graphiques\/","title":{"rendered":"Walagri &#8211; Arvesta &#8211; TCD-T.Donn\u00e9es-Graphiques"},"content":{"rendered":"\n<p>Ce cours va permettre d&rsquo;approfondir des notions abord\u00e9es durant le cours d&rsquo;Excel avanc\u00e9 (liste de valeurs, tableau de donn\u00e9es, r\u00e9f\u00e9rence de cellules, tableaux crois\u00e9s dynamiques) et d&rsquo;introduire des notions sp\u00e9cifiques de l&rsquo;utilisation d&rsquo;Excel (Power Query)<\/p>\n\n\n\n<p>Les fichiers utilis\u00e9s se trouvent ci-dessous et traitent des diff\u00e9rentes mati\u00e8res renseign\u00e9es dans leur descriptif :<\/p>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/01\/RechercheX-1.xlsm\">0_RechercheX<\/a> : utilisation de la RechercheX par valeur proche et mises en forme conditionnelle selon les demandes des participants. Cet exercice a \u00e9t\u00e9 vu au cours d&rsquo;Excel avanc\u00e9.<\/p>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/01\/1_TCD-Ex01.xlsx\">1_TCD-Ex01.xlsx<\/a> : les tableaux de donn\u00e9es, utilisation des listes de choix, r\u00e9f\u00e9rence de cellules, utilisation de formules par \u00ab\u00a0propagation\u00a0\u00bb, parall\u00e8le entre regroupement par formule et par TCD<\/p>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/01\/2_TCD-Ex02.xlsx\">2_TCD-Ex02.xlsx<\/a> : les tableaux crois\u00e9s dynamiques<\/p>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/01\/3_TCD-Ex02b-1.xlsx\">3_TCD-Ex02b.xlsx<\/a> : la notion de relation entre tableaux de donn\u00e9es &#8211; TCD ayant comme source 2 tableaux &#8211; Introduction \u00e0 Power Query<\/p>\n\n\n\n<p><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/01\/4_TCD-Ex03.xlsm\">4_TCD-Ex03.xlsm<\/a> : exercices suppl\u00e9mentaires sur la fonction SI et les filtres automatiques &#8211; TCD et graphiques crois\u00e9s dynamiques &#8211; Un peu plus de Power Query<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ce cours va permettre d&rsquo;approfondir des notions abord\u00e9es durant le cours d&rsquo;Excel avanc\u00e9 (liste de valeurs, tableau de donn\u00e9es, r\u00e9f\u00e9rence de cellules, tableaux crois\u00e9s dynamiques) et d&rsquo;introduire des notions sp\u00e9cifiques de l&rsquo;utilisation d&rsquo;Excel (Power&#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-1951","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/1951","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=1951"}],"version-history":[{"count":8,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/1951\/revisions"}],"predecessor-version":[{"id":1972,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/1951\/revisions\/1972"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=1951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}