{"id":7121,"date":"2023-12-12T14:26:45","date_gmt":"2023-12-12T13:26:45","guid":{"rendered":"https:\/\/fcconsultingformation.fr\/?page_id=7121"},"modified":"2025-11-12T11:10:01","modified_gmt":"2025-11-12T10:10:01","slug":"specialisation-excel","status":"publish","type":"page","link":"https:\/\/fcconsultingformation.fr\/?page_id=7121","title":{"rendered":"Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"7121\" class=\"elementor elementor-7121\" data-elementor-post-type=\"page\">\n\t\t\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-ecc72bf e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"ecc72bf\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9c2597e elementor-widget__width-initial e-transform elementor-absolute elementor-widget-mobile__width-initial eael-toggle-center elementor-widget elementor-widget-eael-toggle\" data-id=\"9c2597e\" data-element_type=\"widget\" data-settings=\"{&quot;_transform_translateX_effect&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:180,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:0,&quot;sizes&quot;:[]},&quot;_position&quot;:&quot;absolute&quot;,&quot;toggle_switch_alignment&quot;:&quot;center&quot;,&quot;_transform_translateX_effect_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateX_effect_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"eael-toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        <div class=\"eael-toggle-container\" id=\"eael-toggle-container-9c2597e\">\n            <div class=\"eael-toggle-switch-wrap\">\n                <div class=\"eael-toggle-switch-inner\">\n\n                    <div class=\"eael-primary-toggle-label\">\n                        BUREAUTIQUE                    <\/div>\n                    <div tabindex=\"0\" class=\"eael-toggle-switch-container eael-toggle-switch-round\">\n                        <label class=\"eael-toggle-switch\">\n                            <input type=\"checkbox\">\n                            <span class=\"eael-toggle-slider\"><\/span>\n                        <\/label>\n                    <\/div>\n\n                    <div class=\"eael-secondary-toggle-label\">\n                        PROCHAINES SESSIONS                    <\/div>\n\n                <\/div>\n            <\/div>\n            <div class=\"eael-toggle-content-wrap primary\">\n                <div class=\"eael-toggle-primary-wrap\">\n                    <h6 style=\"text-align: left;\"><img decoding=\"async\" class=\"wp-image-1497 alignleft\" src=\"https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/niveau.png\" alt=\"\" width=\"20\" height=\"20\" srcset=\"https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/niveau.png 36w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/niveau-150x150.png 150w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/niveau-700x700.png 700w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/niveau-300x300.png 300w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/niveau-100x100.png 100w\" sizes=\"(max-width: 20px) 100vw, 20px\" \/><span style=\"font-family: inherit;\">Niveau : D\u00e9butant<\/span><\/h6><h6 style=\"text-align: left;\">\u00a0 \u00a0 \u00a0 \u00a0Pr\u00e9requis : Comprendre et parler le Fran\u00e7ais, savoir utiliser un ordinateur<\/h6><h6 style=\"text-align: left;\"><img decoding=\"async\" class=\" wp-image-1499 alignleft\" src=\"https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/duree.png\" alt=\"\" width=\"29\" height=\"27\" \/><span style=\"font-family: inherit;\">Dur\u00e9e : 2 jours<\/span><\/h6><h6 style=\"text-align: left;\"><img decoding=\"async\" class=\"wp-image-1511 alignleft\" src=\"https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/lieu-1.png\" alt=\"\" width=\"29\" height=\"39\" \/> Lieu : Au centre, dans vos locaux ou en ligne\u00a0<\/h6><h6 style=\"text-align: left;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1514 alignleft\" src=\"https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/prix.png\" alt=\"\" width=\"28\" height=\"28\" srcset=\"https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/prix.png 40w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/prix-150x150.png 150w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/prix-700x700.png 700w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/prix-300x300.png 300w, https:\/\/fcconsultingformation.fr\/wp-content\/uploads\/2023\/11\/prix-100x100.png 100w\" sizes=\"(max-width: 28px) 100vw, 28px\" \/>Prix : 450\u20ac HT soit 540\u20ac TTC<\/h6><h6 style=\"padding-left: 80px; text-align: left;\">\u00a0<\/h6>                <\/div>\n                <div class=\"eael-toggle-secondary-wrap\">\n                    <ul><li style=\"text-align: left;\">15\/01\/2026 &#8211; 16\/01\/2026<\/li><\/ul>                <\/div>\n            <\/div>\n        <\/div>\n        \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-6d8c6d6 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"6d8c6d6\" data-element_type=\"container\">\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-3b70992 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"3b70992\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c1e7504 elementor-widget__width-initial elementor-absolute elementor-widget elementor-widget-text-editor\" data-id=\"c1e7504\" data-element_type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;absolute&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h6><span style=\"color: #000000;\"><strong>Les Statistiques:<\/strong><\/span><\/h6><ul style=\"font-weight: 400; text-align: left;\"><li><span style=\"color: #000000;\">Nombre de stagiaire form\u00e9s: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Nombre d&rsquo;heure de formation dispens\u00e9es: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Note moyenne sur 10 de satisfaction stagiaire: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Note moyenne de satisfaction entreprise: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Note moyenne obtenue sur 20: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Taux d&rsquo;abandon: \u00e0 venir<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-d2ed1ba e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"d2ed1ba\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cb906ad wpr-button-icon-a-position-right elementor-widget__width-initial e-transform elementor-absolute wpr-button-tooltip-a-position-left wpr-button-icon-b-position-right wpr-button-tooltip-b-position-right elementor-widget elementor-widget-wpr-dual-button\" data-id=\"cb906ad\" data-element_type=\"widget\" data-settings=\"{&quot;_transform_translateX_effect&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:34,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:207,&quot;sizes&quot;:[]},&quot;_position&quot;:&quot;absolute&quot;,&quot;_transform_translateX_effect_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateX_effect_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"wpr-dual-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\n\t<div class=\"wpr-dual-button\">\n\t\t\t\t\n\t\t\n\t\t<div class=\"wpr-button-a-wrap elementor-clearfix\">\n\t\t<a class=\"wpr-button-a wpr-button-effect elementor-animation-pulse\" data-text=\"Go 1\" href=\"https:\/\/inscription.fcconsultingformation.fr\/\">\n\t\t\t\n\t\t\t<span class=\"wpr-button-content-a\">\n\t\t\t\t\t\t\t\t\t<span class=\"wpr-button-text-a\">S&#039;inscrire<\/span>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<span class=\"wpr-button-icon-a\"><svg class=\"e-font-icon-svg e-fas-mouse-pointer\" viewBox=\"0 0 320 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M302.189 329.126H196.105l55.831 135.993c3.889 9.428-.555 19.999-9.444 23.999l-49.165 21.427c-9.165 4-19.443-.571-23.332-9.714l-53.053-129.136-86.664 89.138C18.729 472.71 0 463.554 0 447.977V18.299C0 1.899 19.921-6.096 30.277 5.443l284.412 292.542c11.472 11.179 3.007 31.141-12.5 31.141z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t<\/span>\n\t\t<\/a>\n\n\t\t\n\t\t\r\n\t\t<span class=\"wpr-button-middle-badge\">\r\n\t\t\t\t\t\t\t<svg class=\"e-font-icon-svg e-fas-paper-plane\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M476 3.2L12.5 270.6c-18.1 10.4-15.8 35.6 2.2 43.2L121 358.4l287.3-253.2c5.5-4.9 13.3 2.6 8.6 8.3L176 407v80.5c0 23.6 28.5 32.9 42.5 15.8L282 426l124.6 52.2c14.2 6 30.4-2.9 33-18.2l72-432C515 7.8 493.3-6.8 476 3.2z\"><\/path><\/svg>\t\t\t\t\t<\/span>\r\n\r\n\t\t\n\t\t<\/div>\n\n\t\t\n\t\t\t\t\t\n\t\t\n\t\t<div class=\"wpr-button-b-wrap elementor-clearfix\">\n\t\t<a class=\"wpr-button-b wpr-button-effect elementor-animation-pulse\" data-text=\"Go\" href=\"https:\/\/fcconsultingformation.fr\/?page_id=6140\">\n\t\t\t\n\t\t\t<span class=\"wpr-button-content-b\">\n\t\t\t\t\t\t\t\t\t<span class=\"wpr-button-text-b\">Demander un devis<\/span>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/span>\n\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-78cfc52 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"78cfc52\" data-element_type=\"container\">\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-fc0ff6a e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"fc0ff6a\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f012880 elementor-widget elementor-widget-heading\" data-id=\"f012880\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">FORMATION<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a646865 elementor-align-left elementor-absolute e-transform elementor-widget elementor-widget-button\" data-id=\"a646865\" data-element_type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;absolute&quot;,&quot;_transform_translateX_effect&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:-171,&quot;sizes&quot;:[]},&quot;_transform_translateX_effect_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateX_effect_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;_transform_translateY_effect_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/fcconsultingformation.fr?download=8352\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">T\u00e9l\u00e9charger le PDF<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-5bf40f1 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"5bf40f1\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-15a771d elementor-widget__width-initial elementor-widget elementor-widget-heading\" data-id=\"15a771d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">EXCEL<br><br>\nCr\u00e9er des tableaux chiffr\u00e9s - Panorama des fonctions professionnelles essentielles<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-188293e elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"188293e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-size: 18pt; background-color: transparent;\">Ce cours vous initiera aux fonctionnalit\u00e9s essentielles d\u2019Excel. \u00c0 l\u2019issue cette formation, vous saurez construire un tableau simple, l\u2019organiser convenablement, le mettre en page et l\u2019imprimer.<\/span><\/p><p><b><span style=\"font-size: 18.0pt; color: #4472c3;\">Public concern\u00e9<\/span><\/b><\/p><p><span style=\"font-size: 18.0pt;\">Tout public<\/span><\/p><p><b><span style=\"font-size: 18.0pt; color: #4472c3;\">Pr\u00e9requis<\/span><\/b><\/p><ul><li><span style=\"font-size: 18.0pt;\">Savoir utiliser un ordinateur<\/span><\/li><li><span style=\"font-size: 18.0pt;\">Savoir parler et lire le fran\u00e7ais<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #4472c3;\">Objectifs p\u00e9dagogiques<\/span><\/b><\/p><p><span style=\"font-size: 18.0pt;\">\u00c0 l\u2019issue de la formation, le participant sera en mesure de :<\/span><\/p><ul><li><span style=\"font-size: 18.0pt; color: #fec708;\">\u00a0<\/span><span style=\"font-size: 18.0pt;\">Prendre en main l\u2019interface Excel<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #fec708;\">\u00a0<\/span><span style=\"font-size: 18.0pt;\">Concevoir un tableau et effectuer des calculs simples<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #fec708;\">\u00a0<\/span><span style=\"font-size: 18.0pt;\">Mettre en forme un tableau pour le valoriser<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #fec708;\">\u00a0<\/span><span style=\"font-size: 18.0pt;\">Utiliser les filtres et cr\u00e9er des listes d\u00e9roulantes<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #fec708;\">\u00a0<\/span><span style=\"font-size: 18.0pt;\">Param\u00e9trer l\u2019impression et imprimer un tableau<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #fec708;\">\u00a0<\/span><span style=\"font-size: 18.0pt;\">G\u00e9rer les onglets et les feuilles de classeur<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #ec7d31;\">Programme de la formation<\/span><\/b><\/p><p><b><span style=\"font-size: 18.0pt; color: #0078c6;\">Pr\u00e9senter un tableau sous EXCEL:<\/span><\/b><\/p><p><span style=\"font-size: 18.0pt; color: #070707;\">Approfondir les fonctions de base (s\u00e9lections, recopie automatique)<\/span><\/p><p><span style=\"font-size: 18.0pt; color: #070707;\">Cr\u00e9er un tableau avec e<\/span><span style=\"font-size: 18.0pt;\">ffi<\/span><span style=\"font-size: 18.0pt; color: #070707;\">cacit\u00e9 :<\/span><\/p><ul><li><span style=\"font-size: 18.0pt; color: #070707;\">Les s\u00e9lections rapides<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Les formats personnalis\u00e9s<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Les mises en forme conditionnelles<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #0078c6;\">Ins\u00e9rer des fonctions de calcul :<\/span><\/b><\/p><ul><li><span style=\"font-size: 18.0pt; color: #070707;\">L\u2019utilisation des noms<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">La diff\u00e9rence entre valeur absolue et relative<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Les fonctions int\u00e9gr\u00e9es de base<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #0078c6;\">Panorama des fonctions de calcul des plus utilis\u00e9es<\/span><\/b><\/p><ul><li><span style=\"font-size: 18.0pt; color: #070707;\">Les fonctions conditionnelles<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Les fonctions statistiques<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Les fonctions texte<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #0078c6;\">Mettre en page et imprimer sous Excel:<\/span><\/b><\/p><ul><li><span style=\"font-size: 18.0pt; color: #070707;\">D\u00e9<\/span><span style=\"font-size: 18.0pt;\">fi<\/span><span style=\"font-size: 18.0pt; color: #070707;\">nir une zone d\u2019impression<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">G\u00e9rer les sauts de page<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">D\u00e9limiter les marges et les ent\u00eates<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #0078c6;\">G\u00e9rer des listes de donn\u00e9es sur EXCEL et savoir les organiser :<\/span><\/b><\/p><ul><li><span style=\"font-size: 18.0pt; color: #070707;\">Savoir re-traiter des donn\u00e9es<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Trier et <\/span><span style=\"font-size: 18.0pt;\">fi<\/span><span style=\"font-size: 18.0pt; color: #070707;\">ltrer des donn\u00e9es<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Manipuler le format tableau<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #0078c6;\">Initiation \u00e0 la cr\u00e9ation de tableaux crois\u00e9s dynamiques :<\/span><\/b><\/p><ul><li><span style=\"font-size: 18.0pt; color: #070707;\">Se poser les bonnes questions<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">G\u00e9rer les champs<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Regrouper des donn\u00e9es<\/span><\/li><\/ul><p><b><span style=\"font-size: 18.0pt; color: #4472c3;\">Modalit\u00e9s pratiques<\/span><\/b><\/p><p><b><span style=\"font-size: 18.0pt;\">Travaux pratiques<\/span><\/b><\/p><p><span style=\"font-size: 18.0pt;\">Exercices pratiques, d\u00e9monstration, \u00e9change et partage d\u2019exp\u00e9rience. <\/span><\/p><p><b><span style=\"font-size: 18.0pt;\">Moyens p\u00e9dagogiques :<\/span><\/b><\/p><p><span style=\"font-size: 18.0pt;\">Formation d\u00e9livr\u00e9e en pr\u00e9sentiel ou distanciel (classe virtuelle).<\/span><\/p><p><span style=\"font-size: 18.0pt;\">L\u2019action de formation d\u00e9butera par une pr\u00e9sentation du formateur et de chacun des stagiaires afin de permettre<br \/>une adaptation optimale de la formation.<\/span><\/p><p><span style=\"font-size: 18.0pt;\">Le formateur alterne entre m\u00e9thode d\u00e9monstrative, interrogative et active (via des travaux pratiques et\/ou<br \/>des mises en situation).<\/span><\/p><p><span style=\"font-size: 18.0pt;\">Variables suivant les formations, les moyens p\u00e9dagogiques mis en oeuvre sont :<\/span><\/p><p><span style=\"font-size: 18.0pt;\">\u2013 Ordinateurs mis \u00e0 disposition par l\u2019organisme de formation,<\/span><\/p><p><span style=\"font-size: 18.0pt;\">connexion internet libre, tableau blanc ou paperboard,\u00a0<\/span><span style=\"font-size: 18pt; background-color: transparent;\">vid\u00e9oprojecteur ou outils de\u00a0<\/span><span style=\"font-size: 18pt; background-color: transparent;\">visioconf\u00e9rence en cas de formation \u00e0\u00a0<\/span><span style=\"font-size: 18pt; background-color: transparent;\">distance.<\/span><\/p><p><span style=\"font-size: 18.0pt;\">\u2013 Logiciel de formation install\u00e9 sur les postes de travail ou en ligne<\/span><\/p><p><span style=\"font-size: 18.0pt;\">\u2013 Supports de cours et exercices<\/span><\/p><p><span style=\"font-size: 18.0pt;\">En cas de formation sur site externe, le client s\u2019assure et s\u2019engage \u00e9galement \u00e0 avoir toutes les ressources mat\u00e9rielles p\u00e9dagogiques n\u00e9cessaires (\u00e9quipements informatiques\u2026) au bon d\u00e9roulement de l\u2019action de formation vis\u00e9e conform\u00e9ment aux pr\u00e9requis indiqu\u00e9s dans le programme de formation communiqu\u00e9. <\/span><\/p><p><b><span style=\"font-size: 18.0pt;\">Modalit\u00e9s d\u2018\u00e9valuation :<\/span><\/b><\/p><p><span style=\"font-size: 18.0pt;\">De mani\u00e8re bienveillante, vous aurez un suivi tout au long de votre parcours :<\/span><\/p><ul><li><span style=\"color: #070707; font-size: 18pt; background-color: transparent;\">Une \u00e9valuation\u00a0<\/span><span style=\"background-color: transparent; font-size: 18pt; color: #070707;\">diagnostique sera r\u00e9alis\u00e9e par t\u00e9l\u00e9phone lors de <\/span><span style=\"background-color: transparent; font-size: 18pt;\">l\u2019inscription, pour connaitre le niveau et besoins des apprenants.<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Une \u00e9valuation sommative tout au long de la formation <\/span><span style=\"font-size: 18.0pt;\">(r\u00e9alisation d\u2019exercices pratique et qcm avec correction afin de valider la bonne utilisation des logiciels).<\/span><\/li><li><span style=\"font-size: 18.0pt; color: #070707;\">Une \u00e9valuation formative \u00e0 la <\/span><span style=\"font-size: 18.0pt;\">fi<\/span><span style=\"font-size: 18.0pt; color: #070707;\">n de chaque module : exercices pratiques pour valider vos comp\u00e9tences<\/span><span style=\"font-size: 18.0pt;\">.<\/span><\/li><\/ul><p style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size: 18.0pt; font-family: Roboto;\">\u00a0<\/span><\/p><p style=\"text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-66f0558 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"66f0558\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e7b6d6d elementor-widget__width-initial elementor-absolute elementor-widget elementor-widget-text-editor\" data-id=\"e7b6d6d\" data-element_type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;absolute&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h6><span style=\"color: #000000;\"><strong>Les Statistiques:<\/strong><\/span><\/h6><ul style=\"font-weight: 400; text-align: left;\"><li><span style=\"color: #000000;\">Nombre de stagiaire form\u00e9s: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Nombre d&rsquo;heure de formation dispens\u00e9es: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Note moyenne sur 10 de satisfaction stagiaire: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Note moyenne de satisfaction entreprise: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Note moyenne obtenue sur 20: \u00e0 venir<\/span><\/li><li><span style=\"color: #000000;\">Taux d&rsquo;abandon: \u00e0 venir<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>BUREAUTIQUE PROCHAINES SESSIONS Niveau : D\u00e9butant \u00a0 \u00a0 \u00a0 \u00a0Pr\u00e9requis : Comprendre et parler le Fran\u00e7ais, savoir utiliser un ordinateur Dur\u00e9e : 2 jours Lieu : Au centre, dans vos locaux ou en ligne\u00a0 Prix : 450\u20ac HT soit 540\u20ac TTC \u00a0 15\/01\/2026 &#8211; 16\/01\/2026 Les Statistiques: Nombre de stagiaire form\u00e9s: \u00e0 venir Nombre d&rsquo;heure de formation dispens\u00e9es: \u00e0 venir Note moyenne sur 10 de satisfaction stagiaire: \u00e0 venir Note moyenne de satisfaction entreprise: \u00e0 venir Note moyenne obtenue sur 20: \u00e0 venir Taux d&rsquo;abandon: \u00e0 venir S&#039;inscrire Demander un devis FORMATION T\u00e9l\u00e9charger le PDF EXCEL Cr\u00e9er des tableaux chiffr\u00e9s &#8211; Panorama des fonctions professionnelles essentielles Ce cours vous initiera aux fonctionnalit\u00e9s essentielles d\u2019Excel. \u00c0 l\u2019issue cette formation, vous saurez construire un tableau simple, l\u2019organiser convenablement, le mettre en page et l\u2019imprimer. Public concern\u00e9 Tout public Pr\u00e9requis Savoir utiliser un ordinateur Savoir parler et lire le fran\u00e7ais Objectifs p\u00e9dagogiques \u00c0 l\u2019issue de la formation, le participant sera en mesure de : \u00a0Prendre en main l\u2019interface Excel \u00a0Concevoir un tableau et effectuer des calculs simples \u00a0Mettre en forme un tableau pour le valoriser \u00a0Utiliser les filtres et cr\u00e9er des listes d\u00e9roulantes \u00a0Param\u00e9trer l\u2019impression et imprimer un tableau \u00a0G\u00e9rer les onglets et les feuilles de classeur Programme de la formation Pr\u00e9senter un tableau sous EXCEL: Approfondir les fonctions de base (s\u00e9lections, recopie automatique) Cr\u00e9er un tableau avec efficacit\u00e9 : Les s\u00e9lections rapides Les formats personnalis\u00e9s Les mises en forme conditionnelles Ins\u00e9rer des fonctions de calcul : L\u2019utilisation des noms La diff\u00e9rence entre valeur absolue et relative Les fonctions int\u00e9gr\u00e9es de base Panorama des fonctions de calcul des plus utilis\u00e9es Les fonctions conditionnelles Les fonctions statistiques Les fonctions texte Mettre en page et imprimer sous Excel: D\u00e9finir une zone d\u2019impression G\u00e9rer les sauts de page D\u00e9limiter les marges et les ent\u00eates G\u00e9rer des listes de donn\u00e9es sur EXCEL et savoir les organiser : Savoir re-traiter des donn\u00e9es Trier et filtrer des donn\u00e9es Manipuler le format tableau Initiation \u00e0 la cr\u00e9ation de tableaux crois\u00e9s dynamiques : Se poser les bonnes questions G\u00e9rer les champs Regrouper des donn\u00e9es Modalit\u00e9s pratiques Travaux pratiques Exercices pratiques, d\u00e9monstration, \u00e9change et partage d\u2019exp\u00e9rience. Moyens p\u00e9dagogiques : Formation d\u00e9livr\u00e9e en pr\u00e9sentiel ou distanciel (classe virtuelle). L\u2019action de formation d\u00e9butera par une pr\u00e9sentation du formateur et de chacun des stagiaires afin de permettreune adaptation optimale de la formation. Le formateur alterne entre m\u00e9thode d\u00e9monstrative, interrogative et active (via des travaux pratiques et\/oudes mises en situation). Variables suivant les formations, les moyens p\u00e9dagogiques mis en oeuvre sont : \u2013 Ordinateurs mis \u00e0 disposition par l\u2019organisme de formation, connexion internet libre, tableau blanc ou paperboard,\u00a0vid\u00e9oprojecteur ou outils de\u00a0visioconf\u00e9rence en cas de formation \u00e0\u00a0distance. \u2013 Logiciel de formation install\u00e9 sur les postes de travail ou en ligne \u2013 Supports de cours et exercices En cas de formation sur site externe, le client s\u2019assure et s\u2019engage \u00e9galement \u00e0 avoir toutes les ressources mat\u00e9rielles p\u00e9dagogiques n\u00e9cessaires (\u00e9quipements informatiques\u2026) au bon d\u00e9roulement de l\u2019action de formation vis\u00e9e conform\u00e9ment aux pr\u00e9requis indiqu\u00e9s dans le programme de formation communiqu\u00e9. Modalit\u00e9s d\u2018\u00e9valuation : De mani\u00e8re bienveillante, vous aurez un suivi tout au long de votre parcours : Une \u00e9valuation\u00a0diagnostique sera r\u00e9alis\u00e9e par t\u00e9l\u00e9phone lors de l\u2019inscription, pour connaitre le niveau et besoins des apprenants. Une \u00e9valuation sommative tout au long de la formation (r\u00e9alisation d\u2019exercices pratique et qcm avec correction afin de valider la bonne utilisation des logiciels). Une \u00e9valuation formative \u00e0 la fin de chaque module : exercices pratiques pour valider vos comp\u00e9tences. \u00a0 \u00a0 Les Statistiques: Nombre de stagiaire form\u00e9s: \u00e0 venir Nombre d&rsquo;heure de formation dispens\u00e9es: \u00e0 venir Note moyenne sur 10 de satisfaction stagiaire: \u00e0 venir Note moyenne de satisfaction entreprise: \u00e0 venir Note moyenne obtenue sur 20: \u00e0 venir Taux d&rsquo;abandon: \u00e0 venir<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"hide","_kad_post_layout":"fullwidth","_kad_post_sidebar_id":"","_kad_post_content_style":"unboxed","_kad_post_vertical_padding":"hide","_kad_post_feature":"hide","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-7121","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=\/wp\/v2\/pages\/7121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7121"}],"version-history":[{"count":21,"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=\/wp\/v2\/pages\/7121\/revisions"}],"predecessor-version":[{"id":9124,"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=\/wp\/v2\/pages\/7121\/revisions\/9124"}],"wp:attachment":[{"href":"https:\/\/fcconsultingformation.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}