{"id":217759,"date":"2023-12-15T06:30:00","date_gmt":"2023-12-15T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=217759"},"modified":"2024-07-15T10:49:16","modified_gmt":"2024-07-15T10:49:16","slug":"calculer-une-moyenne-avec-excel-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir","title":{"rendered":"Calculer une moyenne avec Excel : Les 4 astuces indispensables"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"217759\" class=\"elementor elementor-217759\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-042f6a8 e-flex e-con-boxed e-con\" data-id=\"042f6a8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6d2ef56 elementor-widget elementor-widget-heading\" data-id=\"6d2ef56\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Malgr\u00e9 l\u2019apparition de multiples logiciels de traitement des donn\u00e9es, Excel reste encore et toujours l\u2019une des solutions les plus utilis\u00e9es au sein des entreprises.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef9b73e elementor-widget elementor-widget-text-editor\" data-id=\"ef9b73e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">\u00c0 travers ses fonctions et ses formules, cet outil Microsoft simplifie la pr\u00e9paration, l\u2019analyse et la visualisation des donn\u00e9es. Et parmi les fonctions phares, il y a \u00e9videmment le<\/span><b> calcul de la moyenne sur Excel. <\/b><span style=\"font-weight: 400;\">DataScientest vous explique justement la d\u00e9marche.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1f865a5 e-flex e-con-boxed e-con\" data-id=\"1f865a5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a09f0f0 elementor-widget elementor-widget-heading\" data-id=\"a09f0f0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment calculer une moyenne sur Excel ? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae4e831 elementor-widget elementor-widget-text-editor\" data-id=\"ae4e831\" 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<span style=\"font-weight: 400;\">La moyenne correspond \u00e0 la <\/span><b>somme de toutes les valeurs num\u00e9riques d\u2019une liste divis\u00e9e par le nombre de termes<\/b><span style=\"font-weight: 400;\">. Pour la calculer avec une <a href=\"https:\/\/datascientest.com\/formation-excel\">feuille de calcul Excel Microsoft 365<\/a>, il n\u2019est pas n\u00e9cessaire d\u2019ajouter toutes les valeurs manuellement. \u00c0 la place, il est possible d\u2019utiliser une fonction sp\u00e9cifique. Voici la d\u00e9marche \u00e0 suivre :\u00a0<\/span>\n<ul>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez une cellule vide dans laquelle vous souhaitez voir appara\u00eetre la moyenne ;\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez =MOYENNE( ;\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la plage de cellule pour laquelle vous voulez calculer la moyenne ;\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Fermez la parenth\u00e8se ;\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez Entr\u00e9e.<\/span><\/li>\n<\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4625a3 elementor-widget elementor-widget-text-editor\" data-id=\"c4625a3\" 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<p><span style=\"font-weight: 400;\">Par exemple, la formule de calcul de moyenne sur Excel peut ressembler \u00e0 ceci : <\/span><b>=MOYENNE(A2;A23).<\/b><span style=\"font-weight: 400;\"> La moyenne appara\u00eet alors dans la cellule o\u00f9 vous avez not\u00e9 la formule.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong><\/span> : plut\u00f4t que de taper les formules manuellement, il est aussi possible d\u2019<\/span><b>utiliser le concepteur de formule<\/b><span style=\"font-weight: 400;\"> afin d\u2019\u00e9viter les erreurs de frappe. Voici la manipulation : allez dans la barre Formules &gt; Ins\u00e9rer &gt; choisissez votre fonction. Le concepteur de formule appara\u00eet afin que vous entriez vos donn\u00e9es. Mais attention, selon les versions d\u2019Excel (Excel 2016, Excel 2019, Excel 2021, Excel pour Mac, \u2026), il peut y avoir de l\u00e9g\u00e8res variations quant \u00e0 la d\u00e9marche. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-503d280 e-flex e-con-boxed e-con\" data-id=\"503d280\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ed96451 elementor-widget elementor-widget-shortcode\" data-id=\"ed96451\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"245947\" class=\"elementor elementor-245947\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66b7eb0 e-flex e-con-boxed e-con\" data-id=\"66b7eb0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dbce002 elementor-widget elementor-widget-html\" data-id=\"dbce002\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<!DOCTYPE html>\n<html lang=\"fr\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <style>\n        .container {\n            background-color: #FFEDCC;\n            border-radius: 8px;\n            padding: 20px;\n            width: 80%;\n            max-width: 1000px;\n            margin: auto;\n            text-align: left;\n            box-sizing: border-box;\n        }\n        .icon {\n            width: 60px;\n            height: 70px;\n            vertical-align: middle;\n            margin-right: 10px;\n            margin-top: -10px; \/* Adjust this value to move the icon up or down *\/\n        }\n        .content {\n            font-size: 16px;\n            color: #000000;\n            margin: 10px 0;\n        }\n        .highlight {\n            font-weight: bold;\n        }\n        .link {\n            color: #4628DD;\n            text-decoration: none;\n        }\n        .button {\n            display: inline-block;\n            background-color: #4628DD;\n            color: #FFFFFF;\n            padding: 10px 20px;\n            border-radius: 5px;\n            text-align: center;\n            text-decoration: none;\n            font-size: 16px;\n            margin-top: 20px;\n        }\n        .elementor-heading-title {\n            font-family: \"Urbanist\", Sans-serif;\n            font-size: 28px;\n            font-weight: bold;\n            margin: 0;\n            display: inline-block;\n            vertical-align: middle;\n        }\n        @media (max-width: 600px) {\n            .container {\n                width: 90%;\n                padding: 10px;\n            }\n            .content {\n                font-size: 14px;\n            }\n            .button {\n                font-size: 14px;\n                padding: 8px 16px;\n            }\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class=\"container\">\n        <div>\n            <img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/07\/ampoule-icon-dst-e1720618321133.png\" alt=\"icon\" class=\"icon\">\n            <p class=\"elementor-heading-title elementor-size-default\">Le saviez-vous ?<\/p>\n        <\/div>\n        <div class=\"content\">\n            Depuis sa cr\u00e9ation en 2017, DataScientest compte d\u00e9j\u00e0 plus de <span class=\"highlight\">15 000 alumni<\/span> !\n            Avec une note moyenne de <span class=\"highlight\">4.8\/5<\/span>, <a href=\"https:\/\/datascientest.com\/formations-data?utm_source=datascientest.com&utm_medium=internal&utm_campaign=banner_lsv&utm_content=link\" class=\"link\" target=\"_blank\" id=\"link-lsv\"><b>nos formations<\/b><\/a>\n            sont parmi les meilleures en Europe. Plus de <span class=\"highlight\">500 entreprises partenaires<\/span>,\n            dont plusieurs du CAC 40, font confiance \u00e0 DataScientest pour former leurs collaborateurs.\n        <\/div>\n        <div style=\"margin-top: 20px;\">\n            <a id=\"button_lsv\" class=\"elementor-button elementor-button-link\" href=\"https:\/\/datascientest.com\/formations-data?utm_source=datascientest.com&utm_medium=internal&utm_campaign=banner_lsv&utm_content=button\" target=\"_blank\">\n                <span class=\"elementor-button-content-wrapper\">\n                    <span class=\"elementor-button-text\">D\u00e9couvrir nos formations<\/span>\n                <\/span>\n            <\/a>\n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8024b27 e-flex e-con-boxed e-con\" data-id=\"8024b27\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7a1acd5 elementor-widget elementor-widget-heading\" data-id=\"7a1acd5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment calculer la moyenne de cellules non adjacentes ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7319e90 elementor-widget elementor-widget-text-editor\" data-id=\"7319e90\" 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<p><span style=\"font-weight: 400;\">Si la m\u00e9thode pr\u00e9c\u00e9dente est tr\u00e8s efficace pour calculer la moyenne sur Excel, elle implique n\u00e9cessairement que les cellules soient adjacentes sur une m\u00eame plage de donn\u00e9es. Mais comment faire si vous souhaitez <\/span><b>inclure uniquement certaines cellules non adjacentes<\/b><span style=\"font-weight: 400;\"> ? Il vous suffit de suivre ces \u00e9tapes :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la cellule dans laquelle vous souhaitez voir appara\u00eetre la moyenne ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez =MOYENNE( ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez les cellules que vous souhaitez int\u00e9grer dans la moyenne et s\u00e9parez-les par des points-virgules ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Fermez la parenth\u00e8se ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez Entr\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19b2acf elementor-widget elementor-widget-text-editor\" data-id=\"19b2acf\" 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<p><span style=\"font-weight: 400;\">Par exemple, la formule peut ressembler \u00e0 ceci : <\/span><\/p><p style=\"padding-left: 40px;\"><b>=MOYENNE(A2;A7;A15;A18;A23)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2acc92b elementor-widget elementor-widget-image\" data-id=\"2acc92b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"713\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel1.jpg\" class=\"attachment-full size-full wp-image-217912\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel1.jpg 713w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel1-300x210.jpg 300w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6bf17a8 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"6bf17a8\" 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<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Excel ? Apprenez plut\u00f4t Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a442715 e-flex e-con-boxed e-con\" data-id=\"a442715\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-802826a elementor-widget elementor-widget-heading\" data-id=\"802826a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment calculer une moyenne pond\u00e9r\u00e9e sur votre fichier Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5f3451 elementor-widget elementor-widget-text-editor\" data-id=\"c5f3451\" 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<p><span style=\"font-weight: 400;\">La moyenne pond\u00e9r\u00e9e correspond \u00e0 la <\/span><b>moyenne de plusieurs valeurs num\u00e9riques, lesquelles sont affect\u00e9es d&rsquo;un coefficient<\/b><span style=\"font-weight: 400;\">. Par exemple : si vous souhaitez conna\u00eetre la moyenne pond\u00e9r\u00e9e des commandes pass\u00e9es pour diff\u00e9rents produits, il faudra <\/span><span style=\"font-weight: 400;\">diviser le co\u00fbt total des commandes par le nombre total d\u2019unit\u00e9s command\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour vous expliquer cette d\u00e9marche, admettons que le prix par unit\u00e9 corresponde \u00e0 la colonne B, et le nombre d&rsquo;unit\u00e9s vendues corresponde \u00e0 la <a href=\"https:\/\/datascientest.com\/comment-figer-une-ligne-sur-excel\">colonne<\/a> C.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Dans un tel cas, il faudra<\/span><b> utiliser la fonction SOMMEPROD<\/b><span style=\"font-weight: 400;\">. Voici la d\u00e9marche :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la cellule dans laquelle vous souhaitez voir appara\u00eetre la moyenne ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez =SOMMEPROD( ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la plage correspondant aux prix par unit\u00e9, puis ajoutez un point-virgule ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la plage correspondant au nombre d\u2019unit\u00e9s et fermez la parenth\u00e8se ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ajoutez le symbole divis\u00e9 (\/)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez =SOMME( ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la plage correspondant au nombre d\u2019unit\u00e9s et fermez la parenth\u00e8se ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez Entr\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-302da8d elementor-widget elementor-widget-text-editor\" data-id=\"302da8d\" 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<p><span style=\"font-weight: 400;\">Voici un exemple de r\u00e9sultat :<\/span><\/p><p style=\"padding-left: 40px;\"><b>=SOMMEPROD(B2:B17;C2:C17)\/SOMME(C2:C17)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7408c74 e-flex e-con-boxed e-con\" data-id=\"7408c74\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1af9585 elementor-widget elementor-widget-heading\" data-id=\"1af9585\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment calculer une moyenne en ignorant des valeurs sp\u00e9cifiques ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8016d99 elementor-widget elementor-widget-text-editor\" data-id=\"8016d99\" 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<p><span style=\"font-weight: 400;\">Si vous souhaitez exclure certaines valeurs sp\u00e9cifiques (comme les valeurs \u00e9gales \u00e0 0), vous devrez<\/span><b> utiliser la fonction MOYENNE.SI. <\/b><span style=\"font-weight: 400;\">Voici la d\u00e9marche \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la cellule dans laquelle vous souhaitez voir appara\u00eetre la moyenne ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Taper =MOYENNE.SI( ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez\u00a0 la plage de cellule pour laquelle vous souhaitez calculer la moyenne, puis ajoutez un point-virgule ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez \u00ab &lt;&gt;0 \u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Fermez la parenth\u00e8se ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez Entr\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be63a70 elementor-widget elementor-widget-text-editor\" data-id=\"be63a70\" 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<p><span style=\"font-weight: 400;\">Voici un exemple de formule pour calculer une moyenne sur Excel tout en ignorant certaines valeurs :<\/span><\/p><p style=\"padding-left: 40px;\"><b>=MOYENNE.SI(B2:B17; \u00ab &lt;&gt;0 \u00bb)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1075b86 e-flex e-con-boxed e-con\" data-id=\"1075b86\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5865041 elementor-widget elementor-widget-heading\" data-id=\"5865041\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Approfondissez Excel avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e20f0ac elementor-widget elementor-widget-text-editor\" data-id=\"e20f0ac\" 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<p><span style=\"font-weight: 400;\">Si la moyenne figure parmi les calculs les plus importants \u00e0 conna\u00eetre, c\u2019est loin d\u2019\u00eatre le seul. En effet, pour r\u00e9aliser des analyses pertinentes ou pour cr\u00e9er des mod\u00e8les de Machine Learning, les <a href=\"https:\/\/datascientest.com\/data-scientist-vs-data-analyst-tout-savoir\">Data Analysts et Data Scientists<\/a> doivent ma\u00eetriser une multitude de concepts math\u00e9matiques et statistiques, comme les variances, l\u2019<a href=\"https:\/\/datascientest.com\/ecart-type-excel\">\u00e9cart type<\/a>, le mode, la m\u00e9diane\u2026 Toutes ces m\u00e9thodes sont revues au sein de <a href=\"https:\/\/datascientest.com\/formations-data\">nos formations chez DataScientest<\/a>. Mais il ne s\u2019agit pas seulement de revoir des modes de calcul th\u00e9oriques. \u00c0 la place, nous leur donnons une application pratique afin de vous aider \u00e0 am\u00e9liorer vos comp\u00e9tences en pr\u00e9paration, analyse et mod\u00e9lisation des donn\u00e9es. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-769dedf elementor-widget elementor-widget-image\" data-id=\"769dedf\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"703\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel2.jpg\" class=\"attachment-full size-full wp-image-217917\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel2.jpg 703w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel2-300x213.jpg 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f89ca5 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"3f89ca5\" 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<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Formez-vous \u00e0 Power BI !<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-701ff39 e-flex e-con-boxed e-con\" data-id=\"701ff39\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e06514a elementor-widget elementor-widget-html\" data-id=\"e06514a\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment calculer une moyenne sur Excel ? \",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La moyenne correspond \u00e0 la somme de toutes les valeurs num\u00e9riques d\u2019une liste divis\u00e9e par le nombre de termes. Pour la calculer avec une feuille de calcul Excel Microsoft 365, il n\u2019est pas n\u00e9cessaire d\u2019ajouter toutes les valeurs manuellement. \u00c0 la place, il est possible d\u2019utiliser une fonction sp\u00e9cifique.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment calculer la moyenne de cellules non adjacentes ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Si la m\u00e9thode pr\u00e9c\u00e9dente est tr\u00e8s efficace pour calculer la moyenne sur Excel, elle implique n\u00e9cessairement que les cellules soient adjacentes sur une m\u00eame plage de donn\u00e9es. Mais comment faire si vous souhaitez inclure uniquement certaines cellules non adjacentes ?\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment calculer une moyenne pond\u00e9r\u00e9e sur votre fichier Excel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La moyenne pond\u00e9r\u00e9e correspond \u00e0 la moyenne de plusieurs valeurs num\u00e9riques, lesquelles sont affect\u00e9es d'un coefficient. Par exemple : si vous souhaitez conna\u00eetre la moyenne pond\u00e9r\u00e9e des commandes pass\u00e9es pour diff\u00e9rents produits, il faudra diviser le co\u00fbt total des commandes par le nombre total d\u2019unit\u00e9s command\u00e9es.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Malgr\u00e9 l\u2019apparition de multiples logiciels de traitement des donn\u00e9es, Excel reste encore et toujours l\u2019une des solutions les plus utilis\u00e9es au sein des entreprises. \u00c0 travers ses fonctions et ses formules, cet outil Microsoft simplifie la pr\u00e9paration, l\u2019analyse et la visualisation des donn\u00e9es. Et parmi les fonctions phares, il y a \u00e9videmment le calcul de [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":217897,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculer une moyenne avec Excel : Les 4 astuces indispensables<\/title>\n<meta name=\"description\" content=\"Le calcul d\u2019une moyenne sur Excel figure parmi les comp\u00e9tences incontournables pour tout expert data. D\u00e9couvrez comment faire.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculer une moyenne avec Excel : Les 4 astuces indispensables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-15T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-15T10:49:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir\",\"name\":\"Calculer une moyenne avec Excel : Les 4 astuces indispensables\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-12-15T06:30:00+00:00\",\"dateModified\":\"2024-07-15T10:49:16+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Le calcul d\u2019une moyenne sur Excel figure parmi les comp\u00e9tences incontournables pour tout expert data. D\u00e9couvrez comment faire.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Calculer une moyenne avec Excel : Les 4 astuces indispensables","description":"Le calcul d\u2019une moyenne sur Excel figure parmi les comp\u00e9tences incontournables pour tout expert data. D\u00e9couvrez comment faire.","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:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Calculer une moyenne avec Excel : Les 4 astuces indispensables","og_url":"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-12-15T06:30:00+00:00","article_modified_time":"2024-07-15T10:49:16+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir","url":"https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir","name":"Calculer une moyenne avec Excel : Les 4 astuces indispensables","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-12-15T06:30:00+00:00","dateModified":"2024-07-15T10:49:16+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Le calcul d\u2019une moyenne sur Excel figure parmi les comp\u00e9tences incontournables pour tout expert data. D\u00e9couvrez comment faire.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/calculer-une-moyenne-avec-excel-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/217759"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=217759"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/217759\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/217897"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=217759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=217759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=217759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}