{"id":629,"date":"2021-11-14T14:02:45","date_gmt":"2021-11-14T13:02:45","guid":{"rendered":"http:\/\/declick.be\/?page_id=629"},"modified":"2024-11-11T14:16:41","modified_gmt":"2024-11-11T13:16:41","slug":"7-excel-tableaux-de-donnees","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/7-excel-tableaux-de-donnees\/","title":{"rendered":"7. Excel &#8211; Tableaux de donn\u00e9es"},"content":{"rendered":"\n<p>Vous trouverez ici la fiche programme de cours : <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/10\/Excel-Tableau-de-Donnees-1j-Fiche-programme.docx\">Excel Tableau de Donn\u00e9es 1j &#8211; Fiche programme<\/a><\/p>\n\n\n\n<p>Lors de ce cours seront abord\u00e9s les outils de synth\u00e9tisation principaux d&rsquo;Excel qui permettent d&rsquo;obtenir des r\u00e9sultats \u00e0 partir de listes de donn\u00e9es. Par exemple, obtenir rapidement une liste des hommes de plus de 35 ans, obtenir le salaire moyen des employ\u00e9s d&rsquo;une soci\u00e9t\u00e9 par sexe et par commune, &#8230;<\/p>\n\n\n\n<p>Un parall\u00e8le sera fait entre des outils \u00ab\u00a0classiques\u00a0\u00bb (les fonctions \u00ab\u00a0classiques\u00a0\u00bb d&rsquo;Excel), des outils plus \u00ab\u00a0automatiques\u00a0\u00bb (Sous-totaux, tableaux crois\u00e9s dynamiques) et des outils \u00ab\u00a0assist\u00e9s\u00a0\u00bb (tableaux de donn\u00e9es) avec la compr\u00e9hension des formules issues de ces tableaux de donn\u00e9es.<\/p>\n\n\n\n<p><p style=\"text-align: left;\">Ceci se fera par l&rsquo;utilisation de 2 fichiers. Le premier reprend l&rsquo;\u00e9tude compl\u00e8te des points de mati\u00e8re de ce cours, le second comprend d&rsquo;autres exercices sur la mise en \u0153uvre des filtres avanc\u00e9s.<\/p><\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-e230b5ba-9fd7-408d-9de5-5480dcf687ae\" href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/11\/1-Excel20xx-Tableaux-de-donnees.xlsm\">1-Excel20xx-Tableaux-de-donnees<\/a><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/11\/1-Excel20xx-Tableaux-de-donnees.xlsm\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-e230b5ba-9fd7-408d-9de5-5480dcf687ae\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-561663f9-c06a-47a4-a565-b6738c2875a5\" href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/11\/2-Excel20xx-ExerciceSupSi_Filtres.xlsm\">2-Excel20xx-ExerciceSupSi_Filtres<\/a><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/11\/2-Excel20xx-ExerciceSupSi_Filtres.xlsm\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-561663f9-c06a-47a4-a565-b6738c2875a5\">T\u00e9l\u00e9charger<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Vous trouverez ici la fiche programme de cours : Excel Tableau de Donn\u00e9es 1j &#8211; Fiche programme Lors de ce cours seront abord\u00e9s les outils de synth\u00e9tisation principaux d&rsquo;Excel qui permettent d&rsquo;obtenir des r\u00e9sultats&#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-629","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/629","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=629"}],"version-history":[{"count":16,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/629\/revisions"}],"predecessor-version":[{"id":1876,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/629\/revisions\/1876"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}