{"id":859,"date":"2023-10-17T02:42:28","date_gmt":"2023-10-17T02:42:28","guid":{"rendered":"https:\/\/lasstatistique.com\/?p=859"},"modified":"2024-08-14T08:05:47","modified_gmt":"2024-08-14T08:05:47","slug":"cour-4-excel","status":"publish","type":"post","link":"https:\/\/lasstatistique.com\/?p=859","title":{"rendered":"Cours 4 : Excel"},"content":{"rendered":"<p><span style=\"color: #008000;\"><b>\u00a0 \u00a0 \u00a0<\/b><b>CHAPITRE V :<\/b> <b>UTILISATION DES FORMULES AVANCEES<\/b><\/span><\/p>\n<p><b>\u00a0 \u00a0 <span style=\"color: #008000;\">\u00a0V.1- L\u2019onglet Formules<\/span><\/b><\/p>\n<p>L\u2019onglet<strong> Formules<\/strong> contient les groupes de commandes qui vous permettent de cr\u00e9er et d\u2019appliquer des formules avanc\u00e9es dans <span style=\"color: #008000;\">Excel<\/span>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-861\" src=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-8-1-300x149.png\" alt=\"\" width=\"731\" height=\"363\" srcset=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-8-1-300x149.png 300w, https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-8-1-768x382.png 768w, https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-8-1.png 872w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/p>\n<hr \/>\n<p>Le tableau\u00a0suivant r\u00e9sume quelques fonctions sous l\u2019onglet <strong>Formules<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-862\" src=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-9-1-300x143.png\" alt=\"\" width=\"730\" height=\"348\" srcset=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-9-1-300x143.png 300w, https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-9-1-768x366.png 768w, https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-9-1.png 939w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<hr \/>\n<p>Le tableau\u00a0suivant r\u00e9sume quelques fonctions sous l\u2019onglet Formules.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-863\" src=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-10-1-300x150.png\" alt=\"\" width=\"734\" height=\"367\" srcset=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-10-1-300x150.png 300w, https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-10-1-768x385.png 768w, https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/Capture-10-1.png 964w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 \u00a0CHAPITRE V : UTILISATION DES FORMULES AVANCEES \u00a0 \u00a0 \u00a0V.1- L\u2019onglet Formules L\u2019onglet Formules contient les groupes de<\/p>\n","protected":false},"author":1,"featured_media":824,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[40,41],"tags":[],"class_list":["post-859","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cours","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cours 4 : Excel - LASStatistique<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/lasstatistique.com\/?p=859\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cours 4 : Excel - LASStatistique\" \/>\n<meta property=\"og:description\" content=\"\u00a0 \u00a0 \u00a0CHAPITRE V : UTILISATION DES FORMULES AVANCEES \u00a0 \u00a0 \u00a0V.1- L\u2019onglet Formules L\u2019onglet Formules contient les groupes de\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lasstatistique.com\/?p=859\" \/>\n<meta property=\"og:site_name\" content=\"LASStatistique\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ASstatistique\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-17T02:42:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-14T08:05:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@AsStatistique\" \/>\n<meta name=\"twitter:site\" content=\"@AsStatistique\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/person\\\/c8fa17c25e80a74f42e1d8b8dcd9c470\"},\"headline\":\"Cours 4 : Excel\",\"datePublished\":\"2023-10-17T02:42:28+00:00\",\"dateModified\":\"2024-08-14T08:05:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859\"},\"wordCount\":58,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"articleSection\":[\"Cours\",\"Excel\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/lasstatistique.com\\\/?p=859#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859\",\"name\":\"Cours 4 : Excel - LASStatistique\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"datePublished\":\"2023-10-17T02:42:28+00:00\",\"dateModified\":\"2024-08-14T08:05:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/lasstatistique.com\\\/?p=859\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#primaryimage\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"contentUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"width\":800,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=859#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/lasstatistique.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\\\/\\\/lasstatistique.com\\\/?cat=40\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cours 4 : Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#website\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/\",\"name\":\"LASStatistique\",\"description\":\"L&#039;AS Statistique\",\"publisher\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/lasstatistique.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#organization\",\"name\":\"L'AS STATISTIQUE\",\"alternateName\":\"lasstatistique\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/cropped-logoAS-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/cropped-logoAS-removebg-preview.png\",\"width\":500,\"height\":245,\"caption\":\"L'AS STATISTIQUE\"},\"image\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ASstatistique\\\/\",\"https:\\\/\\\/x.com\\\/AsStatistique\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/l-as\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/person\\\/c8fa17c25e80a74f42e1d8b8dcd9c470\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/lasstatistique.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cours 4 : Excel - LASStatistique","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:\/\/lasstatistique.com\/?p=859","og_locale":"fr_FR","og_type":"article","og_title":"Cours 4 : Excel - LASStatistique","og_description":"\u00a0 \u00a0 \u00a0CHAPITRE V : UTILISATION DES FORMULES AVANCEES \u00a0 \u00a0 \u00a0V.1- L\u2019onglet Formules L\u2019onglet Formules contient les groupes de","og_url":"https:\/\/lasstatistique.com\/?p=859","og_site_name":"LASStatistique","article_publisher":"https:\/\/www.facebook.com\/ASstatistique\/","article_published_time":"2023-10-17T02:42:28+00:00","article_modified_time":"2024-08-14T08:05:47+00:00","og_image":[{"width":800,"height":600,"url":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@AsStatistique","twitter_site":"@AsStatistique","twitter_misc":{"\u00c9crit par":"admin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/lasstatistique.com\/?p=859#article","isPartOf":{"@id":"https:\/\/lasstatistique.com\/?p=859"},"author":{"name":"admin","@id":"https:\/\/lasstatistique.com\/#\/schema\/person\/c8fa17c25e80a74f42e1d8b8dcd9c470"},"headline":"Cours 4 : Excel","datePublished":"2023-10-17T02:42:28+00:00","dateModified":"2024-08-14T08:05:47+00:00","mainEntityOfPage":{"@id":"https:\/\/lasstatistique.com\/?p=859"},"wordCount":58,"commentCount":2,"publisher":{"@id":"https:\/\/lasstatistique.com\/#organization"},"image":{"@id":"https:\/\/lasstatistique.com\/?p=859#primaryimage"},"thumbnailUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","articleSection":["Cours","Excel"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/lasstatistique.com\/?p=859#respond"]}]},{"@type":"WebPage","@id":"https:\/\/lasstatistique.com\/?p=859","url":"https:\/\/lasstatistique.com\/?p=859","name":"Cours 4 : Excel - LASStatistique","isPartOf":{"@id":"https:\/\/lasstatistique.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/lasstatistique.com\/?p=859#primaryimage"},"image":{"@id":"https:\/\/lasstatistique.com\/?p=859#primaryimage"},"thumbnailUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","datePublished":"2023-10-17T02:42:28+00:00","dateModified":"2024-08-14T08:05:47+00:00","breadcrumb":{"@id":"https:\/\/lasstatistique.com\/?p=859#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lasstatistique.com\/?p=859"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/lasstatistique.com\/?p=859#primaryimage","url":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","contentUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","width":800,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/lasstatistique.com\/?p=859#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/lasstatistique.com\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/lasstatistique.com\/?cat=40"},{"@type":"ListItem","position":3,"name":"Cours 4 : Excel"}]},{"@type":"WebSite","@id":"https:\/\/lasstatistique.com\/#website","url":"https:\/\/lasstatistique.com\/","name":"LASStatistique","description":"L&#039;AS Statistique","publisher":{"@id":"https:\/\/lasstatistique.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lasstatistique.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/lasstatistique.com\/#organization","name":"L'AS STATISTIQUE","alternateName":"lasstatistique","url":"https:\/\/lasstatistique.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/lasstatistique.com\/#\/schema\/logo\/image\/","url":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/06\/cropped-logoAS-removebg-preview.png","contentUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/06\/cropped-logoAS-removebg-preview.png","width":500,"height":245,"caption":"L'AS STATISTIQUE"},"image":{"@id":"https:\/\/lasstatistique.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ASstatistique\/","https:\/\/x.com\/AsStatistique","https:\/\/www.linkedin.com\/company\/l-as\/"]},{"@type":"Person","@id":"https:\/\/lasstatistique.com\/#\/schema\/person\/c8fa17c25e80a74f42e1d8b8dcd9c470","name":"admin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/lasstatistique.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts\/859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=859"}],"version-history":[{"count":3,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts\/859\/revisions"}],"predecessor-version":[{"id":873,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts\/859\/revisions\/873"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/media\/824"}],"wp:attachment":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}