{"id":2363,"date":"2026-08-31T11:42:46","date_gmt":"2026-08-31T11:42:46","guid":{"rendered":"https:\/\/ceref.helha.be\/education\/?page_id=2363"},"modified":"2026-09-01T09:31:33","modified_gmt":"2026-09-01T09:31:33","slug":"le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees","status":"publish","type":"page","link":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/","title":{"rendered":"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es"},"content":{"rendered":"<h1><span style=\"font-size: 18pt\">Formation 190902602\/62682 &#8211; 62683<\/span><\/h1>\n<h2>Public Cible<\/h2>\n<p>Membre du personnel de l&rsquo;enseignement fondamental ou secondaire, ordinaire ou sp\u00e9cialis\u00e9; agent PMS<\/p>\n<p>Pr\u00e9requis : ma\u00eetriser les fonctions basiques d&rsquo;Excel<\/p>\n<h2>Objectifs au terme de cette formation<\/h2>\n<ul>\n<li><span style=\"font-size: 14pt\">A partir d\u2019activit\u00e9s vari\u00e9es issues du contexte d\u2019administration scolaire, d\u00e9couvrir les fonctionnalit\u00e9s les plus utiles du tableur.<\/span><\/li>\n<li><span style=\"font-size: 14pt\">A partir d\u2019activit\u00e9s vari\u00e9es issues du contexte d\u2019administration scolaire, d\u00e9couvrir les fonctions les plus utiles du tableur.<\/span><\/li>\n<li><span style=\"font-size: 14pt\">Approfondir la syntaxe des formules et l\u2019interpr\u00e9tation des codes d\u2019erreur.<\/span><\/li>\n<li><span style=\"font-size: 14pt\">Identifier les ressources disponibles de qualit\u00e9 pour d\u00e9velopper l\u2019autonomie et l\u2019assurance des participants (tutoriels, vid\u00e9os, etc.).<\/span><\/li>\n<\/ul>\n<h2>Pr\u00e9sentation<span style=\"font-size: 14pt;color: #333333\"><strong><span style=\"color: #ff9900\"><br \/>\n<\/span><\/strong><\/span><\/h2>\n<p><span style=\"font-size: 14pt\">Cette formation propose de d\u00e9couvrir comment le tableur peut soutenir l\u2019organisation, l\u2019analyse et le pilotage de donn\u00e9es dans diff\u00e9rents contextes li\u00e9s \u00e0 l\u2019\u00e9cole : administration, suivi d\u2019\u00e9l\u00e8ves, coordination p\u00e9dagogique, projets, CPMS ou p\u00f4les territoriaux. \u00c0 partir de situations concr\u00e8tes, les participants apprendront \u00e0 importer, structurer, trier et filtrer des donn\u00e9es, \u00e0 utiliser des formules courantes et avanc\u00e9es, ainsi que le formatage conditionnel pour faciliter l\u2019analyse. L\u2019organisation sur deux journ\u00e9es permet une progression entre prise en main, automatisation, exploitation de donn\u00e9es et transfert dans les pratiques professionnelles. La formation sensibilise au RGPD en lien avec les donn\u00e9es trait\u00e9es, questionne les biais li\u00e9s aux st\u00e9r\u00e9otypes de genre dans les usages num\u00e9riques, \u00e9tablit des liens avec PIX et explore l\u2019apport potentiel de l\u2019IA pour aider \u00e0 structurer un tableau, formuler des calculs et d&rsquo;analyser des donn\u00e9es de mani\u00e8re critique et responsable.<\/span><\/p>\n<h2>Formateur(s)<\/h2>\n<ul>\n<li>Dominique MEES<\/li>\n<\/ul>\n<h2>Dur\u00e9e<\/h2>\n<p>2 jours :<\/p>\n<p>date 1 : Jeudi 8\/10\/2026 de 9:00 \u00e0 16:00<br \/>\n(HELHa &#8211; local : Campus)<\/p>\n<p>date 2 : Vendredi 9\/10\/2026 de 9:00 \u00e0 16:00<br \/>\n(HELHa &#8211; local : Campus)<\/p>\n<p>OU<\/p>\n<p>date 1 : Jeudi 14\/01\/2027 de 9:00 \u00e0 16:00<br \/>\n(HELHa &#8211; local : Campus)<\/p>\n<p>date 2 : Vendredi 15\/01\/2027 de 9:00 \u00e0 16:00<br \/>\n(HELHa &#8211; local : Campus)<\/p>\n<h2>Lieu(x)<\/h2>\n<p><b>HELHa<\/b><br \/>\nlocal : Campus<br \/>\nChauss\u00e9e de Binche 159<br \/>\n7000 Mons<\/p>\n<p>Inscription : <a href=\"https:\/\/ifpc-fwb.be\/v5\/fcc_viewformListKC.asp?CF=190902602&amp;dist=0&amp;placeDispo=0&amp;par=ALL_ALL_190902602____1___0_0__0__0\">Liste des sessions de la formation 190902602 | IFPC<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formation 190902602\/62682 &#8211; 62683 Public Cible Membre du personnel de l&rsquo;enseignement fondamental ou secondaire, ordinaire ou sp\u00e9cialis\u00e9; agent PMS Pr\u00e9requis : ma\u00eetriser les fonctions basiques d&rsquo;Excel Objectifs au terme de cette formation A partir d\u2019activit\u00e9s vari\u00e9es issues du contexte d\u2019administration scolaire, d\u00e9couvrir les fonctionnalit\u00e9s les plus utiles du tableur. A partir d\u2019activit\u00e9s vari\u00e9es issues du [&hellip;]<\/p>\n","protected":false},"author":50,"featured_media":0,"parent":2171,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-2363","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es - CeREF \u00c9ducation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es - CeREF \u00c9ducation\" \/>\n<meta property=\"og:description\" content=\"Formation 190902602\/62682 &#8211; 62683 Public Cible Membre du personnel de l&rsquo;enseignement fondamental ou secondaire, ordinaire ou sp\u00e9cialis\u00e9; agent PMS Pr\u00e9requis : ma\u00eetriser les fonctions basiques d&rsquo;Excel Objectifs au terme de cette formation A partir d\u2019activit\u00e9s vari\u00e9es issues du contexte d\u2019administration scolaire, d\u00e9couvrir les fonctionnalit\u00e9s les plus utiles du tableur. A partir d\u2019activit\u00e9s vari\u00e9es issues du [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/\" \/>\n<meta property=\"og:site_name\" content=\"CeREF \u00c9ducation\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Ceref.helha\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-01T09:31:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/\",\"url\":\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/\",\"name\":\"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es - CeREF \u00c9ducation\",\"isPartOf\":{\"@id\":\"https:\/\/ceref.helha.be\/education\/#website\"},\"datePublished\":\"2026-08-31T11:42:46+00:00\",\"dateModified\":\"2026-09-01T09:31:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ceref.helha.be\/education\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/ceref.helha.be\/education\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Formations pour les enseignant\u00b7e\u00b7s\",\"item\":\"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ceref.helha.be\/education\/#website\",\"url\":\"https:\/\/ceref.helha.be\/education\/\",\"name\":\"CeREF \u00c9ducation - Centre de Recherche et de Formation continue de la HELHa\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ceref.helha.be\/education\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ceref.helha.be\/education\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ceref.helha.be\/education\/#organization\",\"name\":\"CeREF \u00c9ducation - Centre de Recherche et de Formation continue de la HELHa\",\"url\":\"https:\/\/ceref.helha.be\/education\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/ceref.helha.be\/education\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ceref.helha.be\/education\/app\/uploads\/2026\/01\/ceref-education.jpg\",\"contentUrl\":\"https:\/\/ceref.helha.be\/education\/app\/uploads\/2026\/01\/ceref-education.jpg\",\"width\":242,\"height\":84,\"caption\":\"CeREF \u00c9ducation - Centre de Recherche et de Formation continue de la HELHa\"},\"image\":{\"@id\":\"https:\/\/ceref.helha.be\/education\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Ceref.helha\",\"https:\/\/www.linkedin.com\/company\/ceref-helha\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es - CeREF \u00c9ducation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/","og_locale":"fr_FR","og_type":"article","og_title":"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es - CeREF \u00c9ducation","og_description":"Formation 190902602\/62682 &#8211; 62683 Public Cible Membre du personnel de l&rsquo;enseignement fondamental ou secondaire, ordinaire ou sp\u00e9cialis\u00e9; agent PMS Pr\u00e9requis : ma\u00eetriser les fonctions basiques d&rsquo;Excel Objectifs au terme de cette formation A partir d\u2019activit\u00e9s vari\u00e9es issues du contexte d\u2019administration scolaire, d\u00e9couvrir les fonctionnalit\u00e9s les plus utiles du tableur. A partir d\u2019activit\u00e9s vari\u00e9es issues du [&hellip;]","og_url":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/","og_site_name":"CeREF \u00c9ducation","article_publisher":"https:\/\/www.facebook.com\/Ceref.helha","article_modified_time":"2026-09-01T09:31:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/","url":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/","name":"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es - CeREF \u00c9ducation","isPartOf":{"@id":"https:\/\/ceref.helha.be\/education\/#website"},"datePublished":"2026-08-31T11:42:46+00:00","dateModified":"2026-09-01T09:31:33+00:00","breadcrumb":{"@id":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/le-tableau-excel-au-service-de-lecole-gagner-du-temps-et-piloter-ses-donnees\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ceref.helha.be\/education\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/ceref.helha.be\/education\/formations\/"},{"@type":"ListItem","position":3,"name":"Formations pour les enseignant\u00b7e\u00b7s","item":"https:\/\/ceref.helha.be\/education\/formations\/enseignants\/"},{"@type":"ListItem","position":4,"name":"Le tableau (Excel) au service de l\u2019\u00e9cole : gagner du temps et piloter ses donn\u00e9es"}]},{"@type":"WebSite","@id":"https:\/\/ceref.helha.be\/education\/#website","url":"https:\/\/ceref.helha.be\/education\/","name":"CeREF \u00c9ducation - Centre de Recherche et de Formation continue de la HELHa","description":"","publisher":{"@id":"https:\/\/ceref.helha.be\/education\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ceref.helha.be\/education\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/ceref.helha.be\/education\/#organization","name":"CeREF \u00c9ducation - Centre de Recherche et de Formation continue de la HELHa","url":"https:\/\/ceref.helha.be\/education\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ceref.helha.be\/education\/#\/schema\/logo\/image\/","url":"https:\/\/ceref.helha.be\/education\/app\/uploads\/2026\/01\/ceref-education.jpg","contentUrl":"https:\/\/ceref.helha.be\/education\/app\/uploads\/2026\/01\/ceref-education.jpg","width":242,"height":84,"caption":"CeREF \u00c9ducation - Centre de Recherche et de Formation continue de la HELHa"},"image":{"@id":"https:\/\/ceref.helha.be\/education\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Ceref.helha","https:\/\/www.linkedin.com\/company\/ceref-helha\/"]}]}},"_links":{"self":[{"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/pages\/2363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/comments?post=2363"}],"version-history":[{"count":4,"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/pages\/2363\/revisions"}],"predecessor-version":[{"id":2474,"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/pages\/2363\/revisions\/2474"}],"up":[{"embeddable":true,"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/pages\/2171"}],"wp:attachment":[{"href":"https:\/\/ceref.helha.be\/education\/wp-json\/wp\/v2\/media?parent=2363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}