{"id":855,"date":"2025-12-05T17:32:09","date_gmt":"2025-12-05T16:32:09","guid":{"rendered":"https:\/\/quanaup.fr\/?post_type=formation&#038;p=855"},"modified":"2025-12-05T17:32:10","modified_gmt":"2025-12-05T16:32:10","slug":"gagner-en-efficacite-grace-a-excel","status":"publish","type":"formation","link":"https:\/\/quanaup.fr\/en\/formation\/gagner-en-efficacite-grace-a-excel\/","title":{"rendered":"Improve efficiency with Excel"},"content":{"rendered":"<p>Vous g\u00e9rez de nombreuses donn\u00e9es manuellement et vous voudriez&nbsp;<strong>gagner du temps&nbsp;<\/strong>sur certaines t\u00e2ches ?<\/p>\n\n\n\n<p>Gr\u00e2ce \u00e0 cette formation personnalis\u00e9e, vous apprendrez \u00e0 utiliser Excel pour :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>r\u00e9aliser des\u00a0<strong>calculs<\/strong>\u00a0et les visualiser sous forme de\u00a0<strong>graphiques<\/strong><\/li>\n\n\n\n<li><strong>mettre<\/strong>\u00a0<strong>at<\/strong>\u00a0<strong>page<\/strong>\u00a0des rapports efficacement<\/li>\n\n\n\n<li><strong>analyser<\/strong>\u00a0<strong>les<\/strong>\u00a0<strong>donn\u00e9es<\/strong>\u00a0avec des filtres, des fonctions de recherche et des\u00a0<strong>tableaux<\/strong>\u00a0<strong>crois\u00e9s<\/strong>\u00a0<strong>dynamiques<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"gb-text gb-text-dbc039fa\">Goals<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Rappeler les bases d\u2019utilisation d\u2019Excel<\/li>\n\n\n\n<li>R\u00e9aliser des calculs et des graphiques<\/li>\n\n\n\n<li>Mettre en page des rapports qui puissent \u00eatre facilement mis \u00e0 jour<\/li>\n\n\n\n<li>G\u00e9rer et analyser des donn\u00e9es, en lien avec un ERP<\/li>\n\n\n\n<li>\u00catre autonome dans l\u2019utilisation d\u2019Excel<\/li>\n<\/ul>\n\n\n\n<h2 class=\"gb-text gb-text-0559e836\">Course content<\/h2>\n\n\n\n<div class=\"gb-accordion\">\n<div class=\"gb-accordion__item gb-accordion__item-7f817e58\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-052d58b9\" id=\"gb-accordion-toggle-052d58b9\">\n<h3 class=\"gb-text gb-text-edba791c\">1. Les bases d\u2019Excel<\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-0489e1ac\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-38318643\">\n<div class=\"gb-element-baf94960\">\n<ul class=\"wp-block-list\">\n<li>Manipulations standard<\/li>\n\n\n\n<li>R\u00e9aliser des calculs : exemple d\u2019un suivi de tr\u00e9sorerie<\/li>\n\n\n\n<li>Cr\u00e9er et personnaliser un graphique<\/li>\n\n\n\n<li>\u00catre autonome : utiliser l\u2019aide d\u2019Excel et internet<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-f7c7b7d9\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-f8715231\" id=\"gb-accordion-toggle-f8715231\">\n<h3 class=\"gb-text gb-text-05b78fc2\">2. G\u00e9rer des donn\u00e9es (avec les exemples de votre entreprise)<\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-541d0457\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-fc8e37be\">\n<div class=\"gb-element-8f13d984\">\n<ul class=\"wp-block-list\">\n<li>(sur demande) Extraire des donn\u00e9es de votre ERP<\/li>\n\n\n\n<li>Trier, filtrer et nettoyer les donn\u00e9es<\/li>\n\n\n\n<li>Mise en forme conditionnelle et fonctions de recherche<\/li>\n\n\n\n<li>Analyser les donn\u00e9es : calculs conditionnels<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-504a43cb\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-cbc58805\" id=\"gb-accordion-toggle-cbc58805\">\n<h3 class=\"gb-text gb-text-71516cd6\">3. Les tableaux crois\u00e9s dynamiques : un outil performant<\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-c9c63787\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-bb145c12\">\n<div class=\"gb-element-51a50b68\">\n<ul class=\"wp-block-list\">\n<li>Pr\u00e9parer et valider les donn\u00e9es<\/li>\n\n\n\n<li>Analyser les donn\u00e9es : tableaux crois\u00e9s dynamiques<\/li>\n\n\n\n<li>Illustrer l\u2019analyse : graphiques crois\u00e9s dynamiques<\/li>\n\n\n\n<li>Pr\u00e9parer un mod\u00e8le de rapport facile \u00e0 mettre \u00e0 jour<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-03830cca\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-58f75d75\" id=\"gb-accordion-toggle-58f75d75\">\n<h3 class=\"gb-text gb-text-d285ead1\">4. Adapter son utilisation d\u2019Excel aux besoins de l\u2019entreprise<\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-a600c2c6\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewbox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-fda13865\">\n<div class=\"gb-element-aefc631e\">\n<ul class=\"wp-block-list\">\n<li>Optimiser ses fichiers : taille et ergonomie<\/li>\n\n\n\n<li>Utiliser Excel comme base de publipostage<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<p><em>Nous \u00e9tudions vos besoins avec vous au pr\u00e9alable, et nous adaptons le contenu de la formation \u00e0 vos besoins, \u00e0 vos donn\u00e9es et au niveau des stagiaires.<\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>Use Excel to save time on everyday tasks<\/p>","protected":false},"featured_media":856,"template":"","meta":{"_acf_changed":false,"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_analysis_target_kw":"","inline_featured_image":false,"footnotes":""},"categorie-de-formation":[10],"class_list":["post-855","formation","type-formation","status-publish","has-post-thumbnail","hentry","categorie-de-formation-ameliorer-sa-performance"],"acf":[],"_links":{"self":[{"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/formation\/855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/formation"}],"about":[{"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/types\/formation"}],"version-history":[{"count":0,"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/formation\/855\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/media\/856"}],"wp:attachment":[{"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/media?parent=855"}],"wp:term":[{"taxonomy":"categorie-de-formation","embeddable":true,"href":"https:\/\/quanaup.fr\/en\/wp-json\/wp\/v2\/categorie-de-formation?post=855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}