{"id":134715,"date":"2022-06-07T09:14:42","date_gmt":"2022-06-07T13:14:42","guid":{"rendered":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/"},"modified":"2022-08-14T19:25:31","modified_gmt":"2022-08-14T23:25:31","slug":"u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel","status":"publish","type":"evenements","link":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/","title":{"rendered":"Excel-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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<p><strong>Objectif :<br \/><\/strong>Cette formation Microsoft Excel s\u2019adresse \u00e0 vous si vous d\u00e9sirez savoir :<\/p>\n<ul>\n<li>\u00c0 quoi sert Microsoft Excel ?<\/li>\n<li>Comment formater mes donn\u00e9es ?<\/li>\n<li>Pourquoi mes formules ne fonctionnent-elles pas\u00a0?<\/li>\n<li>Comment adapter mes donn\u00e9es en fonction de mes besoins ?<\/li>\n<li>Comment avoir un tableau plusieurs fois sans le refaire ?<\/li>\n<li>Comment calculer des statistiques simples?<\/li>\n<li>Comment g\u00e9rer de grandes quantit\u00e9s de donn\u00e9es?<\/li>\n<li>Comment anticiper la mise en forme conditionnelle de mes donn\u00e9es?<\/li>\n<li>Comment adapter les formules et les graphiques \u00e0 mes besoins?<\/li>\n<\/ul>\n<p><i>Pour plus d\u2019information sur cette formation, <a title=\"\" href=\"https:\/\/lapuce.org\/contact\/\" target=\"_blank\" rel=\"noopener noreferrer\">contactez-nous<\/a> !<\/i><\/p>\n<p><strong>Client\u00e8le vis\u00e9e Microsoft Excel<br \/><\/strong>Personnes novices et utilisateurs cherchant \u00e0 am\u00e9liorer leurs acquis.<br \/><b\/><\/p>\n<p><b>\u00a0<\/b><\/p>\n<p><strong><em>Dates:\u00a0 \u00a0<\/em> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong><\/p>\n<p>8, 9 et 10 juin 2022<\/p>\n<p><b><em>Dur\u00e9e:<\/em><\/b><\/p>\n<p>9 heures<\/p>\n<p><strong><em>Horaire: <\/em><\/strong><\/p>\n<p>09h00-12h00<\/p>\n<p><strong>Co\u00fbt:<\/strong><\/p>\n<p>180$<\/p>\n<p><strong>Pr\u00e9requis<br \/><\/strong>Ma\u00eetriser les bases d&rsquo;Excel, voir : <a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-les-bases-formation-en-ligne-2\/\" target=\"_new\" rel=\"noopener\">Excel-les bases.<\/a> Utiliser l\u2019interface Windows, la souris et le clavier<\/p>\n<p><strong>R\u00e9sum\u00e9 du contenu Microsoft Excel<\/strong><\/p>\n<ul>\n<li>Imprimer et mettre en page\u00a0<\/li>\n<li>Supprimer et ins\u00e9rer des cellules\u00a0<\/li>\n<li>Changer la largeur d\u2019une colonne\u00a0<\/li>\n<li>Se d\u00e9placer et travailler sur de grands tableaux\u00a0<\/li>\n<li>R\u00e9f\u00e9rences absolues et relatives dans une formule\u00a0<\/li>\n<li>Copier ou d\u00e9placer une formule\u00a0<\/li>\n<li>Comprendre les principales erreurs de calcul : #NOM?, #DIV\/0!, #####&#8230;\u00a0<\/li>\n<li>Ma\u00eetriser les formules de base : MAX, Min, Moyenne, SOMME.SI, NB.SI\u2026\u00a0<\/li>\n<li>Mises en forme conditionnelles\u00a0<\/li>\n<li>Fusionner des cellules, centrer sur plusieurs colonnes\u00a0<\/li>\n<li>Ins\u00e9rer un smartArt ou une image.\u00a0<\/li>\n<li>Les graphiques\u00a0<\/li>\n<li>Trier et Filtrer les donn\u00e9es\u00a0\u00a0<\/li>\n<li>Lire un tableau crois\u00e9 dynamique\u00a0<\/li>\n<li>Analyser les donn\u00e9es dans un tableau crois\u00e9 dynamique\u00a0<\/li>\n<li>Rechercher, remplacer ou s\u00e9lectionner des donn\u00e9es\u00a0<\/li>\n<\/ul>\n<p>\u00a0Des travaux pratiques tout au long de la formation<\/p>\n<p>Droit \u00e0 passer l\u2019\u00e9valuation des comp\u00e9tences Excel Tosa pour mesurer votre avancement et vous inscrire au niveau suivant <em><a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-realiser-des-tableaux-croises-dynamiques-2\/\" target=\"_new\" rel=\"noopener\">\u00ab\u00a0Excel-Tableaux crois\u00e9s dynamiques\u00a0\u00bb<\/a> ou \u00ab\u00a0<a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-fonctions-avancees-formation-en-ligne\/\" target=\"_new\" rel=\"noopener\">Fonctions avanc\u00e9es<\/a>\u00ab\u00a0<\/em><\/p>\n<p><em>Il est recommand\u00e9 de vous inscrire \u00e0 la formation <a title=\"\" href=\"https:\/\/lapuce.org\/formations\/windows-10-les-bases-formation-en-presentiel-2\/\" target=\"_new\" rel=\"noopener\">\u00ab Windows 10 \u00bb<\/a> et la formation <a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-les-bases-formation-en-ligne-2\/\" target=\"_new\" rel=\"noopener\">Excel-les bases<\/a>\u00a0 avant de participer \u00e0 cette formation.<\/em><\/p>\n<p><em>Je m&rsquo;inscris \u00e0 la formation:\u00a0<\/em><\/p>\n<p><em><a title=\"\" href=\"https:\/\/lapuce.org\/formations\/excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouvete-presentiel\/\" target=\"_new\" rel=\"noopener\">Excel-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-NOUVEAUT\u00c9-Pr\u00e9sentiel. &#8211; La Puce ressource informatique<\/a><\/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. Objectif&#8230;<\/p>\n<p><a href=\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/\">read more<\/a><\/p>","protected":false},"author":433,"featured_media":135004,"comment_status":"open","ping_status":"closed","template":"","thematiques":[167],"regions":[98,80],"class_list":["post-134715","evenements","type-evenements","status-publish","has-post-thumbnail","hentry","thematiques-education-populaire","regions-le-plateau-mont-royal","regions-montreal"],"acf":{"evenement_date":"2022-06-08","evenement_date_fin":"2022-06-08","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-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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. Objectif...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/\" \/>\n<meta property=\"og:site_name\" content=\"Ma Communaut\u00e9\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-14T23:25:31+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/\",\"url\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/\",\"name\":\"Excel-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-pr\u00e9sentiel. - Ma Communaut\u00e9\",\"isPartOf\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/#website\"},\"datePublished\":\"2022-06-07T13:14:42+00:00\",\"dateModified\":\"2022-08-14T23:25:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-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-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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. Objectif...","og_url":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/","og_site_name":"Ma Communaut\u00e9","article_modified_time":"2022-08-14T23:25:31+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/","url":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/","name":"Excel-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-pr\u00e9sentiel. - Ma Communaut\u00e9","isPartOf":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/#website"},"datePublished":"2022-06-07T13:14:42+00:00","dateModified":"2022-08-14T23:25:31+00:00","breadcrumb":{"@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-presentiel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.totemweb.design\/macommunaute\/evenements\/u25736-excel-montez-de-niveau-et-devenez-operationnel-test-competences-tosa-nouveaute-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-Montez de niveau et devenez op\u00e9rationnel- Test comp\u00e9tences TOSA-nouveaut\u00e9-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\/134715","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=134715"}],"version-history":[{"count":1,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements\/134715\/revisions"}],"predecessor-version":[{"id":135007,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/evenements\/134715\/revisions\/135007"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/media\/135004"}],"wp:attachment":[{"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/media?parent=134715"}],"wp:term":[{"taxonomy":"thematiques","embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/thematiques?post=134715"},{"taxonomy":"regions","embeddable":true,"href":"https:\/\/dev.totemweb.design\/macommunaute\/wp-json\/wp\/v2\/regions?post=134715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}