{"id":1156,"date":"2021-06-09T09:47:20","date_gmt":"2021-06-09T07:47:20","guid":{"rendered":"https:\/\/preprod.editions-eni.fr\/blog\/?page_id=1156"},"modified":"2024-04-04T11:27:02","modified_gmt":"2024-04-04T09:27:02","slug":"excel-et-tableaux-croises-dynamiques","status":"publish","type":"page","link":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/","title":{"rendered":"Excel et tableaux crois\u00e9s dynamiques"},"content":{"rendered":"

[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 quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

En octobre dernier nous vous avons\u00a0<\/span>tout dit sur Teams<\/span><\/span>, mais saviez-vous que Excel est LE Logiciel le plus utilis\u00e9 en entreprise ?! Quel que soit votre secteur d\u2019activit\u00e9, votre m\u00e9tier, que vous disposiez d\u2019un ordinateur ou d\u2019une tablette, vous avez s\u00fbrement d\u00e9j\u00e0 utilis\u00e9 ou m\u00eame cr\u00e9\u00e9 ces fameuses feuilles de calcul. Devenu incontournable, ce fabuleux outil vous permet aussi de cr\u00e9er des graphiques efficaces, de g\u00e9rer des plannings, de faire des tableaux de suivi, de r\u00e9aliser des simulations, des sc\u00e9narios et tout type d\u2019analyse gr\u00e2ce aux tableaux crois\u00e9s dynamiques et \u00e0 ses fonctionnalit\u00e9s de BI.<\/span><\/p>\n

Alors ce mois-ci, nous avons d\u00e9cid\u00e9 de tout vous dire sur Excel\u00a0!<\/strong><\/p>\n

Corinne Hervo et l\u2019\u00e9quipe \u00e9ditoriale ENI\u00a0<\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/go.drimify.com\/quizz.html?quizid=20682797925fbb93c90d987625444982-5fbb93c90d98f&lang=fr” url_new_window=”on” button_text=”J’identifie mon profil d’utilisateur Excel” _builder_version=”4.9.0″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#3BB6D5″ button_border_color=”#3BB6D5″ button_use_icon=”off” button_bg_color_last_edited=”off|desktop” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#3BB6D5″ button_bg_enable_color__hover=”on” button_text_color__hover_enabled=”on|hover” button_text_color__hover=”#FFFFFF”][\/et_pb_button][\/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=”0px||||false|false”][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.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

Les rendez-vous IT<\/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_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

Webinaire<\/h3>\n

Comment les tableaux crois\u00e9s dynamiques sur Excel peuvent vous faire gagner en efficacit\u00e9 en quelques clics\u00a0?<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_video src=”https:\/\/youtu.be\/ZF7CKVIG2fU” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_video][\/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=”0px||||false|false”][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.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

La parole aux EXPERTS<\/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_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

Jo\u00ebl PYZAK<\/p><\/blockquote>\n

[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

Comment les tableaux crois\u00e9s dynamiques sur Excel peuvent vous faire gagner en efficacit\u00e9 ?<\/h3>\n

Vous souhaitez analyser, agr\u00e9ger des valeurs d\u2019une table de donn\u00e9es constitu\u00e9e de nombreuses colonnes et lignes ? Alors les tableaux crois\u00e9s dynamiques (TCD ou PivotTable)…<\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.eni-service.fr\/index.php\/comment-les-tableaux-croises-dynamiques-sur-excel-peuvent-vous-faire-gagner-en-efficacite\/” url_new_window=”on” button_text=”Lire l’article” _builder_version=”4.9.0″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#3BB6D5″ button_border_color=”#3BB6D5″ button_use_icon=”off” button_bg_color_last_edited=”off|desktop” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#3BB6D5″ button_bg_enable_color__hover=”on” button_text_color__hover_enabled=”on|hover” button_text_color__hover=”#FFFFFF”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/joel.jpg” alt=”Jo\u00ebl Pyzak” title_text=”joel” _builder_version=”4.9.7″ _module_preset=”default” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”5%” border_width_all=”1px” border_color_all=”#3BB6D5″][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

\n

Boris NORO<\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

3 astuces pour mieux piloter votre activit\u00e9 marketing gr\u00e2ce \u00e0 Excel et aux tableaux crois\u00e9s dynamiques<\/h3>\n

90 % des donn\u00e9es dans le monde ont \u00e9t\u00e9 cr\u00e9\u00e9es au cours des deux derni\u00e8res ann\u00e9es ! Les donn\u00e9es ont envahi notre quotidien, du divertissement \u00e0 la politique, de la technologie \u00e0 la publicit\u00e9 et de la science au monde de l\u2019entreprise, le marketing n\u2019y a \u00e9videmment pas \u00e9chapp\u00e9 !<\/p>\n

[\/et_pb_text][et_pb_button button_url=”\/blog\/3-astuces-pour-analyser-vos-donnees-marketing-avec-excel\/” button_text=”Lire l’article” _builder_version=”4.9.7″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#3BB6D5″ button_border_color=”#3BB6D5″ button_use_icon=”off” button_bg_color_last_edited=”off|desktop” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#3BB6D5″ button_bg_enable_color__hover=”on” button_text_color__hover_enabled=”on|hover” button_text_color__hover=”#FFFFFF”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/boris.jpg” alt=”Boris Noro” title_text=”boris” _builder_version=”4.9.0″ _module_preset=”default” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”5%” border_width_all=”1px” border_color_all=”#3BB6D5″][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

\n

Pierre-Alexandre GROLLEAU<\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

7 astuces pour cr\u00e9er des reportings RH efficaces gr\u00e2ce \u00e0 Excel et aux tableaux crois\u00e9s dynamiques<\/h3>\n

Avec l\u2019apparition du big data, et la digitalisation de la soci\u00e9t\u00e9, la fonction ressources humaines est aujourd\u2019hui en cours de transformation et se doit de s\u2019adapter notamment via l\u2019utilisation des KPI (Indicateurs cl\u00e9s de succ\u00e8s) pr\u00e9sent\u00e9s sous forme de tableaux de bord. Excel devient alors l\u2019outil num\u00e9ro 1 dans leur construction et dans leur mode de communication.<\/p>\n

[\/et_pb_text][et_pb_button button_url=”\/blog\/7-astuces-pour-creer-facilement-des-reportings-rh-efficaces-grace-aux-tableaux-croises-dynamiques-avec-excel\/” button_text=”Lire l’article” _builder_version=”4.9.7″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#3BB6D5″ button_border_color=”#3BB6D5″ button_use_icon=”off” button_bg_color_last_edited=”off|desktop” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#3BB6D5″ button_bg_enable_color__hover=”on” button_text_color__hover_enabled=”on|hover” button_text_color__hover=”#FFFFFF”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/pierre.jpg” alt=”Pierre-Alexandre Grolleau” title_text=”pierre” _builder_version=”4.9.0″ _module_preset=”default” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”5%” border_width_all=”1px” border_color_all=”#3BB6D5″][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

\n

Faiza MOUMEN PIASCO<\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

5 astuces pour optimiser sa gestion comptable avec Excel et les tableaux crois\u00e9s dynamiques<\/h3>\n

En raison de la digitalisation, le m\u00e9tier de comptable voit se profiler de nombreux changements dans sa pratique professionnelle. Certaines t\u00e2ches vont dispara\u00eetre au profit d’autres qui seront tourn\u00e9es essentiellement vers le contr\u00f4le, l’analyse et le conseil. Que vous soyez professionnel de la comptabilit\u00e9 ou…<\/p>\n

[\/et_pb_text][et_pb_button button_url=”\/blog\/5-astuces-pour-optimiser-sa-gestion-comptable-avec-excel-et-les-tableaux-croises-dynamiques\/” button_text=”Lire l’article” _builder_version=”4.9.7″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#3BB6D5″ button_border_color=”#3BB6D5″ button_use_icon=”off” button_bg_color_last_edited=”off|desktop” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#3BB6D5″ button_bg_enable_color__hover=”on” button_text_color__hover_enabled=”on|hover” button_text_color__hover=”#FFFFFF”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/faiza.jpg” alt=”Faiza Moumen Piasco” title_text=”faiza” _builder_version=”4.9.0″ _module_preset=”default” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”5%” border_width_all=”1px” border_color_all=”#3BB6D5″][\/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=”0px||||false|false”][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.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

Ils se sont LANCÉS !<\/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 _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_video src=”https:\/\/youtu.be\/3facZnc1OaI” _builder_version=”4.9.0″ _module_preset=”default”][\/et_pb_video][et_pb_text quote_border_color=”#3BB6D5″ _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||”]<\/p>\n

La Poste a choisi ENI pour former ses collaborateurs \u00e0 Excel en e-learning !<\/span><\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.eni-elearning.com\/fr\/groupe-la-poste-formation-e-learning-office-et-parcours-certifiants.htm” url_new_window=”on” button_text=”Voir le t\u00e9moignage” _builder_version=”4.9.0″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#3BB6D5″ button_border_color=”#3BB6D5″ button_use_icon=”off” button_bg_color_last_edited=”off|desktop” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#3BB6D5″ button_bg_enable_color__hover=”on” button_text_color__hover_enabled=”on|hover” button_text_color__hover=”#FFFFFF”][\/et_pb_button][\/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” 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\/excel-versions-2019-et-office-365-9782409016523_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\/excel-versions-2019-et-office-365-9782409016523″ url_new_window=”on” _builder_version=”4.9.7″ _module_preset=”default” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|tablet” border_radii_last_edited=”off|desktop” box_shadow_style=”preset3″ transform_styles__hover_enabled=”on|hover” 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” transform_scale__hover=”105%|105%” custom_margin__hover_enabled=”off|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

Excel<\/strong>
versions 2019 et Office 365<\/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-2019-coffret-de-2-livres-le-manuel-de-reference-le-cahier-d-exercices-9782409022883_XL.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\/livre\/excel-2019-coffret-de-2-livres-le-manuel-de-reference-le-cahier-d-exercices-9782409022883″ url_new_window=”on” _builder_version=”4.9.7″ _module_preset=”default” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|tablet” 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 2019<\/strong>
Coffret de 2 livres : Le Manuel de r\u00e9f\u00e9rence + le Cahier d’exercices<\/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\/2022\/01\/vignetteCPF-01.jpg” alt=”formation en live” title_text=”vignetteCPF-01″ 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.7″ _module_preset=”default” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|tablet” 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

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_column type=”1_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/formation\/formation-en-ligne-excel-2019-toutes-les-fonctionnalites-d-excel-a-votre-portee-le-livre-numerique-excel-2019-offert-valable-1-an-en-illimite-fmladp-19exc_XL.jpg” alt=”Flutter D\u00e9veloppez vos applications mobiles multiplateformes avec Dart” title_text=”elearning-system” url=”https:\/\/www.editions-eni.fr\/formation\/formation-en-ligne-excel-2019-toutes-les-fonctionnalites-d-excel-a-votre-portee-le-livre-numerique-excel-2019-offert-valable-1-an-en-illimite-fmladp-19exc” url_new_window=”on” _builder_version=”4.9.0″ _module_preset=”default” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|tablet” 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

Formation e-learning<\/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

Formation en ligne Excel 2019<\/strong>
Toutes les fonctionnalit\u00e9s d’Excel \u00e0 votre port\u00e9e<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.7″ _module_preset=”default” custom_margin=”0px||0px||false|false” custom_padding=”0px||50px||false|false” locked=”off”][et_pb_row _builder_version=”4.9.7″ _module_preset=”default” background_color=”#7ebec5″ custom_margin=”40px||||false|false” custom_padding=”20px||0px|20px|false|false” border_radii=”off|20px|20px||”][et_pb_column type=”4_4″ _builder_version=”4.9.7″ _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” header_3_line_height=”1.8em” custom_margin=”0px||0px||false|false” custom_padding=”0px||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 LES ENTREPRISES<\/span><\/h3>\n

[\/et_pb_text][et_pb_text _builder_version=”4.9.7″ text_font=”||||||||” text_text_color=”#000000″ text_line_height=”1em” header_font=”||||||||” header_2_font=”Overpass|300|||||||” header_2_font_size=”35px” header_2_line_height=”1.5em” header_3_line_height=”1.8em” custom_margin=”0px||20px||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

D\u00e9couvrez nos solutions de formation pour vos \u00e9quipes et apprenants :<\/span><\/h4>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.9.7″ _module_preset=”default” background_color=”#7ebec5″ custom_padding=”|30px|30px|30px|false|false” border_radii=”off|||20px|20px” border_color_all=”#3BB6D5″][et_pb_column type=”1_3″ _builder_version=”4.9.7″ _module_preset=”default” border_color_all=”#3BB6D5″][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/reflechir.jpg” alt=”R\u00e9fl\u00e9chir en amont” title_text=”reflechir” _builder_version=”4.9.7″ _module_preset=”default” border_color_all=”#000000″ box_shadow_style=”preset1″][\/et_pb_image][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.9.7″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/10\/iconeElearning.png” alt=”elearning” title_text=”iconeElearning” align=”center” _builder_version=”4.9.7″ _module_preset=”default” custom_margin=”10px||||false|false”][\/et_pb_image][et_pb_text _builder_version=”4.9.7″ _module_preset=”default” header_4_text_color=”#FFFFFF”]<\/p>\n

En e-learning avec
notre offre pour les professionnels<\/h4>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.eni-elearning.com\/fr\/office-bureautique\/” url_new_window=”on” button_text=”En savoir plus” button_alignment=”center” _builder_version=”4.9.7″ _module_preset=”default” custom_button=”on” button_text_color=”#EEEEEE” hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.9.7″ _module_preset=”default”][et_pb_image src=”https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/10\/iconeFormateur.png” alt=”formateur” title_text=”iconeFormateur” align=”center” _builder_version=”4.9.7″ _module_preset=”default” custom_margin=”10px||||false|false”][\/et_pb_image][et_pb_text _builder_version=”4.9.7″ _module_preset=”default” header_4_text_color=”#FFFFFF”]<\/p>\n

Avec un formateur,
en pr\u00e9sentiel ou \u00e0 distance<\/h4>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.eni-service.fr\/?sfid=2675&_sf_s=excel” url_new_window=”on” button_text=”En savoir plus” button_alignment=”center” _builder_version=”4.9.7″ _module_preset=”default” custom_button=”on” button_text_color=”#FFFFFF” hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

En octobre dernier nous vous avons tout dit sur Teams, mais saviez-vous que Excel est LE Logiciel le plus utilis\u00e9 en entreprise ?! Quel que soit votre secteur d\u2019activit\u00e9, votre m\u00e9tier, que vous disposiez d\u2019un ordinateur ou d\u2019une tablette, vous avez s\u00fbrement d\u00e9j\u00e0 utilis\u00e9 ou m\u00eame cr\u00e9\u00e9 ces fameuses feuilles de calcul. Devenu incontournable, ce fabuleux outil vous permet aussi de cr\u00e9er des graphiques efficaces, de g\u00e9rer des plannings, de faire des tableaux de suivi, de r\u00e9aliser des simulations, des sc\u00e9narios et tout type d\u2019analyse gr\u00e2ce aux tableaux crois\u00e9s dynamiques et \u00e0 ses fonctionnalit\u00e9s de BI.<\/p>\n

Alors ce mois-ci, nous avons d\u00e9cid\u00e9 de tout vous dire sur Excel !<\/p>\n","protected":false},"author":3,"featured_media":1437,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"genre":[27],"class_list":["post-1156","page","type-page","status-publish","has-post-thumbnail","hentry","genre-bureautique"],"acf":[],"yoast_head":"\nExcel et tableaux crois\u00e9s dynamiques : tout savoir ! - ENI Blog<\/title>\n<meta name=\"description\" content=\"Interviews, webinaires, conseils d'experts... On vous dit tout sur Excel et sur les tableaux crois\u00e9s dynamiques pour gagner en autonomie !\" \/>\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\/excel-et-tableaux-croises-dynamiques\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel et tableaux crois\u00e9s dynamiques : tout savoir ! - ENI Blog\" \/>\n<meta property=\"og:description\" content=\"Interviews, webinaires, conseils d'experts... On vous dit tout sur Excel et sur les tableaux crois\u00e9s dynamiques pour gagner en autonomie !\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/\" \/>\n<meta property=\"og:site_name\" content=\"Eni Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-04T09:27:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1282\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 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\/excel-et-tableaux-croises-dynamiques\/\",\"url\":\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/\",\"name\":\"Excel et tableaux crois\u00e9s dynamiques : tout savoir ! - ENI Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg\",\"datePublished\":\"2021-06-09T07:47:20+00:00\",\"dateModified\":\"2024-04-04T09:27:02+00:00\",\"description\":\"Interviews, webinaires, conseils d'experts... On vous dit tout sur Excel et sur les tableaux crois\u00e9s dynamiques pour gagner en autonomie !\",\"breadcrumb\":{\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#primaryimage\",\"url\":\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg\",\"contentUrl\":\"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg\",\"width\":1920,\"height\":1282,\"caption\":\"Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.editions-eni.fr\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel et tableaux crois\u00e9s dynamiques\"}]},{\"@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\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel et tableaux crois\u00e9s dynamiques : tout savoir ! - ENI Blog","description":"Interviews, webinaires, conseils d'experts... On vous dit tout sur Excel et sur les tableaux crois\u00e9s dynamiques pour gagner en autonomie !","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\/excel-et-tableaux-croises-dynamiques\/","og_locale":"fr_FR","og_type":"article","og_title":"Excel et tableaux crois\u00e9s dynamiques : tout savoir ! - ENI Blog","og_description":"Interviews, webinaires, conseils d'experts... On vous dit tout sur Excel et sur les tableaux crois\u00e9s dynamiques pour gagner en autonomie !","og_url":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/","og_site_name":"Eni Blog","article_modified_time":"2024-04-04T09:27:02+00:00","og_image":[{"width":1920,"height":1282,"url":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/","url":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/","name":"Excel et tableaux crois\u00e9s dynamiques : tout savoir ! - ENI Blog","isPartOf":{"@id":"https:\/\/www.editions-eni.fr\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#primaryimage"},"image":{"@id":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#primaryimage"},"thumbnailUrl":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg","datePublished":"2021-06-09T07:47:20+00:00","dateModified":"2024-04-04T09:27:02+00:00","description":"Interviews, webinaires, conseils d'experts... On vous dit tout sur Excel et sur les tableaux crois\u00e9s dynamiques pour gagner en autonomie !","breadcrumb":{"@id":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#primaryimage","url":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg","contentUrl":"https:\/\/www.editions-eni.fr\/blog\/wp-content\/uploads\/2021\/06\/dossier_thematique_excel.jpg","width":1920,"height":1282,"caption":"Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.editions-eni.fr\/blog\/excel-et-tableaux-croises-dynamiques\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.editions-eni.fr\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel et tableaux crois\u00e9s dynamiques"}]},{"@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"}]}},"_links":{"self":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/pages\/1156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/types\/page"}],"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=1156"}],"version-history":[{"count":56,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/pages\/1156\/revisions"}],"predecessor-version":[{"id":5499,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/pages\/1156\/revisions\/5499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/media\/1437"}],"wp:attachment":[{"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/media?parent=1156"}],"wp:term":[{"taxonomy":"genre","embeddable":true,"href":"https:\/\/www.editions-eni.fr\/blog\/wp-json\/wp\/v2\/genre?post=1156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}