{"id":4661,"date":"2025-09-13T12:46:56","date_gmt":"2025-09-13T08:46:56","guid":{"rendered":"https:\/\/dbformation.tech\/?page_id=4661"},"modified":"2025-09-13T13:10:48","modified_gmt":"2025-09-13T09:10:48","slug":"formation-excel-initiation-2","status":"publish","type":"page","link":"https:\/\/dbformation.tech\/formation-excel-initiation-2\/","title":{"rendered":"FORMATION EXCEL INITIATION"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Programme_de_formation_professionnelle\"><\/span>Programme de formation professionnelle<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%8B_INFORMATIONS_GENERALES\"><\/span>\ud83d\udccb INFORMATIONS G\u00c9N\u00c9RALES<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udccc Intitul\u00e9 de la formation :<\/strong> Excel Initiation &#8211; Ma\u00eetriser les fondamentaux du tableur <strong>\u23f1\ufe0f Dur\u00e9e :<\/strong> 14 heures (2 jours) <strong>\ud83c\udfe2 Modalit\u00e9 :<\/strong> Pr\u00e9sentiel \/ Distanciel <strong>\ud83d\udc65 Public vis\u00e9 :<\/strong> Tout public d\u00e9butant ou utilisateur occasionnel d&rsquo;Excel <strong>\u2705 Pr\u00e9requis :<\/strong> Savoir utiliser un ordinateur et naviguer dans Windows <strong>\ud83d\udc68\u200d\ud83d\udc69\u200d\ud83d\udc66\u200d\ud83d\udc66 Effectif :<\/strong> 1 \u00e0 8 participants maximum <strong>\ud83d\udcb6 Tarif :<\/strong> Sur devis<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%AF_OBJECTIFS_PEDAGOGIQUES\"><\/span>\ud83c\udfaf OBJECTIFS P\u00c9DAGOGIQUES<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c0 l&rsquo;issue de cette formation, le stagiaire sera capable de :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2728 Cr\u00e9er, modifier et mettre en forme des tableaux Excel<\/li>\n\n\n\n<li>\ud83d\udd22 Utiliser les formules et fonctions de base<\/li>\n\n\n\n<li>\ud83d\udcc1 G\u00e9rer et organiser des classeurs<\/li>\n\n\n\n<li>\ud83d\udcc8 Cr\u00e9er des graphiques simples<\/li>\n\n\n\n<li>\ud83d\udda8\ufe0f Mettre en page et imprimer des documents<\/li>\n\n\n\n<li>\ud83d\udd0d Manipuler les donn\u00e9es (tri, filtre)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%92%AA_COMPETENCES_VISEES\"><\/span>\ud83d\udcaa COMP\u00c9TENCES VIS\u00c9ES<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udda5\ufe0f Ma\u00eetriser l&rsquo;environnement de travail Excel<\/li>\n\n\n\n<li>\ud83d\udcd0 Concevoir des tableaux de calcul efficaces<\/li>\n\n\n\n<li>\u26a1 Automatiser des calculs simples<\/li>\n\n\n\n<li>\ud83c\udfa8 Pr\u00e9senter des donn\u00e9es de mani\u00e8re professionnelle<\/li>\n\n\n\n<li>\ud83d\ude80 Optimiser son utilisation quotidienne d&rsquo;Excel<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%9B%A0%EF%B8%8F_MOYENS_PEDAGOGIQUES_ET_TECHNIQUES\"><\/span>\ud83d\udee0\ufe0f MOYENS P\u00c9DAGOGIQUES ET TECHNIQUES<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Moyens p\u00e9dagogiques :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udcc4 Support de cours num\u00e9rique remis \u00e0 chaque participant<\/li>\n\n\n\n<li>\ud83d\udcbc Exercices pratiques et cas concrets<\/li>\n\n\n\n<li>\u2714\ufe0f \u00c9valuation continue des acquis<\/li>\n\n\n\n<li>\ud83c\udfc6 Attestation de formation d\u00e9livr\u00e9e par l&rsquo;organisme certificateur<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcbb Moyens techniques :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udda5\ufe0f Un ordinateur par participant avec Excel install\u00e9 (versions 2016 \u00e0 Microsoft 365)<\/li>\n\n\n\n<li>\ud83d\udcfd\ufe0f Vid\u00e9oprojecteur ou partage d&rsquo;\u00e9cran<\/li>\n\n\n\n<li>\ud83c\udf10 Connexion internet<\/li>\n\n\n\n<li>\ud83d\udcc2 Fichiers d&rsquo;exercices fournis<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udf93 M\u00e9thodes p\u00e9dagogiques :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udc68\u200d\ud83c\udfeb D\u00e9monstration et explication pas \u00e0 pas<\/li>\n\n\n\n<li>\u270d\ufe0f Mise en pratique imm\u00e9diate<\/li>\n\n\n\n<li>\ud83d\udcca Exercices progressifs<\/li>\n\n\n\n<li>\ud83d\udcac Questions\/r\u00e9ponses tout au long de la formation<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%9D_MODALITES_DEVALUATION\"><\/span>\ud83d\udcdd MODALIT\u00c9S D&rsquo;\u00c9VALUATION<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udd0d \u00c9valuation diagnostique en d\u00e9but de formation<\/li>\n\n\n\n<li>\ud83d\udca1 Exercices pratiques tout au long de la formation<\/li>\n\n\n\n<li>\ud83c\udfaf \u00c9valuation sommative en fin de formation<\/li>\n\n\n\n<li>\ud83d\ude0a Questionnaire de satisfaction \u00e0 chaud<\/li>\n\n\n\n<li>\ud83d\udcdc Attestation de fin de formation d\u00e9livr\u00e9e par l&rsquo;organisme certificateur<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%99%BF_ACCESSIBILITE\"><\/span>\u267f ACCESSIBILIT\u00c9<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Formation accessible aux personnes en situation de handicap. Nous consulter pour \u00e9tudier les possibilit\u00e9s d&rsquo;adaptation de la formation.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%8F%B0_DELAI_DACCES\"><\/span>\u23f0 D\u00c9LAI D&rsquo;ACC\u00c8S<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Inscription possible jusqu&rsquo;\u00e0 48h avant le d\u00e9but de la formation sous r\u00e9serve de places disponibles.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%85_PROGRAMME_DETAILLE\"><\/span>\ud83d\udcc5 PROGRAMME D\u00c9TAILL\u00c9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><\/h3>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%98_JOUR_1_%E2%80%93_MATINEE\"><\/span>\ud83d\udcd8 JOUR 1 &#8211; MATIN\u00c9E<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%AF_Sequence_1_Decouverte_dExcel_et_prise_en_main_8h30-10h00\"><\/span>\ud83c\udfaf <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-1\">S\u00e9quence 1 : D\u00e9couverte d&rsquo;Excel et prise en main<\/a> (8h30-10h00)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Ma\u00eetriser l&rsquo;<span class='tooltipsall tooltip_post_id_5149 classtoolTips5149'>Interface<\/span> et les concepts de base d&rsquo;Excel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83c\udf1f Pr\u00e9sentation du tableur et ses utilisations<\/li>\n\n\n\n<li>\ud83d\udda5\ufe0f L&rsquo;<span class='tooltipsall tooltip_post_id_5149 classtoolTips5149'>Interface<\/span> Excel : ruban, barre d&rsquo;outils Acc\u00e8s rapide, barre de formule<\/li>\n\n\n\n<li>\ud83d\udcd1 Les diff\u00e9rents onglets du ruban selon les versions (\u00c9volutions 2016\/2019\/365)<\/li>\n\n\n\n<li>\ud83d\udcca Notion de classeur, feuille, cellule, ligne et colonne<\/li>\n\n\n\n<li>\u2328\ufe0f Se d\u00e9placer dans une feuille (clavier et souris)<\/li>\n\n\n\n<li>\ud83d\udc41\ufe0f Les diff\u00e9rents modes d&rsquo;affichage<\/li>\n\n\n\n<li>\u2699\ufe0f Personnaliser la barre d&rsquo;outils Acc\u00e8s rapide<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Navigation et exploration de l&rsquo;<span class='tooltipsall tooltip_post_id_5149 classtoolTips5149'>Interface<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2615 Pause de 15 minutes<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%81_Sequence_2_Creation_et_gestion_des_classeurs_10h15-11h30\"><\/span>\ud83d\udcc1 <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-2\">S\u00e9quence 2 : Cr\u00e9ation et gestion des classeurs<\/a> (10h15-11h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Savoir cr\u00e9er, enregistrer et organiser ses fichiers Excel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2795 Cr\u00e9er un nouveau classeur<\/li>\n\n\n\n<li>\ud83d\udcbe Enregistrer aux formats .xlsx, .xls (compatibilit\u00e9)<\/li>\n\n\n\n<li>\u2601\ufe0f Enregistrer sur OneDrive (Microsoft 365) ou en local<\/li>\n\n\n\n<li>\ud83d\udcc2 Ouvrir et fermer des classeurs<\/li>\n\n\n\n<li>\ud83d\udcc4 G\u00e9rer les feuilles : ins\u00e9rer, supprimer, renommer, d\u00e9placer, copier<\/li>\n\n\n\n<li>\ud83c\udfa8 Utiliser les mod\u00e8les Excel<\/li>\n\n\n\n<li>\ud83d\udd04 Options d&rsquo;enregistrement automatique (selon versions)<\/li>\n\n\n\n<li>\ud83d\udee1\ufe0f R\u00e9cup\u00e9ration automatique des fichiers<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Cr\u00e9ation et organisation d&rsquo;un classeur multi-feuilles<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8C%9E_JOUR_1_%E2%80%93_APRES-MIDI\"><\/span>\ud83c\udf1e JOUR 1 &#8211; APR\u00c8S-MIDI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%9C%8D%EF%B8%8F_Sequence_3_Saisie_et_modification_des_donnees_13h00-14h30\"><\/span>\u270d\ufe0f <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-3\">S\u00e9quence 3 : Saisie et modification des donn\u00e9es<\/a> (13h00-14h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Ma\u00eetriser la saisie et la modification efficace des donn\u00e9es<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udcdd Types de donn\u00e9es : texte, nombres<\/li>\n\n\n\n<li>\u2705 Saisie et validation de donn\u00e9es<\/li>\n\n\n\n<li>\u270f\ufe0f Modification et suppression du contenu des cellules<\/li>\n\n\n\n<li>\ud83d\udd04 Utilisation de la poign\u00e9e de recopie<\/li>\n\n\n\n<li>\ud83d\udcc8 S\u00e9ries automatiques et personnalis\u00e9es<\/li>\n\n\n\n<li>\ud83d\udccb Copier, couper, coller (options de collage sp\u00e9cial)<\/li>\n\n\n\n<li>\u21a9\ufe0f Annuler et r\u00e9tablir des actions<\/li>\n\n\n\n<li>\ud83d\udd0e Rechercher et remplacer<\/li>\n\n\n\n<li>\u26a1 Fonction de remplissage instantan\u00e9 (Excel 2013+)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Cr\u00e9ation d&rsquo;un planning avec s\u00e9ries automatiques<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2615 Pause de 15 minutes<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%A8_Sequence_4_Mise_en_forme_des_cellules_et_tableaux_14h45-16h30\"><\/span>\ud83c\udfa8 <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-4\">S\u00e9quence 4 : Mise en forme des cellules et tableaux<\/a> (14h45-16h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Cr\u00e9er des tableaux attractifs et lisibles<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udd24 Format des cellules : police, taille, couleur, bordures<\/li>\n\n\n\n<li>\u2194\ufe0f Alignement et orientation du texte<\/li>\n\n\n\n<li>\ud83d\udcaf Format des nombres : milliers, d\u00e9cimales, pourcentage, mon\u00e9taire<\/li>\n\n\n\n<li>\ud83d\udd00 Fusion et fractionnement de cellules<\/li>\n\n\n\n<li>\ud83d\udccf Largeur de colonnes et hauteur de lignes<\/li>\n\n\n\n<li>\ud83c\udfa8 Mise en forme conditionnelle simple<\/li>\n\n\n\n<li>\ud83d\udd8c\ufe0f Styles de cellules et th\u00e8mes<\/li>\n\n\n\n<li>\ud83d\udcca Cr\u00e9ation et utilisation des tableaux (Insertion > Tableau)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Mise en forme compl\u00e8te d&rsquo;un tableau de donn\u00e9es<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%97_JOUR_2_%E2%80%93_MATINEE\"><\/span>\ud83d\udcd7 JOUR 2 &#8211; MATIN\u00c9E<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%A2_Sequence_5_Formules_et_calculs_de_base_8h30-10h00\"><\/span>\ud83d\udd22 <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-5\">S\u00e9quence 5 : Formules et calculs de base<\/a> (8h30-10h00)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Automatiser les calculs simples<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83c\udfd7\ufe0f Structure d&rsquo;une formule<\/li>\n\n\n\n<li>\u2795\u2796 Op\u00e9rateurs arithm\u00e9tiques (+, -, *, \/, ^)<\/li>\n\n\n\n<li>\ud83d\udccd R\u00e9f\u00e9rences relatives et absolues ($)<\/li>\n\n\n\n<li>\ud83d\udcd1 Calculs entre feuilles<\/li>\n\n\n\n<li>\ud83d\udd22 Priorit\u00e9 des op\u00e9rations<\/li>\n\n\n\n<li>\ud83d\udcca Utilisation de la barre de formule<\/li>\n\n\n\n<li>\ud83d\udccb Copie de formules<\/li>\n\n\n\n<li>\ud83d\udc41\ufe0f Affichage des formules (CTRL + \u00ab\u00a0)<\/li>\n\n\n\n<li>\ud83d\udd0d Audit de formules : ant\u00e9c\u00e9dents et d\u00e9pendants<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Cr\u00e9ation d&rsquo;un tableau de calcul avec TVA<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2615 Pause de 15 minutes<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%A7%AE_Sequence_6_Fonctions_essentielles_10h15-11h30\"><\/span>\ud83e\uddee <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-6\">S\u00e9quence 6 : Fonctions essentielles<\/a> (10h15-11h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Utiliser les fonctions Excel les plus courantes<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udcdd Syntaxe des fonctions<\/li>\n\n\n\n<li>\ud83c\udfaf Assistant fonction<\/li>\n\n\n\n<li>\u2795 Fonctions math\u00e9matiques : SOMME, MOYENNE, MIN, MAX, NB, NBVAL<\/li>\n\n\n\n<li>\ud83c\udfaf Fonction SOMME.SI (crit\u00e8re simple)<\/li>\n\n\n\n<li>\ud83d\udd04 Fonction CONCATENER ou CONCAT (2016+), MAJUSCULE, MINUSCULE<\/li>\n\n\n\n<li>\u2753 Fonction logique SI simple<\/li>\n\n\n\n<li>\ud83d\udd17 Imbrication simple de fonctions<\/li>\n\n\n\n<li>\u26a0\ufe0f Gestion des erreurs : #DIV\/0!, #VALEUR!, #NOM?<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Tableau de synth\u00e8se avec statistiques automatiques<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8C%87_JOUR_2_%E2%80%93_APRES-MIDI\"><\/span>\ud83c\udf07 JOUR 2 &#8211; APR\u00c8S-MIDI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%8D_Sequence_7_Gestion_et_analyse_des_donnees_13h00-14h30\"><\/span>\ud83d\udd0d <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-7\">S\u00e9quence 7 : Gestion et analyse des donn\u00e9es<\/a> (13h00-14h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Organiser et analyser efficacement les donn\u00e9es<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udd24 Tri simple et tri multi-crit\u00e8res<\/li>\n\n\n\n<li>\ud83d\udd3d Filtres automatiques<\/li>\n\n\n\n<li>\u2699\ufe0f Filtres personnalis\u00e9s<\/li>\n\n\n\n<li>\ud83d\udd0e Recherche dans les filtres (Excel 2010+)<\/li>\n\n\n\n<li>\ud83d\udccc Figer les volets<\/li>\n\n\n\n<li>\u2702\ufe0f Fractionner l&rsquo;affichage<\/li>\n\n\n\n<li>\ud83d\udcc1 Grouper et dissocier les lignes\/colonnes<\/li>\n\n\n\n<li>\ud83d\udcca Sous-totaux automatiques<\/li>\n\n\n\n<li>\ud83d\udd22 Cr\u00e9ation de sommes cumulatives (cumul progressif)<\/li>\n\n\n\n<li>\ud83d\udeab Suppression des doublons<\/li>\n\n\n\n<li>\u2705 Validation des donn\u00e9es (listes d\u00e9roulantes)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Analyse d&rsquo;une base de donn\u00e9es clients avec calcul de cumuls<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2615 Pause de 15 minutes<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%88_Sequence_8_Graphiques_et_impression_14h45-16h30\"><\/span>\ud83d\udcc8 <a href=\"https:\/\/dbformation.tech\/formations\/excel-initiation\/sequence-8\">S\u00e9quence 8 : Graphiques et impression<\/a> (14h45-16h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83c\udfaf Objectif :<\/strong> Pr\u00e9senter visuellement les donn\u00e9es et pr\u00e9parer l&rsquo;impression<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcda Contenu :<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udcca Cr\u00e9ation de graphiques :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udcca Types de graphiques : histogramme, courbe, secteur, combin\u00e9<\/li>\n\n\n\n<li>\ud83d\udca1 Graphiques recommand\u00e9s (Excel 2013+)<\/li>\n\n\n\n<li>\ud83c\udff7\ufe0f \u00c9l\u00e9ments du graphique : titre, l\u00e9gende, axes, \u00e9tiquettes<\/li>\n\n\n\n<li>\ud83c\udfa8 Mise en forme rapide<\/li>\n\n\n\n<li>\ud83d\udd04 Changement de type de graphique<\/li>\n\n\n\n<li>\u2728 Graphiques sparkline (mini-graphiques dans les cellules)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udda8\ufe0f Mise en page et impression :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udcc4 Mode Mise en page<\/li>\n\n\n\n<li>\ud83d\udd04 Orientation portrait\/paysage<\/li>\n\n\n\n<li>\ud83d\udcd0 Marges et centrage<\/li>\n\n\n\n<li>\ud83d\udcd1 En-t\u00eates et pieds de page<\/li>\n\n\n\n<li>\ud83c\udfaf Zone d&rsquo;impression<\/li>\n\n\n\n<li>\ud83d\udc41\ufe0f Aper\u00e7u avant impression<\/li>\n\n\n\n<li>\ud83d\udd01 R\u00e9p\u00e9tition des titres<\/li>\n\n\n\n<li>\u2699\ufe0f Options d&rsquo;impression : \u00e9chelle, ajustement<\/li>\n\n\n\n<li>\ud83d\udcc4 Export en PDF<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u270f\ufe0f Exercice pratique :<\/strong> Cr\u00e9ation d&rsquo;un tableau de bord avec graphiques et pr\u00e9paration pour impression<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8F%81_BILAN_ET_EVALUATION_FINALE_16h00-16h30\"><\/span>\ud83c\udfc1 BILAN ET \u00c9VALUATION FINALE (16h00-16h30)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2753 Questions\/r\u00e9ponses<\/li>\n\n\n\n<li>\u2705 \u00c9valuation des acquis<\/li>\n\n\n\n<li>\ud83d\udcda Remise des supports<\/li>\n\n\n\n<li>\ud83d\ude0a Questionnaire de satisfaction<\/li>\n\n\n\n<li>\ud83c\udfc6 Attestation d\u00e9livr\u00e9e par l&rsquo;organisme de formation<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%9E_SUIVI_POST-FORMATION\"><\/span>\ud83d\udcde SUIVI POST-FORMATION<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udce7 Support par email pendant 30 jours<\/li>\n\n\n\n<li>\ud83c\udf10 Acc\u00e8s aux ressources p\u00e9dagogiques en ligne<\/li>\n\n\n\n<li>\ud83c\udf93 Possibilit\u00e9 de formation compl\u00e9mentaire niveau Perfectionnement<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%AE_CONTACT_ET_INSCRIPTION\"><\/span>\ud83d\udcee CONTACT ET INSCRIPTION<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>David BILLAUD<\/strong> &#8211; Formateur ind\u00e9pendant<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udce7 Email : <span \n                data-original-string='\/JRLgmMNMffF8j9u6GhrIw==a9aS4om3Xqt8XgaCW3GTyi\/V+yodMQ+Ay3kxfn+RhJ5sBs='\n                class='apbct-email-encoder'\n                title='This contact has been encoded by Anti-Spam by CleanTalk. Click to decode. To finish the decoding make sure that JavaScript is enabled in your browser.'>bi<span class=\"apbct-blur\">***********<\/span>@<span class=\"apbct-blur\">**<\/span>.me<\/span><\/li>\n\n\n\n<li>\ud83c\udf10 Site web : <a href=\"https:\/\/dbformation.tech\/\">https:\/\/dbformation.tech<\/a><\/li>\n\n\n\n<li>\ud83d\udcda Wiki formation : <a href=\"https:\/\/wiki.dbformation.tech\/\">https:\/\/wiki.dbformation.tech<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%8D_INFORMATIONS_COMPLEMENTAIRES\"><\/span>\ud83d\udccd INFORMATIONS COMPL\u00c9MENTAIRES<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83c\udfe2 Formateur intervenant pour des organismes certifi\u00e9s QUALIOPI<\/li>\n\n\n\n<li>\ud83d\udcdc Les attestations de formation sont d\u00e9livr\u00e9es par l&rsquo;organisme certificateur<\/li>\n\n\n\n<li>\ud83d\udcca Supports de cours disponibles sur <a href=\"https:\/\/wiki.dbformation.tech\/\">le wiki<\/a><\/li>\n\n\n\n<li>\ud83d\udcbc Formations personnalisables selon vos besoins sp\u00e9cifiques<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\ud83d\udcc5 Programme mis \u00e0 jour le [Date] &#8211; Formation conforme aux exigences QUALIOPI<\/em> <em>\ud83d\udc68\u200d\ud83c\udfeb David BILLAUD &#8211; Formateur bureautique sp\u00e9cialis\u00e9 Excel<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Programme de formation professionnelle \ud83d\udccb INFORMATIONS G\u00c9N\u00c9RALES \ud83d\udccc Intitul\u00e9 de la formation : Excel Initiation &#8211; Ma\u00eetriser les fondamentaux du tableur \u23f1\ufe0f Dur\u00e9e : 14 heures (2 jours) \ud83c\udfe2 Modalit\u00e9 : Pr\u00e9sentiel \/ Distanciel \ud83d\udc65 Public vis\u00e9 : Tout public d\u00e9butant ou utilisateur occasionnel d&rsquo;Excel \u2705 Pr\u00e9requis : Savoir utiliser un ordinateur et naviguer dans &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/dbformation.tech\/formation-excel-initiation-2\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;FORMATION EXCEL INITIATION&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","footnotes":""},"class_list":["post-4661","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/pages\/4661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/comments?post=4661"}],"version-history":[{"count":5,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/pages\/4661\/revisions"}],"predecessor-version":[{"id":4669,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/pages\/4661\/revisions\/4669"}],"wp:attachment":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/media?parent=4661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}