{"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 class=\"wp-block-paragraph\">You handle a lot of data manually and would like to&nbsp;<strong>save time&nbsp;<\/strong>on certain tasks?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks to this customized training, you will learn to use Excel to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>perform\u00a0<strong>calculations<\/strong>\u00a0and visualize them as\u00a0<strong>charts<\/strong><\/li>\n\n\n\n<li><strong>lay<\/strong>\u00a0<strong>at<\/strong>\u00a0<strong>out<\/strong>\u00a0reports efficiently<\/li>\n\n\n\n<li><strong>analyze<\/strong>\u00a0<strong>the<\/strong>\u00a0<strong>data<\/strong>\u00a0with filters, lookup functions and\u00a0<strong>dynamic<\/strong>\u00a0<strong>pivot<\/strong>\u00a0<strong>tables<\/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>Review the basics of using Excel<\/li>\n\n\n\n<li>Perform calculations and create charts<\/li>\n\n\n\n<li>Lay out reports that can easily be updated<\/li>\n\n\n\n<li>Manage and analyze data, in connection with an ERP<\/li>\n\n\n\n<li>Be autonomous in using Excel<\/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. Excel basics<\/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>Standard operations<\/li>\n\n\n\n<li>Performing calculations: example of cash-flow tracking<\/li>\n\n\n\n<li>Create and customize a chart<\/li>\n\n\n\n<li>Be autonomous: use Excel help and the 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. Managing data (with examples from your company)<\/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>(on request) Extract data from your ERP<\/li>\n\n\n\n<li>Sort, filter and clean data<\/li>\n\n\n\n<li>Conditional formatting and lookup functions<\/li>\n\n\n\n<li>Analyze data: conditional calculations<\/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. Pivot tables: a powerful tool<\/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>Prepare and validate data<\/li>\n\n\n\n<li>Analyze data: pivot tables<\/li>\n\n\n\n<li>Illustrate the analysis: pivot charts<\/li>\n\n\n\n<li>Prepare a report template that is easy to update<\/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. Adapt your use of Excel to the company\u2019s needs<\/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>Optimize your files: size and ergonomics<\/li>\n\n\n\n<li>Use Excel as a mail merge source<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><em>We study your needs with you beforehand, and adapt the content of the training to your needs, your data and the level of the participants.<\/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,"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}]}}