{"id":281,"date":"2023-01-04T08:34:34","date_gmt":"2023-01-04T07:34:34","guid":{"rendered":"https:\/\/arinformatique.com\/?post_type=product&#038;p=281"},"modified":"2026-03-22T09:23:11","modified_gmt":"2026-03-22T08:23:11","slug":"excel-expert","status":"publish","type":"product","link":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/","title":{"rendered":"Excel Expert"},"content":{"rendered":"<p>[et_pb_section fb_built=\u00a0\u00bb1&Prime; _builder_version=\u00a0\u00bb4.19.1&Prime; background_color=\u00a0\u00bb#ffffff\u00a0\u00bb width=\u00a0\u00bb100%\u00a0\u00bb max_width=\u00a0\u00bb100%\u00a0\u00bb custom_padding=\u00a0\u00bb0px||||false|false\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_row _builder_version=\u00a0\u00bb4.16&Prime; background_size=\u00a0\u00bbinitial\u00a0\u00bb background_position=\u00a0\u00bbtop_left\u00a0\u00bb background_repeat=\u00a0\u00bbrepeat\u00a0\u00bb width=\u00a0\u00bb100%\u00a0\u00bb custom_padding=\u00a0\u00bb0px||0px||false|false\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb4_4&Prime; _builder_version=\u00a0\u00bb4.16&Prime; custom_padding=\u00a0\u00bb|||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb custom_padding__hover=\u00a0\u00bb|||\u00a0\u00bb][et_pb_wc_breadcrumb _builder_version=\u00a0\u00bb4.16&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_breadcrumb][et_pb_wc_cart_notice _builder_version=\u00a0\u00bb4.16&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_cart_notice][et_pb_wc_title _builder_version=\u00a0\u00bb4.19.4&Prime; header_font=\u00a0\u00bb|||on|||||\u00a0\u00bb header_font_size=\u00a0\u00bb37px\u00a0\u00bb header_line_height=\u00a0\u00bb2.8em\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_title][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00a0\u00bb1_2,1_4,1_4&Prime; _builder_version=\u00a0\u00bb4.19.1&Prime; background_size=\u00a0\u00bbinitial\u00a0\u00bb background_position=\u00a0\u00bbtop_left\u00a0\u00bb background_repeat=\u00a0\u00bbrepeat\u00a0\u00bb width=\u00a0\u00bb100%\u00a0\u00bb custom_padding=\u00a0\u00bb0px||||false|false\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb1_2&Prime; _builder_version=\u00a0\u00bb4.16&Prime; custom_padding=\u00a0\u00bb|||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb custom_padding__hover=\u00a0\u00bb|||\u00a0\u00bb][et_pb_wc_price _builder_version=\u00a0\u00bb4.19.1&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_price][et_pb_wc_description _builder_version=\u00a0\u00bb4.19.4&Prime; body_font_size=\u00a0\u00bb19px\u00a0\u00bb custom_margin=\u00a0\u00bb80px|-23px|||false|false\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_description][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_4&Prime; _builder_version=\u00a0\u00bb4.16&Prime; custom_padding=\u00a0\u00bb|||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb custom_padding__hover=\u00a0\u00bb|||\u00a0\u00bb][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_4&Prime; _builder_version=\u00a0\u00bb4.16&Prime; custom_padding=\u00a0\u00bb|||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb custom_padding__hover=\u00a0\u00bb|||\u00a0\u00bb][et_pb_wc_images _builder_version=\u00a0\u00bb4.19.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_images][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00a0\u00bb4.19.1&Prime; background_size=\u00a0\u00bbinitial\u00a0\u00bb background_position=\u00a0\u00bbtop_left\u00a0\u00bb background_repeat=\u00a0\u00bbrepeat\u00a0\u00bb width=\u00a0\u00bb100%\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb4_4&Prime; _builder_version=\u00a0\u00bb4.16&Prime; custom_padding=\u00a0\u00bb|||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb custom_padding__hover=\u00a0\u00bb|||\u00a0\u00bb][et_pb_wc_meta product=\u00a0\u00bb225&Prime; show_tags=\u00a0\u00bboff\u00a0\u00bb _builder_version=\u00a0\u00bb4.19.1&Prime; body_font=\u00a0\u00bb|700|||||||\u00a0\u00bb body_text_color=\u00a0\u00bbrgba(255,255,255,0)\u00a0\u00bb link_text_color=\u00a0\u00bb#8e0200&Prime; link_font_size=\u00a0\u00bb13px\u00a0\u00bb link_letter_spacing=\u00a0\u00bb3px\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_meta][et_pb_wc_additional_info show_title=\u00a0\u00bboff\u00a0\u00bb _builder_version=\u00a0\u00bb4.19.1&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb table_background_color=\u00a0\u00bb#f7f7f7&Prime; table_custom_margin=\u00a0\u00bb0px||||false|false\u00a0\u00bb table_row_custom_padding=\u00a0\u00bb13px|48px|13px|48px|true|true\u00a0\u00bb body_font=\u00a0\u00bbPoppins||||||||\u00a0\u00bb body_text_color=\u00a0\u00bb#3d3d3d\u00a0\u00bb attribute_font=\u00a0\u00bb|600|||||||\u00a0\u00bb attribute_text_color=\u00a0\u00bb#3d3d3d\u00a0\u00bb background_color=\u00a0\u00bbRGBA(255,255,255,0)\u00a0\u00bb border_radii_table=\u00a0\u00bbon|30px|30px|30px|30px\u00a0\u00bb border_radii_table_cell=\u00a0\u00bbon||||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_additional_info][et_pb_wc_tabs active_tab_background_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb inactive_tab_background_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb active_tab_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb include_tabs=\u00a0\u00bbdescription|\u00a0\u00bb _builder_version=\u00a0\u00bb4.19.1&Prime; tab_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb tab_font_size=\u00a0\u00bb1px\u00a0\u00bb tab_letter_spacing=\u00a0\u00bb100px\u00a0\u00bb tab_line_height=\u00a0\u00bb1em\u00a0\u00bb background_color=\u00a0\u00bb#f7f7f7&Prime; width=\u00a0\u00bb100%\u00a0\u00bb border_radii=\u00a0\u00bbon|30px|30px|30px|30px\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]\t\t\t\t\t[\/et_pb_wc_tabs][et_pb_wc_add_to_cart _builder_version=\u00a0\u00bb4.16&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_add_to_cart][et_pb_wc_upsells _builder_version=\u00a0\u00bb4.19.1&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_upsells][et_pb_wc_related_products _builder_version=\u00a0\u00bb4.16&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_wc_related_products][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cette formation vous permettra de devenir expert dans l&rsquo;utilisation du logiciel Excel<\/p>\n","protected":false},"featured_media":278,"template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"Programme de la formation :\r\n\r\nProgramme de la formation :\r\nCalculs et fonctionnalit\u00e9s expertes\r\n\u2022Fonction INDEX, EQUIV\r\n\u2022Fonction SOMMEPROD\r\n\u2022Fonction DECALER\r\n\u2022Fonction ADRESSE, INDIRECT\r\n\u2022Fonction FREQUENCE\r\n\u2022Formules matricielles\r\n\u2022Mise en forme conditionnelles avec formules\r\n\u2022Listes d\u00e9roulantes imbriqu\u00e9es\r\nApproche Power Query pour automatiser la\r\npr\u00e9paration, le cumul des listes donn\u00e9es\r\n\u2022Importer, se connecter \u00e0 des donn\u00e9es Excel, Texte (csv,\r\ntxt...)\r\n\u2022Pr\u00e9parer, transformer des donn\u00e9es\r\n\u2022Cumuler les donn\u00e9es de plusieurs tableaux les unes \u00e0\r\nla suite des autres\r\n\r\nTableaux crois\u00e9s dynamiques (TCD) avanc\u00e9s\r\n\u2022Afficher les r\u00e9sultats statistiques en %, en cumul plut\u00f4t\r\nqu'en valeur\r\n\u2022Ajouter des champs et \u00e9l\u00e9ments calcul\u00e9s\r\n\u2022Connecter plusieurs TCD avec des segments de valeurs\r\net chronologiques\r\n\u2022Cr\u00e9er des regroupements par tranches de valeurs,\r\nchronologiques\r\n\u2022Cr\u00e9er, pr\u00e9senter, et manipuler les tableaux et\r\ngraphiques crois\u00e9s dynamiques, segments comme des\r\ntableaux de bord et reportings\r\n\u2022Cr\u00e9er des TCD multi-sources\r\n\r\nT\u00e9l\u00e9chargez la plaquette d'informations pour voir le programme de la formation plus en d\u00e9tail...","_et_gb_content_width":""},"product_brand":[],"product_cat":[28],"product_tag":[],"class_list":{"0":"post-281","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-excel","8":"first","9":"instock","10":"downloadable","11":"virtual","12":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Expert - AR Informatique<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Expert - AR Informatique\" \/>\n<meta property=\"og:description\" content=\"Cette formation vous permettra de devenir expert dans l&#039;utilisation du logiciel Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/\" \/>\n<meta property=\"og:site_name\" content=\"AR Informatique\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-22T08:23:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arinformatique.com\/wp-content\/uploads\/2023\/01\/unnamed-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/\",\"url\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/\",\"name\":\"Excel Expert - AR Informatique\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arinformatique.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arinformatique.com\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/unnamed-1.png\",\"datePublished\":\"2023-01-04T07:34:34+00:00\",\"dateModified\":\"2026-03-22T08:23:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/#primaryimage\",\"url\":\"https:\\\/\\\/arinformatique.com\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/unnamed-1.png\",\"contentUrl\":\"https:\\\/\\\/arinformatique.com\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/unnamed-1.png\",\"width\":512,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/produit\\\/excel-expert\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/arinformatique.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Boutique\",\"item\":\"https:\\\/\\\/arinformatique.com\\\/index.php\\\/boutique\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Expert\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/arinformatique.com\\\/#website\",\"url\":\"https:\\\/\\\/arinformatique.com\\\/\",\"name\":\"AR Informatique\",\"description\":\"Formations,  d\u00e9pannage, conseils et assistance informatique \u00e0 Ostwald.\",\"publisher\":{\"@id\":\"https:\\\/\\\/arinformatique.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/arinformatique.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/arinformatique.com\\\/#organization\",\"name\":\"AR Informatique\",\"url\":\"https:\\\/\\\/arinformatique.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/arinformatique.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/arinformatique.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/logo-AR-Informatique-F-1-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/arinformatique.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/logo-AR-Informatique-F-1-removebg-preview.png\",\"width\":695,\"height\":293,\"caption\":\"AR Informatique\"},\"image\":{\"@id\":\"https:\\\/\\\/arinformatique.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Expert - AR Informatique","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:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/","og_locale":"fr_FR","og_type":"article","og_title":"Excel Expert - AR Informatique","og_description":"Cette formation vous permettra de devenir expert dans l'utilisation du logiciel Excel","og_url":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/","og_site_name":"AR Informatique","article_modified_time":"2026-03-22T08:23:11+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/arinformatique.com\/wp-content\/uploads\/2023\/01\/unnamed-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/","url":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/","name":"Excel Expert - AR Informatique","isPartOf":{"@id":"https:\/\/arinformatique.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/#primaryimage"},"image":{"@id":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/#primaryimage"},"thumbnailUrl":"https:\/\/arinformatique.com\/wp-content\/uploads\/2023\/01\/unnamed-1.png","datePublished":"2023-01-04T07:34:34+00:00","dateModified":"2026-03-22T08:23:11+00:00","breadcrumb":{"@id":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/#primaryimage","url":"https:\/\/arinformatique.com\/wp-content\/uploads\/2023\/01\/unnamed-1.png","contentUrl":"https:\/\/arinformatique.com\/wp-content\/uploads\/2023\/01\/unnamed-1.png","width":512,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/arinformatique.com\/index.php\/produit\/excel-expert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/arinformatique.com\/"},{"@type":"ListItem","position":2,"name":"Boutique","item":"https:\/\/arinformatique.com\/index.php\/boutique\/"},{"@type":"ListItem","position":3,"name":"Excel Expert"}]},{"@type":"WebSite","@id":"https:\/\/arinformatique.com\/#website","url":"https:\/\/arinformatique.com\/","name":"AR Informatique","description":"Formations,  d\u00e9pannage, conseils et assistance informatique \u00e0 Ostwald.","publisher":{"@id":"https:\/\/arinformatique.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/arinformatique.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/arinformatique.com\/#organization","name":"AR Informatique","url":"https:\/\/arinformatique.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/arinformatique.com\/#\/schema\/logo\/image\/","url":"https:\/\/arinformatique.com\/wp-content\/uploads\/2022\/12\/logo-AR-Informatique-F-1-removebg-preview.png","contentUrl":"https:\/\/arinformatique.com\/wp-content\/uploads\/2022\/12\/logo-AR-Informatique-F-1-removebg-preview.png","width":695,"height":293,"caption":"AR Informatique"},"image":{"@id":"https:\/\/arinformatique.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/product\/281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/media\/278"}],"wp:attachment":[{"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/media?parent=281"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/product_brand?post=281"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/product_cat?post=281"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/arinformatique.com\/index.php\/wp-json\/wp\/v2\/product_tag?post=281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}