T\u00e9l\u00e9charger le fichier Excel<\/a><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”20px||20px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” header_3_text_color=”#3BB6D5″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”]<\/p>\n
Comment suivre son chiffre d’affaires avec Excel gr\u00e2ce \u00e0 la loi de Pareto ?<\/h3>\n
[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
La\u00a0<\/span>loi de Pareto<\/strong>\u00a0<\/span>est une m\u00e9thode efficace et cr\u00e9ative pour d\u00e9terminer les \u00e9l\u00e9ments qui ont le plus d\u2019influence sur votre activit\u00e9 et vos campagnes.<\/p>\nD\u2019apr\u00e8s la loi de Pareto :\u00a0<\/span>20 % des efforts produisent 80 % des r\u00e9sultats<\/strong>.<\/p>\nCes chiffres ne sont pas grav\u00e9s dans le marbre, ils ont simplement pour but d\u2019illustrer un principe. Le principe de Pareto tire son nom de Vilfredo Pareto (1848 \u2013 1923), \u00e9conomiste et sociologue italien. M. Pareto demeure c\u00e9l\u00e8bre pour avoir observ\u00e9 durant son vivant que 20 % de la population italienne concentraient 80 % des richesses.<\/p>\n
Les\u00a0<\/span>tableaux crois\u00e9s dynamiques<\/strong>\u00a0<\/span>permettent d\u2019effectuer facilement ce type d\u2019analyse afin de les appliquer par exemple aux ventes de vos produits et services et de vous aider \u00e0 d\u00e9terminer sur quelle offre concentrer vos efforts marketing, ou \u00e0 l\u2019inverse r\u00e9duire vos investissements. Dans l\u2019onglet\u00a0<\/span>Pareto<\/strong>\u00a0<\/span>du\u00a0<\/span>fichier Excel_marketing.xlsx<\/em>, les donn\u00e9es se pr\u00e9sentent de la mani\u00e8re suivante :<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-pareto.png” alt=”excel Pareto” title_text=”excel-pareto” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”20px||20px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”]<\/p>\n
\u00c9tape n\u00b01<\/h3>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”||0px||false|false” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|phone”]<\/p>\n
La r\u00e9partition du chiffre d\u2019affaires par client<\/h4>\n
[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- S\u00e9lectionnez une cellule du tableau.<\/li>\n
- Au niveau du ruban, s\u00e9lectionnez\u00a0<\/span>Insertion<\/strong>\u00a0<\/span>– groupe Tableaux, cliquez sur\u00a0<\/span>Tableau crois\u00e9 dynamique<\/strong>.
La bo\u00eete de dialogue\u00a0<\/span>Cr\u00e9er un tableau crois\u00e9 dynamique<\/strong>\u00a0<\/span>appara\u00eet \u00e0 l\u2019\u00e9cran.<\/li>\n- V\u00e9rifiez que la zone\u00a0<\/span>S\u00e9lectionner un tableau ou une plage<\/strong>\u00a0<\/span>contient les donn\u00e9es \u00e0 analyser, c\u2019est-\u00e0-dire le\u00a0<\/span>Tableau1<\/strong>.<\/li>\n
- S\u00e9lectionnez\u00a0<\/span>Feuille de calcul existante<\/strong>\u00a0<\/span>et dans la zone\u00a0<\/span>Emplacement<\/strong>, activez la cellule\u00a0<\/span>H3<\/strong>.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-creer-tableau-dyn.png” alt=”Excel cr\u00e9er tableau crois\u00e9 dynamique” title_text=”excel-creer-tableau-dyn” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Cliquez sur le bouton\u00a0<\/span>OK<\/strong>.
Un rapport de tableau crois\u00e9 dynamique vierge appara\u00eet \u00e0 l\u2019\u00e9cran.
Sur la droite de l\u2019\u00e9cran, le volet\u00a0<\/span>Champs de tableau crois\u00e9 dynamique<\/strong>\u00a0<\/span>contient la liste des champs du tableau de donn\u00e9es.<\/li>\n- Placez le champ\u00a0<\/span>Clients<\/strong>\u00a0<\/span>dans la zone des lignes et le champ\u00a0<\/span>Montant<\/strong>\u00a0<\/span>dans la zone des Valeurs.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-champs-tableau-croise-dyn.png” alt=”Champs de tableau crois\u00e9 dynamique” title_text=”excel-champs-tableau-croise-dyn” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Le r\u00e9sultat est le suivant :<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-resultat.png” alt=”Excel r\u00e9sultat” title_text=”excel-resultat” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”20px||20px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”]<\/p>\n
\u00c9tape n\u00b02<\/h3>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”||0px||false|false” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|phone”]<\/p>\n
Obtenir la liste des clients qui repr\u00e9sentent 80 % du chiffre d\u2019affaires<\/h4>\n
[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Au niveau du tableau crois\u00e9 dynamique, r\u00e9alisez un clic droit dans la colonne\u00a0<\/span>Etiquettes de lignes, Filtrer puis 10 premiers<\/strong>.<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-filtrer.png” alt=”Excel filtrer” title_text=”excel-filtrer” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- La bo\u00eete de dialogue Filtre des 10 premiers (Client) appara\u00eet \u00e0 l\u2019\u00e9cran.<\/li>\n
- Saisissez\u00a0<\/span>80<\/strong>\u00a0<\/span>et s\u00e9lectionnez\u00a0<\/span>Pourcentage<\/strong>.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-filtrer-premiers.png” alt=”Excel – Filtre des 10 premiers” title_text=”excel-filtrer-premiers” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Cliquez sur\u00a0<\/span>OK<\/strong>, le r\u00e9sultat est le suivant\u00a0:<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-resultat-clients.png” alt=”Excel – R\u00e9sultat clients” title_text=”excel-resultat-clients” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Nous avons un total de 58 clients, 11 clients repr\u00e9sentent 80 % du chiffres d\u2019affaires.<\/li>\n<\/ul>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”20px||20px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”]<\/p>\n
\u00c9tape n\u00b03<\/h3>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”||0px||false|false” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|phone”]<\/p>\n
Repr\u00e9sentation graphique de la loi de Pareto<\/h4>\n
[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Au niveau du tableau de donn\u00e9es, s\u00e9lectionnez la colonne\u00a0<\/span>Client<\/strong>, appuyez sur la touche\u00a0<\/span>CTRL<\/strong>\u00a0<\/span>et s\u00e9lectionnez la colonne\u00a0<\/span>Montant<\/strong>.<\/li>\n
- Une fois les deux colonnes s\u00e9lectionn\u00e9es, au niveau du ruban, cliquez sur\u00a0<\/span>Insertion, Graphiques recommand\u00e9s<\/strong>.<\/li>\n
- La bo\u00eete de dialogue\u00a0<\/span>Ins\u00e9rer un graphique<\/strong>\u00a0<\/span>appara\u00eet \u00e0 l\u2019\u00e9cran par d\u00e9faut.
Excel a compris que vous souhaitiez r\u00e9alisez un graphique de Pareto !<\/li>\n<\/ul>\n[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-inserer-graphique.png” alt=”Excel – Ins\u00e9rer un graphique” title_text=”excel-inserer-graphique” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Cliquez sur\u00a0<\/span>OK<\/strong>, vous devez alors obtenir le r\u00e9sultat suivant :<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-resultat-graphique.png” alt=”Excel – R\u00e9sultat graphique” title_text=”excel-resultat-graphique” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”20px||20px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” header_3_text_color=”#3BB6D5″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”]<\/p>\n
Analyser automatiquement ses donn\u00e9es marketing gr\u00e2ce aux tableaux crois\u00e9s dynamiques<\/h3>\n
[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
L\u2019outil\u00a0<\/span>Id\u00e9es<\/strong>\u00a0<\/span>est une nouvelle fonctionnalit\u00e9 d\u2019Excel bas\u00e9e sur des algorithmes d\u2019intelligence artificielle afin d\u2019aider les utilisateurs \u00e0 analyser les donn\u00e9es gr\u00e2ce \u00e0 diff\u00e9rentes visualisations des donn\u00e9es.<\/p>\nConcr\u00e8tement, cette fonctionnalit\u00e9 propose diff\u00e9rentes visualisations \u00e0 partir des donn\u00e9es s\u00e9lectionn\u00e9es.<\/p>\n
Cela permet d\u2019obtenir de nouvelles pistes d\u2019analyse de vos donn\u00e9es marketing.<\/p>\n
\n- Dans l\u2019onglet\u00a0<\/span>Id\u00e9es<\/strong>, nous avons l\u2019ensemble des ventes de la soci\u00e9t\u00e9 Skunky, sp\u00e9cialis\u00e9e dans la nourriture et les jouets pour chiens et chats.
Les donn\u00e9es se pr\u00e9sentent de la mani\u00e8re suivante :<\/li>\n<\/ul>\n[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-onglets.png” alt=”Excel – onglets” title_text=”excel-onglets” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- S\u00e9lectionnez une cellule du tableau.<\/li>\n
- Dans l\u2019onglet\u00a0<\/span>Accueil<\/strong>\u00a0<\/span>du ruban, cliquez sur le bouton\u00a0<\/span>Id\u00e9es<\/strong>.\u00a0
![](\"https:\/\/www.editions-eni.fr\/rsc\/shared\/images\/blog\/capture_excel\/excel11.png\")
<\/li>\n- Le volet\u00a0<\/span>Id\u00e9es<\/strong>\u00a0<\/span>appara\u00eet sur la droite de l\u2019\u00e9cran. Excel propose automatiquement plusieurs analyses :<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-idees.png” alt=”Excel – Id\u00e9es” title_text=”excel-idees” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- S\u00e9lectionnez par exemple la troisi\u00e8me analyse\u00a0<\/span>\u00ab CA \u00bb a 4 valeurs hors norme<\/strong>.<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-hors-norme.png” alt=”Excel – hors norme” title_text=”excel-hors-norme” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Cliquez sur\u00a0<\/span>Ins\u00e9rer un graphique crois\u00e9 dynamique<\/strong>.<\/span>
Excel cr\u00e9e un nouvel onglet qui comprend un graphique crois\u00e9 et le tableau crois\u00e9 associ\u00e9.<\/span><\/li>\n<\/ul>\n[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-graphique-croise.png” alt=”Excel – Graphique crois\u00e9 dynamique” title_text=”excel-graphique-croise” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”20px||20px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”||||false|false”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” header_3_text_color=”#3BB6D5″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”]<\/p>\n
R\u00e9aliser des pr\u00e9visions marketing gr\u00e2ce \u00e0 l’outil feuille de pr\u00e9vision<\/h3>\n
[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
Depuis la version 2016 d\u2019Excel, de nouveaux outils avanc\u00e9s pour\u00a0<\/span>r\u00e9aliser des pr\u00e9visions<\/strong>\u00a0<\/span>sont apparus notamment l\u2019outil\u00a0<\/span>Feuille de pr\u00e9vision<\/strong>.<\/p>\nCet outil est bas\u00e9 sur le lissage exponentiel triple ou Exponential Triple Smoothing (ETS).<\/p>\n
Cette m\u00e9thode est aussi connue sous le nom de Holt – Winters, du nom des deux professeurs du MIT qui ont mis au point cet algorithme \u00e0 partir de la m\u00e9thode du lissage exponentiel.<\/p>\n
Cette fonction estime \u00e0 la fois :<\/p>\n
\n- La\u00a0<\/span>tendance<\/strong>\u00a0<\/span>de la s\u00e9rie chronologique \u00e9tudi\u00e9e.<\/li>\n
- La\u00a0<\/span>composante saisonni\u00e8re<\/strong>\u00a0<\/span>de la s\u00e9rie chronologique \u00e9tudi\u00e9e (si elle existe).<\/li>\n<\/ul>\n
L\u2019algorithme du lissage exponentiel triple donne plus d\u2019importance aux donn\u00e9es r\u00e9centes qu\u2019aux donn\u00e9es plus anciennes.
\u00c0 partir des donn\u00e9es de l\u2019onglet\u00a0<\/span>Feuille de pr\u00e9vision<\/strong>, nous allons effectuer une pr\u00e9vision du chiffre d\u2019affaires de la soci\u00e9t\u00e9 Skunky pour les 24 prochains mois.<\/p>\n\n- Dans l\u2019onglet\u00a0<\/span>Feuille de pr\u00e9vision<\/strong>, s\u00e9lectionnez une cellule du tableau de donn\u00e9es.<\/li>\n
- Au niveau du ruban, s\u00e9lectionnez\u00a0<\/span>Donn\u00e9es<\/strong>\u00a0<\/span>et dans le groupe\u00a0<\/span>Pr\u00e9vision, Feuille de pr\u00e9vision<\/strong>.
La bo\u00eete de dialogue\u00a0<\/span>Cr\u00e9er la feuille de calcul de pr\u00e9vision<\/strong>\u00a0<\/span>appara\u00eet \u00e0 l\u2019\u00e9cran.<\/li>\n<\/ul>\n[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-feuille-calcul-prevision.png” alt=”Excel – Cr\u00e9er la feuille de calcul de pr\u00e9vision” title_text=”excel-feuille-calcul-prevision” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Si vous cliquez sur\u00a0<\/span>Options<\/strong>, il est possible de calibrer votre pr\u00e9vision selon vos besoins\u00a0:<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-options-calibrer.png” alt=”Excel – Options” title_text=”excel-options-calibrer” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
\n- Cliquez sur le bouton\u00a0<\/span>Cr\u00e9er<\/strong>.<\/span>
Excel cr\u00e9e un nouvel onglet qui contient :<\/span>\nUn graphique<\/p>\n<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-graphique.png” alt=”Excel – graphique” title_text=”excel-graphique” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
et une table de donn\u00e9es<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/excel-table-donnees.png” alt=”Excel – Table de donn\u00e9es” title_text=”excel-table-donnees” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_image][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n
Notez l\u2019intervalle de confiance mat\u00e9rialis\u00e9 \u00e0 la fois sur le graphique et dans les colonnes\u00a0<\/span>Limite de confiance inf\u00e9rieure (C.A) et Limite de confiance sup\u00e9rieure (C.A)<\/strong>.<\/p>\nPar d\u00e9faut, cet\u00a0<\/span>intervalle de confiance<\/strong>\u00a0<\/span>est param\u00e9tr\u00e9 \u00e0 95 %.<\/p>\nEt voil\u00e0 ! \u00cates-vous arriv\u00e9 \u00e0 remplir vos missions ?
Si oui, f\u00e9licitations, vous pouvez vous consid\u00e9rer comme un utilisateur avanc\u00e9 d\u2019Excel.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_testimonial author=”Boris Noro” job_title=”notre expert Excel” portrait_url=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/Noro-Boris.jpg” _builder_version=”4.9.0″ _module_preset=”default” custom_margin=”||0px||false|false” custom_padding=”||||false|false”]<\/p>\n
Comptable de profession, formateur bureautique depuis plusieurs ann\u00e9es et animateur de la cha\u00eene YouTube Wise cat, Boris NORO a acquis une forte exp\u00e9rience dans la mise en place d’outils budg\u00e9taires et financiers avec Microsoft Excel aupr\u00e8s d’entreprises diverses et de collectivit\u00e9s territoriales.<\/span>
Passionn\u00e9 par l’analyse de donn\u00e9es, il poursuit actuellement la formation Business Statistics and Analysis \u00e0 l’universit\u00e9 RICE (Houston \u2013 Etats-Unis) et d\u00e9tient la certification Microsoft Excel for the Data Analyst.<\/span><\/p>\n[\/et_pb_testimonial][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” locked=”off”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default” locked=”off”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ text_font=”||||||||” text_line_height=”1.8em” header_font=”||||||||” header_2_font=”Overpass|300|||||||” header_2_font_size=”35px” header_2_line_height=”1.5em” custom_margin=”||0px||false|false” header_2_font_size_tablet=”30px” header_2_font_size_phone=”20px” header_2_font_size_last_edited=”on|phone” border_color_all=”#1a0a38″]<\/p>\n
Pour aller plus loin<\/span><\/h2>\n[\/et_pb_text][et_pb_divider color=”#3BB6D5″ divider_position=”center” divider_weight=”3px” _builder_version=”4.9.0″ max_width=”90px” max_width_tablet=”13%” max_width_last_edited=”off|desktop” custom_margin=”5px||||false|false” custom_padding=”|||” locked=”off”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ _builder_version=”4.9.0″ _module_preset=”default” custom_css_main_element_last_edited=”on|phone” custom_css_main_element_tablet=”display:flex;” custom_css_main_element_phone=”display:inherit;”][et_pb_column type=”1_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/livre\/analyse-de-donnees-pour-le-marketing-avec-excel-9782409025532_XL.jpg” alt=”Scratch et Raspberry Pi Projets maker pour s’initier \u00e0 l’\u00e9lectronique et \u00e0 la robotique” title_text=”scratch-et-raspberry-pi-projets-maker-pour-s-initier-a-l-electronique-et-a-la-robotique-2e-edition-9782409027901_M” url=”https:\/\/www.editions-eni.fr\/livre\/analyse-de-donnees-pour-le-marketing-avec-excel-9782409025532″ url_new_window=”on” _builder_version=”4.9.0″ _module_preset=”default” width_tablet=”85%” width_phone=”” width_last_edited=”on|tablet” custom_margin=”||10px||false|false” box_shadow_style=”preset3″ transform_styles__hover_enabled=”on|hover” transform_scale__hover=”105%|105%” transform_scale__hover_enabled=”on|hover” transform_translate__hover_enabled=”on|desktop” transform_rotate__hover_enabled=”on|desktop” transform_skew__hover_enabled=”on|desktop” transform_origin__hover_enabled=”on|desktop”][\/et_pb_image][et_pb_text _builder_version=”4.9.7″ _module_preset=”default” text_font=”||||||||” text_text_color=”#3BB6D5″ background_color=”RGBA(0,0,0,0)” custom_margin=”||5px||false|false”]<\/p>\n
Livre<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_padding_tablet=”|10px|||false|false” custom_padding_phone=”|0px|||false|false” custom_padding_last_edited=”on|phone”]<\/p>\n
Analyse de donn\u00e9es pour le marketing<\/strong>
Avec Excel<\/p>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/media2.editions-eni.fr\/video\/excel-2019-vb19exc_M.jpg” alt=”Flutter D\u00e9veloppez vos applications mobiles multiplateformes avec Dart” title_text=”flutter-developpez-vos-applications-mobiles-multiplateformes-avec-dart-9782409025273_M (1)” url=”https:\/\/www.editions-eni.fr\/video\/excel-2019-vb19exc” url_new_window=”on” force_fullwidth=”on” _builder_version=”4.9.7″ _module_preset=”default” width_tablet=”85%” width_phone=”” width_last_edited=”on|tablet” custom_margin=”||10px||false|false” transform_styles__hover_enabled=”on|hover” transform_scale__hover=”105%|105%” transform_scale__hover_enabled=”on|hover” transform_translate__hover_enabled=”on|desktop” transform_rotate__hover_enabled=”on|desktop” transform_skew__hover_enabled=”on|desktop” transform_origin__hover_enabled=”on|desktop”][\/et_pb_image][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” text_text_color=”#3BB6D5″ background_color=”RGBA(0,0,0,0)” custom_margin=”||5px||false|false”]<\/p>\n
Vid\u00e9o<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_padding_tablet=”|10px|||false|false” custom_padding_phone=”|0px|||false|false” custom_padding_last_edited=”on|phone”]<\/p>\n
Flutter<\/strong>
D\u00e9veloppez vos applications mobiles multiplateformes avec Dart<\/small><\/p>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/livre\/excel-versions-2019-et-office-365-maitrisez-les-fonctions-avancees-du-tableur-de-microsoft-9782409016950_XL.jpg” alt=”Flutter D\u00e9veloppez vos applications mobiles multiplateformes avec Dart” title_text=”presentiel-web” url=”https:\/\/www.editions-eni.fr\/livre\/excel-versions-2019-et-office-365-maitrisez-les-fonctions-avancees-du-tableur-de-microsoft-9782409016950″ url_new_window=”on” _builder_version=”4.9.0″ _module_preset=”default” width_tablet=”85%” width_phone=”” width_last_edited=”on|tablet” custom_margin=”||10px||false|false” box_shadow_style=”preset3″ transform_styles__hover_enabled=”on|hover” transform_scale__hover=”105%|105%” transform_scale__hover_enabled=”on|hover” transform_translate__hover_enabled=”on|desktop” transform_rotate__hover_enabled=”on|desktop” transform_skew__hover_enabled=”on|desktop” transform_origin__hover_enabled=”on|desktop”][\/et_pb_image][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” text_text_color=”#3BB6D5″ background_color=”RGBA(0,0,0,0)” custom_margin=”||5px||false|false”]<\/p>\n
Livre<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_padding_tablet=”|10px|||false|false” custom_padding_phone=”|0px|||false|false” custom_padding_last_edited=”on|phone”]<\/p>\n
Excel (versions 2019 et Office 365)<\/strong>
Ma\u00eetrisez les fonctions avanc\u00e9es du tableur de Microsoft<\/p>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/presentiel-bureautique.jpg” alt=”formation en live” title_text=”formation en live” url=”https:\/\/www.eni-service.fr\/index.php\/fomation\/excel-revisions-approfondissement-et-approche-tableaux-croises-dynamiques-intermediaire\/” url_new_window=”on” _builder_version=”4.9.0″ _module_preset=”default” width_tablet=”85%” width_phone=”” width_last_edited=”on|tablet” custom_margin=”||10px||false|false” box_shadow_style=”preset3″ transform_styles__hover_enabled=”on|hover” transform_scale__hover=”105%|105%” transform_scale__hover_enabled=”on|hover” transform_translate__hover_enabled=”on|desktop” transform_rotate__hover_enabled=”on|desktop” transform_skew__hover_enabled=”on|desktop” transform_origin__hover_enabled=”on|desktop”][\/et_pb_image][et_pb_text _builder_version=”4.9.7″ _module_preset=”default” text_font=”||||||||” text_text_color=”#3BB6D5″ background_color=”RGBA(0,0,0,0)” hover_enabled=”0″ custom_margin=”||5px||false|false” sticky_enabled=”0″]<\/p>\n
Formation<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” custom_padding_tablet=”|10px|||false|false” custom_padding_phone=”|0px|||false|false” custom_padding_last_edited=”on|phone”]<\/p>\n
Excel<\/strong>
R\u00e9visions, approfondissement et approche tableaux crois\u00e9s dynamiques<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.7″ text_font=”||||||||” text_line_height=”1.8em” header_font=”||||||||” header_2_font=”Overpass|300|||||||” header_2_font_size=”35px” header_2_line_height=”1.5em” custom_margin=”||0px||false|false” header_2_font_size_tablet=”30px” header_2_font_size_phone=”20px” header_2_font_size_last_edited=”on|phone” border_color_all=”#1a0a38″]<\/p>\n
Ces articles peuvent aussi vous int\u00e9resser<\/span><\/h2>\n[\/et_pb_text][et_pb_divider color=”#3BB6D5″ divider_position=”center” divider_weight=”3px” _builder_version=”4.9.0″ max_width=”90px” max_width_tablet=”13%” max_width_last_edited=”off|desktop” custom_margin=”5px||||false|false” custom_padding=”|||” locked=”off”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.9.0″ _module_preset=”default” width_tablet=”60%” width_last_edited=”off|tablet” custom_margin_tablet=”|10px||10px|false|false” custom_margin_last_edited=”off|tablet” custom_css_main_element_last_edited=”off|tablet” custom_css_main_element_tablet=”display:flex;” custom_css_main_element_phone=”display:inherit;”][et_pb_column type=”1_3″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_slider use_bg_overlay=”on” bg_overlay_color=”rgba(26,10,56,0.6)” _builder_version=”4.9.7″ _module_preset=”default” header_level=”h4″ header_font=”Overpass||||||||” header_font_size=”18px” height=”320px” custom_margin=”0px||40px||false|false” custom_padding=”180px|0px|0px|0px|false|false” custom_padding_tablet=”150px||||false|false” custom_padding_phone=”” custom_padding_last_edited=”on|desktop” link_option_url=”\/blog\/7-astuces-pour-creer-facilement-des-reportings-rh-efficaces-grace-aux-tableaux-croises-dynamiques-avec-excel\/” border_radii=”on|20px|20px|20px|20px” box_shadow_style=”preset3″ custom_margin__hover_enabled=”on|hover” custom_margin__hover=”-10px||30px||false|false” custom_padding__hover_enabled=”on|desktop” custom_padding__hover=”||0px||false|false” height__hover=”330px” height__hover_enabled=”on|desktop”][et_pb_slide button_link=”\/blog\/7-astuces-pour-creer-facilement-des-reportings-rh-efficaces-grace-aux-tableaux-croises-dynamiques-avec-excel\/” _builder_version=”4.9.0″ _module_preset=”default” background_image=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau_excel_rh.jpg” background_enable_image=”on” custom_padding=”||||false|false” custom_padding__hover_enabled=”off|desktop” custom_padding__hover=”280px||||false|false” sticky_transition=”on”]<\/p>\n
7 astuces pour cr\u00e9er des reportings RH efficaces<\/h4>\n
[\/et_pb_slide][\/et_pb_slider][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_slider use_bg_overlay=”on” bg_overlay_color=”rgba(26,10,56,0.6)” _builder_version=”4.9.7″ _module_preset=”default” header_level=”h4″ header_font=”Overpass||||||||” header_font_size=”18px” height=”320px” custom_margin=”0px||40px||false|false” custom_padding=”180px|0px|0px|0px|false|false” custom_padding_tablet=”150px||||false|false” custom_padding_phone=”” custom_padding_last_edited=”on|desktop” link_option_url=”\/blog\/5-astuces-pour-optimiser-sa-gestion-comptable-avec-excel-et-les-tableaux-croises-dynamiques\/” border_radii=”on|20px|20px|20px|20px” box_shadow_style=”preset3″ custom_margin__hover_enabled=”on|hover” custom_margin__hover=”-10px||30px||false|false” custom_padding__hover_enabled=”on|desktop” custom_padding__hover=”||0px||false|false” height__hover=”330px” height__hover_enabled=”on|desktop”][et_pb_slide button_link=”\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/” _builder_version=”4.9.0″ _module_preset=”default” background_image=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau_excel-compta.jpg” background_enable_image=”on” custom_padding=”||||false|false” custom_padding__hover_enabled=”off|desktop” custom_padding__hover=”280px||||false|false” sticky_transition=”on”]<\/p>\n
optimiser sa gestion comptable avec Excel<\/h4>\n
[\/et_pb_slide][\/et_pb_slider][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_slider use_bg_overlay=”on” bg_overlay_color=”rgba(26,10,56,0.6)” _builder_version=”4.9.7″ _module_preset=”default” header_level=”h4″ header_font=”Overpass||||||||” header_font_size=”18px” height=”320px” custom_margin=”0px||40px||false|false” custom_padding=”180px|0px|0px|0px|false|false” custom_padding_tablet=”150px||||false|false” custom_padding_phone=”” custom_padding_last_edited=”on|desktop” link_option_url=”\/blog\/excel-et-tableaux-croises-dynamiques\/” border_radii=”on|20px|20px|20px|20px” box_shadow_style=”preset3″ custom_margin__hover_enabled=”on|hover” custom_margin__hover=”-10px||30px||false|false” custom_padding__hover_enabled=”on|desktop” custom_padding__hover=”||0px||false|false” border_radii__hover_enabled=”off|hover” border_radii__hover=”on||||” height__hover=”330px” height__hover_enabled=”on|desktop”][et_pb_slide button_link=”\/blog\/azure\/” _builder_version=”4.9.7″ _module_preset=”default” background_image=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg” background_enable_image=”on” custom_padding=”||||false|false” custom_padding__hover_enabled=”off|desktop” custom_padding__hover=”280px||||false|false” sticky_transition=”on”]Dossier<\/p>\n
Excel et tableaux crois\u00e9s dynamiques<\/h4>\n
[\/et_pb_slide][\/et_pb_slider][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Afin de vous apporter quelques pistes applicables au marketing, notre expert Boris Noro vous propose 3 cas d\u2019analyse de donn\u00e9es afin d\u2019optimiser vos actions et vous aider \u00e0 prendre des d\u00e9cisions.<\/p>\n","protected":false},"author":3,"featured_media":1634,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"categories":[7,18,9],"tags":[],"genre":[],"class_list":["post-1534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bureautique","category-paroles-d-experts","category-webmarketing"],"acf":[],"yoast_head":"\n
3 astuces pour analyser vos donn\u00e9es marketing avec Excel - ENI Blog<\/title>\n<meta name=\"description\" content=\"Analysez plus efficacement vos donn\u00e9es marketing avec Excel, en optimisant vos actions, pour vous permettre de prendre les bonnes d\u00e9cisions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 astuces pour analyser vos donn\u00e9es marketing avec Excel - ENI Blog\" \/>\n<meta property=\"og:description\" content=\"Analysez plus efficacement vos donn\u00e9es marketing avec Excel, en optimisant vos actions, pour vous permettre de prendre les bonnes d\u00e9cisions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Eni Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-11T09:28:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-06T06:51:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"680\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Erwan Caillarec\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erwan Caillarec\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/\",\"url\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/\",\"name\":\"3 astuces pour analyser vos donn\u00e9es marketing avec Excel - ENI Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg\",\"datePublished\":\"2021-06-11T09:28:37+00:00\",\"dateModified\":\"2021-07-06T06:51:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/#\/schema\/person\/0dc710628e4fb046b1006320d8bf5927\"},\"description\":\"Analysez plus efficacement vos donn\u00e9es marketing avec Excel, en optimisant vos actions, pour vous permettre de prendre les bonnes d\u00e9cisions.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#primaryimage\",\"url\":\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg\",\"contentUrl\":\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg\",\"width\":1920,\"height\":680,\"caption\":\"Bandeau Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.editions-eni.fr\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 astuces pour analyser vos donn\u00e9es marketing avec Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/#website\",\"url\":\"https:\/\/www.editions-eni.fr\/blog\/\",\"name\":\"Eni Blog\",\"description\":\"Blog des Editions ENI\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.editions-eni.fr\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/#\/schema\/person\/0dc710628e4fb046b1006320d8bf5927\",\"name\":\"Erwan Caillarec\",\"url\":\"https:\/\/www.editions-eni.fr\/blog\/author\/ecaillarec\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 astuces pour analyser vos donn\u00e9es marketing avec Excel - ENI Blog","description":"Analysez plus efficacement vos donn\u00e9es marketing avec Excel, en optimisant vos actions, pour vous permettre de prendre les bonnes d\u00e9cisions.","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:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/","og_locale":"fr_FR","og_type":"article","og_title":"3 astuces pour analyser vos donn\u00e9es marketing avec Excel - ENI Blog","og_description":"Analysez plus efficacement vos donn\u00e9es marketing avec Excel, en optimisant vos actions, pour vous permettre de prendre les bonnes d\u00e9cisions.","og_url":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/","og_site_name":"Eni Blog","article_published_time":"2021-06-11T09:28:37+00:00","article_modified_time":"2021-07-06T06:51:43+00:00","og_image":[{"width":1920,"height":680,"url":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg","type":"image\/jpeg"}],"author":"Erwan Caillarec","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Erwan Caillarec","Dur\u00e9e de lecture estim\u00e9e":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/","url":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/","name":"3 astuces pour analyser vos donn\u00e9es marketing avec Excel - ENI Blog","isPartOf":{"@id":"https:\/\/www.editions-eni.fr\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg","datePublished":"2021-06-11T09:28:37+00:00","dateModified":"2021-07-06T06:51:43+00:00","author":{"@id":"https:\/\/www.editions-eni.fr\/blog\/#\/schema\/person\/0dc710628e4fb046b1006320d8bf5927"},"description":"Analysez plus efficacement vos donn\u00e9es marketing avec Excel, en optimisant vos actions, pour vous permettre de prendre les bonnes d\u00e9cisions.","breadcrumb":{"@id":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#primaryimage","url":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg","contentUrl":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/bandeau03.jpg","width":1920,"height":680,"caption":"Bandeau Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.editions-eni.fr\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.editions-eni.fr\/blog\/"},{"@type":"ListItem","position":2,"name":"3 astuces pour analyser vos donn\u00e9es marketing avec Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.editions-eni.fr\/blog\/#website","url":"https:\/\/www.editions-eni.fr\/blog\/","name":"Eni Blog","description":"Blog des Editions ENI","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.editions-eni.fr\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.editions-eni.fr\/blog\/#\/schema\/person\/0dc710628e4fb046b1006320d8bf5927","name":"Erwan Caillarec","url":"https:\/\/www.editions-eni.fr\/blog\/author\/ecaillarec\/"}]}},"_links":{"self":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/posts\/1534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/comments?post=1534"}],"version-history":[{"count":53,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/posts\/1534\/revisions"}],"predecessor-version":[{"id":3798,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/posts\/1534\/revisions\/3798"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/media\/1634"}],"wp:attachment":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/media?parent=1534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/categories?post=1534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/tags?post=1534"},{"taxonomy":"genre","embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/genre?post=1534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}