S'initier
sur Excel (niveau 1)
Modalités :Intra - Inter - Présentiel
Coût de la formation :Nous contacter
'%20clip-path='url(%23clip-path)'%3e%3cpath%20id='Tracé_170'%20data-name='Tracé%20170'%20d='M19.045,14.028V24.408a1.473,1.473,0,0,1-1.472,1.472H1.828A1.473,1.473,0,0,1,.356,24.408V1.828A1.473,1.473,0,0,1,1.828.356H17.572a1.473,1.473,0,0,1,1.472,1.472v3.78'%20transform='translate(-0.059%20-0.059)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_171'%20data-name='Tracé%20171'%20d='M2.97,2.97V24.131h10.4L17.3,20.2v-3.1'%20transform='translate(-0.491%20-0.491)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_172'%20data-name='Tracé%20172'%20d='M9.039,12.307,7.308,14.14,6.471,13.3'%20transform='translate(-1.07%20-2.034)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_173'%20data-name='Tracé%20173'%20d='M9.039,18.422l-1.73,1.833-.837-.837'%20transform='translate(-1.07%20-3.045)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_174'%20data-name='Tracé%20174'%20d='M9.039,6.059,7.308,7.892l-.837-.837'%20transform='translate(-1.07%20-1.001)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_175'%20data-name='Tracé%20175'%20d='M13.852,15.782,15.9,17.831,27.473,6.258a.528.528,0,0,0,0-.745l-1.3-1.3a.527.527,0,0,0-.745,0Z'%20transform='translate(-2.29%20-0.67)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_176'%20data-name='Tracé%20176'%20d='M15.6,20.153l-.739.739-1.891.774-.465-.465-.466-.466.774-1.891.739-.74'%20transform='translate(-1.99%20-2.993)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cline%20id='Ligne_16'%20data-name='Ligne%2016'%20x1='0.977'%20y2='0.977'%20transform='translate(9.538%2018.208)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_177'%20data-name='Tracé%20177'%20d='M27.989,8.255l.483.483a1.2,1.2,0,0,1,0,1.7l-3.619,3.619'%20transform='translate(-4.109%20-1.364)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cline%20id='Ligne_17'%20data-name='Ligne%2017'%20x1='2.048'%20y1='2.048'%20transform='translate(20.046%206.629)'%20fill='none'%20stroke='%23e05012'%20stroke-miterlimit='10'%20stroke-width='0.712'/%3e%3cpath%20id='Tracé_178'%20data-name='Tracé%20178'%20d='M9.641,25.826,4.433,20.618v5.208Z'%20transform='translate(-0.733%20-3.408)'%20fill='%23e05012'/%3e%3c/g%3e%3c/svg%3e)
'%3e%3cg%20id='Groupe_3880'%20data-name='Groupe%203880'%20transform='translate(-0.417%20-0.417)'%3e%3cpath%20id='Tracé_163'%20data-name='Tracé%20163'%20d='M.417.417,10.569,10.569.72,20.417'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
La formation
Mise à jour: 26/10/2026
Objectifs
- Maîtriser les fonctions de base d’Excel
- Réaliser et mettre en forme un tableau de données et de calculs simples
- Premiers pas dans la création d’un graphique
Durée de la formation
14h
Démarche Pédagogique
- Apports théoriques
- Exercices tout au long de la formation
- Un support de cours est remis à chaque participant
Moyens Pédagogiques
- Equipement de salle de formation
- Un ordinateur par participant avec la suite Office 365
Évaluation
Exercices appliqués et corrigés tout au long de la formation
Programme
EXPLORER L’ENVIRONNEMENT EXCEL
- Rappeler l’environnement Windows (bureau, dossiers, fichiers
- Identifier et utiliser les barres d’outils d’accès rapide
- Naviguer dans le ruban
- Ouvrir, créer et gérer les classeurs et les feuilles
SAISIR ET MODIFIER DES DONNÉES
- Saisir du texte et des valeurs dans les cellules
- Se déplacer dans une feuille et sélectionner des cellules
- Appliquer des fonctions et formules simples (somme, moyenne…)
- Combiner des opérateurs pour effectuer des calculs
- Insérer ou supprimer des lignes et des colonnes
- Copier, déplacer et recopier des données
METTRE EN FORME UN TABLEAU
- Appliquer des mises en forme aux caractères
- Modifier l’alignement, l’orientation et les retraits
- Ajuster les lignes et colonnes
- Appliquer des formats de nombres
- Ajouter des encadrements et des motifs
PRÉPARER LA MISE EN PAGE ET L’IMPRESSION
- Définir les marges, l’orientation et l’échelle d’impression
- Insérer des sauts de pages
- Sélectionner et paramétrer les options d’impression
SAUVEGARDER ET GÉRER UN CLASSEUR
- Enregistrer un nouveau classeur
- Ouvrir et fermer un classeur existant
- Gérer plusieurs classeurs ouverts simultanément
DÉVELOPPER UNE PRÉSENTATION DE DONNÉES
- Maîtriser les fonctions de base d’Excel
- Créer et mettre en forme un tableau de données et de calculs simples
- Créer et personnaliser un graphique simple
Public et Prérequis
Public Concerné
Après un entretien téléphonique, un questionnaire de positionnement est transmis au participant afin d’évaluer son niveau et ses attentes. L’analyse du questionnaire permet d’orienter le participant vers le niveau de formation adapté.
Prérequis
aucun
'%3e%3cg%20id='Groupe_3933'%20data-name='Groupe%203933'%20transform='translate(0%200)'%3e%3cpath%20id='Tracé_170'%20data-name='Tracé%20170'%20d='M41.961,30.793V53.9a3.278,3.278,0,0,1-3.278,3.278H3.634A3.278,3.278,0,0,1,.356,53.9V3.634A3.278,3.278,0,0,1,3.634.356H38.683a3.278,3.278,0,0,1,3.278,3.278V12.05'%20transform='translate(-0.356%20-0.356)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_171'%20data-name='Tracé%20171'%20d='M2.97,2.97V50.079H26.119l8.743-8.743v-6.89'%20transform='translate(1.887%201.887)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_175'%20data-name='Tracé%20175'%20d='M13.852,30.162l4.56,4.56L44.176,8.958a1.175,1.175,0,0,0,0-1.659l-2.9-2.9a1.173,1.173,0,0,0-1.658,0Z'%20transform='translate(11.226%202.819)'%20fill='none'%20stroke='%23fff'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_176'%20data-name='Tracé%20176'%20d='M19.967,22.665l-1.645,1.644-4.211,1.723L13.077,25,12.04,23.96l1.723-4.209L15.407,18.1'%20transform='translate(9.671%2014.876)'%20fill='none'%20stroke='%23fff'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cline%20id='Ligne_16'%20data-name='Ligne%2016'%20x1='2.176'%20y2='2.176'%20transform='translate(20.572%2039.872)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_177'%20data-name='Tracé%20177'%20d='M31.834,8.255,32.91,9.331a2.674,2.674,0,0,1,0,3.781l-8.057,8.057'%20transform='translate(20.667%206.423)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cline%20id='Ligne_17'%20data-name='Ligne%2017'%20x1='4.56'%20y1='4.56'%20transform='translate(43.964%2014.095)'%20fill='none'%20stroke='%23fff'%20stroke-miterlimit='10'%20stroke-width='2'/%3e%3cpath%20id='Tracé_178'%20data-name='Tracé%20178'%20d='M16.027,32.211,4.433,20.618V32.211Z'%20transform='translate(3.143%2017.033)'%20fill='%23eeeded'/%3e%3cline%20id='Ligne_25'%20data-name='Ligne%2025'%20x2='30.247'%20transform='translate(7.328%208.599)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_26'%20data-name='Ligne%2026'%20x2='30.247'%20transform='translate(7.328%2014.305)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_27'%20data-name='Ligne%2027'%20x2='23.969'%20transform='translate(7.328%2020.012)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_28'%20data-name='Ligne%2028'%20x2='17.691'%20transform='translate(7.328%2025.719)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_29'%20data-name='Ligne%2029'%20x2='11.984'%20transform='translate(7.328%2031.426)'%20fill='none'%20stroke='%23fff'%20stroke-linecap='round'%20stroke-width='2'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
'%3e%3cg%20id='Groupe_3931'%20data-name='Groupe%203931'%20transform='translate(0%200)'%3e%3cpath%20id='Tracé_189'%20data-name='Tracé%20189'%20d='M48.525,24.619A23.906,23.906,0,1,0,24.619,48.526,23.906,23.906,0,0,0,48.525,24.619Z'%20transform='translate(-0.713%20-0.713)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_190'%20data-name='Tracé%20190'%20d='M49.983,45.512l8.725,8.724a3.163,3.163,0,0,1-4.473,4.473l-8.724-8.725'%20transform='translate(-3.891%20-3.891)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_191'%20data-name='Tracé%20191'%20d='M37.12,53.6A27.448,27.448,0,0,0,53.594,37.122'%20transform='translate(-3.296%20-3.296)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_23'%20data-name='Ligne%2023'%20y2='10.425'%20transform='translate(30.204%2030.026)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cline%20id='Ligne_24'%20data-name='Ligne%2024'%20y2='10.425'%20transform='translate(17.436%2030.026)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3ccircle%20id='Ellipse_3'%20data-name='Ellipse%203'%20cx='5.927'%20cy='5.927'%20r='5.927'%20transform='translate(17.979%206.09)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_192'%20data-name='Tracé%20192'%20d='M14.3,42.815V27.841a3.855,3.855,0,0,1,3.856-3.855H33.011a3.855,3.855,0,0,1,3.855,3.855V41.368'%20transform='translate(-1.677%20-2.364)'%20fill='none'%20stroke='%23e05012'%20stroke-linecap='round'%20stroke-linejoin='round'%20stroke-width='2'/%3e%3cpath%20id='Tracé_193'%20data-name='Tracé%20193'%20d='M33.213,26.839H18.358a1.2,1.2,0,0,0-1.2,1.2v2.926a8.358,8.358,0,0,1,4.8-1.518h7.658a8.358,8.358,0,0,1,4.8,1.518h0V28.044a1.205,1.205,0,0,0-1.2-1.2'%20transform='translate(-1.879%20-2.567)'%20fill='%23eeeded'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
