{"id":5544,"date":"2023-07-24T14:51:37","date_gmt":"2023-07-24T12:51:37","guid":{"rendered":"https:\/\/xylos.dbf-beta.be\/trainings\/excel-fonctions\/"},"modified":"2025-12-08T09:23:11","modified_gmt":"2025-12-08T08:23:11","slug":"excel-fonctions","status":"publish","type":"trainings","link":"https:\/\/xylos.com\/fr\/formations\/microsoft-365\/excel\/excel-fonctions\/","title":{"rendered":"Excel : Fonctions"},"content":{"rendered":"
\n
\n

Description<\/h2>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Tout le monde conna\u00eet la c\u00e9l\u00e8bre fonction \u00ab SOMME \u00bb d\u2019Excel. Mais SOMME ne suffit pas. Pour \u00e9largir vos feuilles de calcul et les complexifier, d\u2019autres fonctions sont n\u00e9cessaires. Vous d\u00e9sirez participer \u00e0 notre cours \u00ab Excel fonctions \u00bb ? Excellente id\u00e9e ! Appropriez-vous les fonctions les plus courantes !<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n

Objectifs<\/h2>\n
\n
\n
\n

Au terme de cette formation :<\/h4>\n
    \n
  • \n
      \n
    • Vous ma\u00eetrisez les fonctions de base d\u2019Excel ;<\/li>\n
    • Vous connaissez de nombreuses fonctions de date et de recherche, fonctions logiques et informatives, fonctions de texte\u2026<\/li>\n
    • Vous savez comment int\u00e9grer une fonction dans une autre (une fonction imbriqu\u00e9e) ;<\/li>\n
    • Vous savez comment analyser et comprendre au mieux une fonction imbriqu\u00e9e.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
      \n

      Groupe cible<\/h2>\n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \n

      Toute personne souhaitant utiliser les fonctions pour travailler plus efficacement avec Excel<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

      \n

      Pr\u00e9requis<\/h2>\n
      \n
      \n
      \n
      \n
      \n
      \n
      \n

      Les participants disposent de bonnes connaissances de base d\u2019Excel.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

      \n

      Contenu<\/h2>\n

      Partie 1 : Formules<\/em><\/strong><\/p>\n

        \n
      • Encoder soi-m\u00eame \u00e0 l\u2019aide de l\u2019assistance propos\u00e9e<\/li>\n
      • Travailler avec l\u2019assistant fonctions<\/li>\n
      • Utiliser la fonction Aide<\/li>\n<\/ul>\n

        Partie 2 : Fonctions de base<\/em><\/strong><\/p>\n

          \n
        • SUMIF(S) \u2013 AVERAGEIF(S) \u2013 COUNTIF(S) \u2013 ROUNDUP \u2013 \u2026<\/li>\n<\/ul>\n

          Partie 3 : Fonctions de la date et de l’heure<\/em><\/strong><\/p>\n

            \n
          • TODAY \u2013 NOW \u2013 MONTH \u2013 YEAR \u2013 DAY \u2013 WEEKDAY<\/li>\n<\/ul>\n

            Partie 4 : Fonctions logiques<\/em><\/strong><\/p>\n

              \n
            • IF \u2013 AND \u2013 OR \u2013 IFERROR<\/li>\n<\/ul>\n

              Partie 5 : Fonctions de recherche<\/em><\/strong><\/p>\n

                \n
              • VLOOKUP \u2013 MATCH \u2013 INDEX<\/li>\n<\/ul>\n

                Partie 6 : Fonctions du texte (facultatif)<\/em><\/strong><\/p>\n

                  \n
                • LEFT \u2013 RIGHT \u2013 MID \u2013 UPPER \u2013 LOWER \u2013 SEARCH \u2013 LEN \u2013 CONCATENATE (&) \u2013 VALUE \u2013 TRIM \u2013 \u2026<\/li>\n<\/ul>\n

                  Partie 7 : Fonctions d’information (facultatif)<\/em><\/strong><\/p>\n

                    \n
                  • ISBLANK \u2013 ISNUMBER \u2013 \u2026<\/li>\n<\/ul>\n

                    Partie 8 : Fonctions Office 365 (facultatif)<\/em><\/strong><\/p>\n

                      \n
                    • XLOOKUP \u2013 FILTER \u2013 UNIQUE \u2013 SORT \u2013 \u2026<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"featured_media":16021,"parent":6795,"menu_order":37,"template":"","tools":[],"type-training":[68,66],"training-software":[65],"class_list":["post-5544","trainings","type-trainings","status-publish","has-post-thumbnail","hentry","type-training-formation-a-distance","type-training-formation-classique","training-software-microsoft-365"],"_links":{"self":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/trainings\/5544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/trainings"}],"about":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/types\/trainings"}],"up":[{"embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/trainings\/6795"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/media\/16021"}],"wp:attachment":[{"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/media?parent=5544"}],"wp:term":[{"taxonomy":"tools","embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/tools?post=5544"},{"taxonomy":"type-training","embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/type-training?post=5544"},{"taxonomy":"training-software","embeddable":true,"href":"https:\/\/xylos.com\/fr\/wp-json\/wp\/v2\/training-software?post=5544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}