{"id":135421,"date":"2022-04-11T09:04:28","date_gmt":"2022-04-11T13:04:28","guid":{"rendered":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/"},"modified":"2022-04-11T09:04:28","modified_gmt":"2022-04-11T13:04:28","slug":"u25566-excel-tableaux-croises-dynamiques-formation-en-ligne","status":"publish","type":"evenements","link":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/","title":{"rendered":"Excel- Tableaux crois\u00e9s dynamiques (formation en ligne)"},"content":{"rendered":"<div data-dzwrap=\"true\">\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 19 avril 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>13h00-16h00<\/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><em><a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-realiser-des-tableaux-croises-dynamiques-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/lapuce.org\/formations\/excel-realiser-des-tableaux-croises-dynamiques-2\/<\/a>\u00a0<\/em><\/p>\n<p><em\/><\/p>\n<p><em\/><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Objectif :\u00a0Concevoir et monter un tableau de donn\u00e9es pour arriver \u00e0 r\u00e9aliser des tableaux crois\u00e9s dynamiques\u00a0avec le Excel. Cette formation s\u2019adresse \u00e0 vous si vous d\u00e9sirez apprendre \u00e0&#8230;<\/p>\n<p><a href=\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/\">read more<\/a><\/p>","protected":false},"author":433,"featured_media":135417,"comment_status":"open","ping_status":"closed","template":"","thematiques":[167],"regions":[98,80],"class_list":["post-135421","evenements","type-evenements","status-publish","has-post-thumbnail","hentry","thematiques-education-populaire","regions-le-plateau-mont-royal","regions-montreal"],"acf":{"evenement_date":"2022-04-14","evenement_date_fin":"2022-04-14","evenement_heure_debut":"13:00:00","evenement_heure_fin":"16: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 (formation en ligne) - 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 (formation en ligne) - Ma Communaut\u00e9\" \/>\n<meta property=\"og:description\" content=\"Description Objectif :\u00a0Concevoir et monter un tableau de donn\u00e9es pour arriver \u00e0 r\u00e9aliser des tableaux crois\u00e9s dynamiques\u00a0avec le Excel. Cette formation s\u2019adresse \u00e0 vous si vous d\u00e9sirez apprendre \u00e0...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/\" \/>\n<meta property=\"og:site_name\" content=\"Ma Communaut\u00e9\" \/>\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\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/\",\"url\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/\",\"name\":\"Excel- Tableaux crois\u00e9s dynamiques (formation en ligne) - Ma Communaut\u00e9\",\"isPartOf\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#website\"},\"datePublished\":\"2022-04-11T13:04:28+00:00\",\"dateModified\":\"2022-04-11T13:04:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/#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 (formation en ligne)\"}]},{\"@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 (formation en ligne) - 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 (formation en ligne) - Ma Communaut\u00e9","og_description":"Description Objectif :\u00a0Concevoir et monter un tableau de donn\u00e9es pour arriver \u00e0 r\u00e9aliser des tableaux crois\u00e9s dynamiques\u00a0avec le Excel. Cette formation s\u2019adresse \u00e0 vous si vous d\u00e9sirez apprendre \u00e0...","og_url":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/","og_site_name":"Ma Communaut\u00e9","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\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/","url":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/","name":"Excel- Tableaux crois\u00e9s dynamiques (formation en ligne) - Ma Communaut\u00e9","isPartOf":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/#website"},"datePublished":"2022-04-11T13:04:28+00:00","dateModified":"2022-04-11T13:04:28+00:00","breadcrumb":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25566-excel-tableaux-croises-dynamiques-formation-en-ligne\/#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 (formation en ligne)"}]},{"@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\/135421","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=135421"}],"version-history":[{"count":0,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements\/135421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/media\/135417"}],"wp:attachment":[{"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/media?parent=135421"}],"wp:term":[{"taxonomy":"thematiques","embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/thematiques?post=135421"},{"taxonomy":"regions","embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/regions?post=135421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}