{"id":2124,"date":"2021-04-28T17:58:43","date_gmt":"2021-04-28T15:58:43","guid":{"rendered":"http:\/\/thjjwyy.cluster030.hosting.ovh.net\/?post_type=lp_course&#038;p=2124"},"modified":"2025-12-05T16:47:32","modified_gmt":"2025-12-05T15:47:32","slug":"excel-les-fonctions","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/","title":{"rendered":"EXCEL LES FONCTIONS"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2124\" class=\"elementor elementor-2124\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7a57526c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a57526c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-48d765bb\" data-id=\"48d765bb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16eab838 elementor-widget elementor-widget-text-editor\" data-id=\"16eab838\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div id=\"detailles-objectif\"><span style=\"color: inherit; font-family: inherit; font-size: 1.75rem;\">Programme<\/span><\/div><h5>Nommer une cellule, une formule<\/h5><h5>Les fonctions logiques<\/h5><p>SI, SI imbriqu\u00e9s, ET, OU&#8230;<\/p><h5>Les fonctions Date et Heure<\/h5><p>AUJOURDHUI, ANNEE, MOIS, JOUR&#8230;<br \/>DATE, DATEVAL, MAINTENANT\u2026<\/p><h5>Les fonctions math\u00e9matiques<\/h5><p>SOMME, SOMME.SI, ENT, NB.SI, ARRONDI\u2026<\/p><h5>Les fonctions texte<\/h5><p>DROITE, GAUCHE, NBCAR, STXT&#8230;<\/p><h5>Les fonctions de recherche<\/h5><p>RECHERCHEV ou RECHERCHEH<\/p><h5>Les fonctions de gestion de texte<\/h5><p>GAUCHE, DROITE, CONCATENER<\/p><h5>Les fonctions statistiques<\/h5><p>MAX, MIN, RANG\u2026<\/p><h5>Les fonctions financi\u00e8res<\/h5><p>VPM, TAUX\u2026<\/p><h5>Moyens techniques mis \u00e0 disposition<\/h5><p>Supports d\u2019animation p\u00e9dagogique utilis\u00e9s en vid\u00e9oprojection.<br \/>1 PC\/stagiaire, connexion Wifi, imprimante multifonctions.<br \/>Installation dans notre centre de formation : salles de formation \u00e9quip\u00e9es de tables, chaises, mur clair pour la projection, paperboard et\/ou tableau blanc ou num\u00e9rique interactif.<br \/>En cas de formation intra-entreprise, des installations \u00e9quivalentes doivent \u00eatre mises \u00e0 disposition par l\u2019employeur des stagiaires.<span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif;\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1e1f64e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1e1f64e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-ce4d509\" data-id=\"ce4d509\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d7fa6bb elementor-align-center elementor-widget elementor-widget-button\" data-id=\"d7fa6bb\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/controlc.fr\/wp-content\/uploads\/2021\/04\/EXCEL-LES-FONCTIONS.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">La fiche formation<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-9e4bbc9\" data-id=\"9e4bbc9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d37f5b2 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"d37f5b2\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/ControlC_Tarifs_pack-office-PAO-DAO_2025.pdf\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Nos tarifs<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-939a078\" data-id=\"939a078\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f863a1f elementor-align-center elementor-widget elementor-widget-button\" data-id=\"f863a1f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/12\/ControlC_planning-interentreprises_bureautique-et-PAO_2026.pdf\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Le planning<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Programme Nommer une cellule, une formule Les fonctions logiques SI, SI imbriqu\u00e9s, ET, OU&#8230; Les fonctions Date et Heure AUJOURDHUI, ANNEE, MOIS, JOUR&#8230;DATE, DATEVAL, MAINTENANT\u2026 Les fonctions math\u00e9matiques SOMME, SOMME.SI, ENT, NB.SI, ARRONDI\u2026 Les fonctions texte DROITE, GAUCHE, NBCAR, STXT&#8230; Les fonctions de recherche RECHERCHEV ou RECHERCHEH Les fonctions de&hellip;<\/p>\n","protected":false},"author":6,"featured_media":6001,"comment_status":"closed","ping_status":"closed","template":"","course_category":[10,36],"course_tag":[],"class_list":["post-2124","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-bureautique","course_category-tableur-excel-et-calc","course"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EXCEL LES FONCTIONS -<\/title>\n<meta name=\"description\" content=\"programme de la formation Control C Melun d&#039;un jour pour aborder les fonctions avanc\u00e9es du logiciel Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXCEL LES FONCTIONS -\" \/>\n<meta property=\"og:description\" content=\"programme de la formation Control C Melun d&#039;un jour pour aborder les fonctions avanc\u00e9es du logiciel Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-05T15:47:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@controlcmelun\" \/>\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:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/\",\"name\":\"EXCEL LES FONCTIONS -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"datePublished\":\"2021-04-28T15:58:43+00:00\",\"dateModified\":\"2025-12-05T15:47:32+00:00\",\"description\":\"programme de la formation Control C Melun d'un jour pour aborder les fonctions avanc\u00e9es du logiciel Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#primaryimage\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"width\":200,\"height\":200,\"caption\":\"Microsoft Excel 2019 ic\u00f4ne par Icons8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/controlc.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\/\/controlc.fr\/index.php\/cours-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EXCEL LES FONCTIONS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/controlc.fr\/#website\",\"url\":\"https:\/\/controlc.fr\/\",\"name\":\"Controlc.fr\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/controlc.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/controlc.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/controlc.fr\/#organization\",\"name\":\"Control^C\",\"url\":\"https:\/\/controlc.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"width\":427,\"height\":100,\"caption\":\"Control^C\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/controlcmelun\",\"https:\/\/www.linkedin.com\/company\/8009384\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXCEL LES FONCTIONS -","description":"programme de la formation Control C Melun d'un jour pour aborder les fonctions avanc\u00e9es du logiciel Excel.","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:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/","og_locale":"fr_FR","og_type":"article","og_title":"EXCEL LES FONCTIONS -","og_description":"programme de la formation Control C Melun d'un jour pour aborder les fonctions avanc\u00e9es du logiciel Excel.","og_url":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/","article_modified_time":"2025-12-05T15:47:32+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@controlcmelun","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/","url":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/","name":"EXCEL LES FONCTIONS -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","datePublished":"2021-04-28T15:58:43+00:00","dateModified":"2025-12-05T15:47:32+00:00","description":"programme de la formation Control C Melun d'un jour pour aborder les fonctions avanc\u00e9es du logiciel Excel.","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#primaryimage","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","width":200,"height":200,"caption":"Microsoft Excel 2019 ic\u00f4ne par Icons8"},{"@type":"BreadcrumbList","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-fonctions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/controlc.fr\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/controlc.fr\/index.php\/cours-2\/"},{"@type":"ListItem","position":3,"name":"EXCEL LES FONCTIONS"}]},{"@type":"WebSite","@id":"https:\/\/controlc.fr\/#website","url":"https:\/\/controlc.fr\/","name":"Controlc.fr","description":"","publisher":{"@id":"https:\/\/controlc.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/controlc.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/controlc.fr\/#organization","name":"Control^C","url":"https:\/\/controlc.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","width":427,"height":100,"caption":"Control^C"},"image":{"@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/controlcmelun","https:\/\/www.linkedin.com\/company\/8009384"]}]}},"_links":{"self":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/2124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2124"}],"version-history":[{"count":47,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/2124\/revisions"}],"predecessor-version":[{"id":6491,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/2124\/revisions\/6491"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media\/6001"}],"wp:attachment":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2124"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=2124"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=2124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}