{"id":134710,"date":"2022-06-10T11:26:43","date_gmt":"2022-06-10T15:26:43","guid":{"rendered":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/"},"modified":"2022-08-14T19:25:17","modified_gmt":"2022-08-14T23:25:17","slug":"u25742-excel-tableaux-croises-dynamiques-presentiel","status":"publish","type":"evenements","link":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/","title":{"rendered":"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel"},"content":{"rendered":"<div data-dzwrap=\"true\">\n<p><em><strong>Cette formation se fait en pr\u00e9sentiel, la\u00a0capacit\u00e9 maximale pour la formation\u00a0 est de 12 personnes.<\/strong><\/em><br \/><em><strong>Nos salles sont adapt\u00e9es pour des formations en pr\u00e9sentiel selon les mesures sanitaires.<\/strong><\/em><\/p>\n<h2>Description<\/h2>\n<p><strong>Objectif :<\/strong>\u00a0Concevoir et monter un tableau de donn\u00e9es pour arriver \u00e0 r\u00e9aliser des tableaux crois\u00e9s dynamiques\u00a0avec le Excel.<\/p>\n<p>Cette formation s\u2019adresse \u00e0 vous si vous d\u00e9sirez apprendre \u00e0 :<\/p>\n<ul>\n<li>Organiser une grande quantit\u00e9 de donn\u00e9es,<\/li>\n<li>Synth\u00e9tiser ses donn\u00e9es avec un tableau crois\u00e9 dynamique,<\/li>\n<li>Sortir ses statistiques pour produire ses rapports.<\/li>\n<\/ul>\n<p><i>Pour plus d\u2019information sur cette formation, contactez-nous !<\/i><\/p>\n<p><strong>Client\u00e8le vis\u00e9e<\/strong><br \/>Personnes novices et utilisateurs cherchant \u00e0 am\u00e9liorer leurs acquis<\/p>\n<p><b>Date:<\/b><\/p>\n<p><b\/>14 et 16 juin 2022<\/p>\n<p><b>Dur\u00e9e:<\/b><\/p>\n<p>6<b>\u00a0<\/b>heures (sur 2 jours)<b><br \/><\/b><\/p>\n<p><strong>Horaire: <\/strong><\/p>\n<p>9h-12h<\/p>\n<p><strong>Co\u00fbt:<\/strong><\/p>\n<p>100$<\/p>\n<p><strong>Pr\u00e9requis:<\/strong><\/p>\n<p>\u00catre en mesure d\u2019entrer des donn\u00e9es dans Excel<\/p>\n<p><strong>R\u00e9sum\u00e9 du contenu de la formation Excel<\/strong><\/p>\n<p>Cr\u00e9er des tableaux<\/p>\n<ul>\n<li>D\u00e9finir un tableau de donn\u00e9es<\/li>\n<li>Indiquer les limites du tableau<\/li>\n<li>Manipuler les donn\u00e9es<\/li>\n<li>Calculer des sous-totaux<\/li>\n<li>Filtrer des donn\u00e9es<\/li>\n<li>Valider des donn\u00e9es<\/li>\n<\/ul>\n<p>Cr\u00e9er des tableaux crois\u00e9s dynamiques<\/p>\n<ul>\n<li>Comprendre l\u2019utilit\u00e9<\/li>\n<li>Cr\u00e9er un tableau crois\u00e9 dynamique \u00e0 partir d\u2019une liste ou d\u2019une base de donn\u00e9es Excel<\/li>\n<li>Modifier la mise en forme et la mise en page<\/li>\n<li>Modifier les fonctions de synth\u00e8se<\/li>\n<li>Filtrer des donn\u00e9es<\/li>\n<li>Grouper les \u00e9l\u00e9ments<\/li>\n<li>Filtrer avec les segments<\/li>\n<li>Cr\u00e9er un graphique \u00e0 partir du tableau<\/li>\n<\/ul>\n<p><em>Je m&rsquo;inscris \u00e0 la formtion:<\/em><\/p>\n<p><a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-realiser-des-tableaux-croises-dynamiques-2\/\" target=\"_new\" rel=\"noopener\">https:\/\/lapuce.org\/formations\/excel-realiser-des-tableaux-croises-dynamiques-2\/<\/a><\/p>\n<p><em\/><\/p>\n<p><em\/><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cette formation se fait en pr\u00e9sentiel, la\u00a0capacit\u00e9 maximale pour la formation\u00a0 est de 12 personnes. Nos salles sont adapt\u00e9es pour des formations en pr\u00e9sentiel selon les mesures sanitaires. Descript&#8230;<\/p>\n<p><a href=\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/\">read more<\/a><\/p>","protected":false},"author":433,"featured_media":134978,"comment_status":"open","ping_status":"closed","template":"","thematiques":[167],"regions":[98,80],"class_list":["post-134710","evenements","type-evenements","status-publish","has-post-thumbnail","hentry","thematiques-education-populaire","regions-le-plateau-mont-royal","regions-montreal"],"acf":{"evenement_date":"2022-06-14","evenement_date_fin":"2022-06-14","evenement_heure_debut":"09:00:00","evenement_heure_fin":"12:00:00","evenement_recurrence":false,"evenement_recurrence_jours":1,"evenement_recurrence_hebdomadaire":[],"evenement_recurrence_mensuelle_2":[],"evenement_recurrence_fin":null,"evenement_lieu":"","evenement_adresse":"","evenement_site_web":"","evenement_inscription":"","evenement_couts":false,"evenement_frais":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel - Ma Communaut\u00e9<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel - Ma Communaut\u00e9\" \/>\n<meta property=\"og:description\" content=\"Cette formation se fait en pr\u00e9sentiel, la\u00a0capacit\u00e9 maximale pour la formation\u00a0 est de 12 personnes. Nos salles sont adapt\u00e9es pour des formations en pr\u00e9sentiel selon les mesures sanitaires. Descript...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/\" \/>\n<meta property=\"og:site_name\" content=\"Ma Communaut\u00e9\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-14T23:25:17+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/\",\"url\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/\",\"name\":\"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel - Ma Communaut\u00e9\",\"isPartOf\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#website\"},\"datePublished\":\"2022-06-10T15:26:43+00:00\",\"dateModified\":\"2022-08-14T23:25:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/dev.totemweb.design\/macommunaute\/?_sft_regions=montreal\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00c9v\u00e9nements\",\"item\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#website\",\"url\":\"https:\/\/dev.totemweb.design\/macommunaute\/\",\"name\":\"Ma Communaut\u00e9\",\"description\":\"MaCommunaute.ca offre la possibilit\u00e9 aux citoyens de trouver facilement tous les services des organismes \u00e0 but non lucratif partout au Qu\u00e9bec\",\"publisher\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.totemweb.design\/macommunaute\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#organization\",\"name\":\"Ma Communaut\u00e9 - Un monde autour de vous\",\"url\":\"https:\/\/dev.totemweb.design\/macommunaute\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dev.totemweb.design\/macommunaute\/wp-content\/uploads\/MaCommunaute.ca_Logo.png\",\"contentUrl\":\"https:\/\/dev.totemweb.design\/macommunaute\/wp-content\/uploads\/MaCommunaute.ca_Logo.png\",\"width\":440,\"height\":155,\"caption\":\"Ma Communaut\u00e9 - Un monde autour de vous\"},\"image\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel - Ma Communaut\u00e9","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"fr_FR","og_type":"article","og_title":"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel - Ma Communaut\u00e9","og_description":"Cette formation se fait en pr\u00e9sentiel, la\u00a0capacit\u00e9 maximale pour la formation\u00a0 est de 12 personnes. Nos salles sont adapt\u00e9es pour des formations en pr\u00e9sentiel selon les mesures sanitaires. Descript...","og_url":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/","og_site_name":"Ma Communaut\u00e9","article_modified_time":"2022-08-14T23:25:17+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/","url":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/","name":"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel - Ma Communaut\u00e9","isPartOf":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/#website"},"datePublished":"2022-06-10T15:26:43+00:00","dateModified":"2022-08-14T23:25:17+00:00","breadcrumb":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25742-excel-tableaux-croises-dynamiques-presentiel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/dev.totemweb.design\/macommunaute\/?_sft_regions=montreal"},{"@type":"ListItem","position":2,"name":"\u00c9v\u00e9nements","item":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/"},{"@type":"ListItem","position":3,"name":"Excel- Tableaux crois\u00e9s dynamiques-Pr\u00e9sentiel"}]},{"@type":"WebSite","@id":"https:\/\/dev.totemweb.design\/macommunaute\/#website","url":"https:\/\/dev.totemweb.design\/macommunaute\/","name":"Ma Communaut\u00e9","description":"MaCommunaute.ca offre la possibilit\u00e9 aux citoyens de trouver facilement tous les services des organismes \u00e0 but non lucratif partout au Qu\u00e9bec","publisher":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.totemweb.design\/macommunaute\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/dev.totemweb.design\/macommunaute\/#organization","name":"Ma Communaut\u00e9 - Un monde autour de vous","url":"https:\/\/dev.totemweb.design\/macommunaute\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/dev.totemweb.design\/macommunaute\/#\/schema\/logo\/image\/","url":"https:\/\/dev.totemweb.design\/macommunaute\/wp-content\/uploads\/MaCommunaute.ca_Logo.png","contentUrl":"https:\/\/dev.totemweb.design\/macommunaute\/wp-content\/uploads\/MaCommunaute.ca_Logo.png","width":440,"height":155,"caption":"Ma Communaut\u00e9 - Un monde autour de vous"},"image":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements\/134710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements"}],"about":[{"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/types\/evenements"}],"author":[{"embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/users\/433"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/comments?post=134710"}],"version-history":[{"count":1,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements\/134710\/revisions"}],"predecessor-version":[{"id":134981,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements\/134710\/revisions\/134981"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/media\/134978"}],"wp:attachment":[{"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/media?parent=134710"}],"wp:term":[{"taxonomy":"thematiques","embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/thematiques?post=134710"},{"taxonomy":"regions","embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/regions?post=134710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}