{"id":2203,"date":"2025-01-15T13:40:22","date_gmt":"2025-01-15T18:40:22","guid":{"rendered":"https:\/\/qualificaction.swlauriersb.qc.ca\/?post_type=event&#038;p=2203"},"modified":"2026-10-20T13:47:30","modified_gmt":"2026-10-20T17:47:30","slug":"excel-niveau-intermediaire","status":"publish","type":"event","link":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/","title":{"rendered":"Excel &#8211; niveau interm\u00e9diaire"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Objectif<\/h3>\n\n\n\n<p>Apprendre \u00e0 utiliser les fonctions plus avanc\u00e9es, telles les fonctions de base de donn\u00e9es et les outils de validation.<\/p>\n\n\n\n<p><strong>Utiliser les outils compl\u00e9mentaires<\/strong><\/p>\n\n\n\n<ul>\n<li>Les champs nomm\u00e9s<\/li>\n\n\n\n<li>La validation de donn\u00e9es<\/li>\n\n\n\n<li>Les messages d\u2019erreurs pour la validation<\/li>\n\n\n\n<li>Les messages d\u2019aide pour la validation<\/li>\n\n\n\n<li>Le solveur de donn\u00e9es<\/li>\n\n\n\n<li>L\u2019audit de formules<\/li>\n\n\n\n<li>Le gestionnaire de sc\u00e9nario<\/li>\n\n\n\n<li>La valeur cible<\/li>\n\n\n\n<li>Le format tableau<\/li>\n\n\n\n<li>Les SmartArt<\/li>\n<\/ul>\n\n\n\n<p><strong>Consolider les donn\u00e9es<\/strong><\/p>\n\n\n\n<ul>\n<li>La consolidation par position<\/li>\n\n\n\n<li>La consolidation par \u00e9tiquette<\/li>\n\n\n\n<li>La liaison des donn\u00e9es de consolidation aux donn\u00e9es sources<\/li>\n<\/ul>\n\n\n\n<p><strong>Utiliser les fonctions conditionnelles et de recherche<\/strong><\/p>\n\n\n\n<ul>\n<li>La fonction SI<\/li>\n\n\n\n<li>La fonction ET<\/li>\n\n\n\n<li>La fonction OU<\/li>\n\n\n\n<li>La fonction RECHERCHEV<\/li>\n\n\n\n<li>Les fonctions NB.SI, NB.SI.ENS<\/li>\n\n\n\n<li>Les fonctions SOMME.SI, SOMME.SI.ENS<\/li>\n\n\n\n<li>Les fonctions MOYENNE.SI, MOYENNE.SI.ENS<\/li>\n<\/ul>\n\n\n\n<p><strong>Utiliser les outils de base de donn\u00e9es<\/strong><\/p>\n\n\n\n<ul>\n<li>Les filtres<\/li>\n\n\n\n<li>Les tris<\/li>\n\n\n\n<li>Les sous-totaux<\/li>\n\n\n\n<li>Les tableaux crois\u00e9s dynamiques<\/li>\n\n\n\n<li>Les graphiques crois\u00e9s dynamiques<\/li>\n<\/ul>\n\n\n\n<p><strong>Utiliser les fonctions de base de donn\u00e9es<\/strong><\/p>\n\n\n\n<ul>\n<li>La fonction BDSOMME<\/li>\n\n\n\n<li>La fonction BDNB<\/li>\n\n\n\n<li>La fonction BDNBVAL<\/li>\n\n\n\n<li>La fonction BDMOYENNE<\/li>\n\n\n\n<li>La fonction BDMAX<\/li>\n\n\n\n<li>La fonction BDMIN<\/li>\n<\/ul>\n\n\n\n<p><strong>Horaire <\/strong>: 20 &amp; 27 janvier, 3 &amp; 10 f\u00e9vrier 2027 &#8211; de 9 h \u00e0 12 h<\/p>\n\n\n\n<p><strong>Co\u00fbt : 12 heures de formation \u00e0 5$* = 60$. Un manuel Excel Microsoft 265 est fourni.<\/strong><\/p>\n\n\n\n<p>*<em>Certaines conditions s\u2019appliquent. Occuper un emploi ou \u00eatre un chercheur d\u2019emploi sur le&nbsp;<u>territoire de Laval ou des Laurentides<\/u>. Vous pouvez inscrire un maximum de&nbsp;<u>2 employ\u00e9s<\/u>&nbsp;par entreprise.<\/em><\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-left is-layout-flex wp-container-core-buttons-is-layout-1 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-font-size has-small-font-size\"><a class=\"wp-block-button__link has-black-background-color has-background wp-element-button\" href=\"https:\/\/forms.zohopublic.ca\/formationqualificaction1\/form\/TEMPLATEInscriptionuneformation\/formperma\/ELOB_tWZ2JrawU_346vJn3ooJbs507Rash_i7tjn9XQ?nom_formation=Excel%20interm%C3%A9diaire&amp;id_formation=67754000000555094\">S&#8217;INSCRIRE<i class=\"icon-arrow-left\"><\/i><\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Mention importante<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-container-core-column-is-layout-1 wp-block-column-is-layout-flow\" style=\"border-style:none;border-width:0px;padding-top:0;padding-right:0;padding-bottom:0;padding-left:0\">\n<figure class=\"wp-block-image alignleft size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"434\" src=\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2026\/01\/Qc-AvecParticipationFinanciere_couleur-1024x434.png\" alt=\"\" class=\"wp-image-2797\" style=\"width:168px;height:auto\" srcset=\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2026\/01\/Qc-AvecParticipationFinanciere_couleur-1024x434.png 1024w, https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2026\/01\/Qc-AvecParticipationFinanciere_couleur-300x127.png 300w, https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2026\/01\/Qc-AvecParticipationFinanciere_couleur-768x325.png 768w, https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2026\/01\/Qc-AvecParticipationFinanciere_couleur-1536x650.png 1536w, https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2026\/01\/Qc-AvecParticipationFinanciere_couleur.png 1960w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-container-core-column-is-layout-2 wp-block-column-is-layout-flow\"><\/div>\n<\/div>\n","protected":false},"featured_media":3563,"template":"","event-category":[100,101],"event-location":[69,71],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel - niveau interm\u00e9diaire<\/title>\n<meta name=\"description\" content=\"Apprendre \u00e0 utiliser les fonctions avanc\u00e9es d\u2019Excel et exploiter au maximum les outils de validation d\u2019Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel - niveau interm\u00e9diaire\" \/>\n<meta property=\"og:description\" content=\"Apprendre \u00e0 utiliser les fonctions avanc\u00e9es d\u2019Excel et exploiter au maximum les outils de validation d\u2019Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/\" \/>\n<meta property=\"og:site_name\" content=\"Service aux entreprises Qualificaction\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/FormationQUALIFICACTION\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-20T17:47:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"735\" \/>\n\t<meta property=\"og:image:height\" content=\"434\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/\",\"url\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/\",\"name\":\"Excel - niveau interm\u00e9diaire\",\"isPartOf\":{\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg\",\"datePublished\":\"2025-01-15T18:40:22+00:00\",\"dateModified\":\"2026-10-20T17:47:30+00:00\",\"description\":\"Apprendre \u00e0 utiliser les fonctions avanc\u00e9es d\u2019Excel et exploiter au maximum les outils de validation d\u2019Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#primaryimage\",\"url\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg\",\"contentUrl\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg\",\"width\":735,\"height\":434},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel &#8211; niveau interm\u00e9diaire\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#website\",\"url\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/\",\"name\":\"Service aux entreprises Qualificaction\",\"description\":\"Prenez votre \u00e9lan! Nos Formations. Votre r\u00e9ussite!\",\"publisher\":{\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#organization\",\"name\":\"Service aux entreprises Qualificaction\",\"url\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2024\/06\/qualificaction_logo_resized.png\",\"contentUrl\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2024\/06\/qualificaction_logo_resized.png\",\"width\":470,\"height\":304,\"caption\":\"Service aux entreprises Qualificaction\"},\"image\":{\"@id\":\"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/FormationQUALIFICACTION\",\"https:\/\/www.linkedin.com\/company\/qualificaction\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel - niveau interm\u00e9diaire","description":"Apprendre \u00e0 utiliser les fonctions avanc\u00e9es d\u2019Excel et exploiter au maximum les outils de validation d\u2019Excel.","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:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/","og_locale":"en_US","og_type":"article","og_title":"Excel - niveau interm\u00e9diaire","og_description":"Apprendre \u00e0 utiliser les fonctions avanc\u00e9es d\u2019Excel et exploiter au maximum les outils de validation d\u2019Excel.","og_url":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/","og_site_name":"Service aux entreprises Qualificaction","article_publisher":"https:\/\/www.facebook.com\/FormationQUALIFICACTION","article_modified_time":"2026-10-20T17:47:30+00:00","og_image":[{"width":735,"height":434,"url":"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/","url":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/","name":"Excel - niveau interm\u00e9diaire","isPartOf":{"@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#primaryimage"},"image":{"@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#primaryimage"},"thumbnailUrl":"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg","datePublished":"2025-01-15T18:40:22+00:00","dateModified":"2026-10-20T17:47:30+00:00","description":"Apprendre \u00e0 utiliser les fonctions avanc\u00e9es d\u2019Excel et exploiter au maximum les outils de validation d\u2019Excel.","breadcrumb":{"@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#primaryimage","url":"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg","contentUrl":"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2025\/01\/exceldonnees2.jpg","width":735,"height":434},{"@type":"BreadcrumbList","@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/events\/excel-niveau-intermediaire\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/"},{"@type":"ListItem","position":2,"name":"Excel &#8211; niveau interm\u00e9diaire"}]},{"@type":"WebSite","@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#website","url":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/","name":"Service aux entreprises Qualificaction","description":"Prenez votre \u00e9lan! Nos Formations. Votre r\u00e9ussite!","publisher":{"@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#organization","name":"Service aux entreprises Qualificaction","url":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#\/schema\/logo\/image\/","url":"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2024\/06\/qualificaction_logo_resized.png","contentUrl":"https:\/\/qualificaction.swlauriersb.qc.ca\/wp-content\/uploads\/sites\/46\/2024\/06\/qualificaction_logo_resized.png","width":470,"height":304,"caption":"Service aux entreprises Qualificaction"},"image":{"@id":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/FormationQUALIFICACTION","https:\/\/www.linkedin.com\/company\/qualificaction\/"]}]}},"_links":{"self":[{"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/event\/2203"}],"collection":[{"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/event"}],"about":[{"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/types\/event"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/media\/3563"}],"wp:attachment":[{"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/media?parent=2203"}],"wp:term":[{"taxonomy":"event-category","embeddable":true,"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/event-category?post=2203"},{"taxonomy":"event-location","embeddable":true,"href":"https:\/\/qualificaction.swlauriersb.qc.ca\/en\/wp-json\/wp\/v2\/event-location?post=2203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}