{"id":868,"date":"2025-10-09T11:03:28","date_gmt":"2025-10-09T09:03:28","guid":{"rendered":"https:\/\/mnugier.fr\/?page_id=868"},"modified":"2025-10-09T11:03:38","modified_gmt":"2025-10-09T09:03:38","slug":"%e2%9c%85-competences-microsoft-excel","status":"publish","type":"page","link":"https:\/\/mnugier.fr\/?page_id=868","title":{"rendered":"\u2705 Comp\u00e9tences Microsoft Excel"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udd39 <strong>1. Bases et gestion de feuilles<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Comp\u00e9tence<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>\ud83d\udcca Cr\u00e9ation et gestion des feuilles<\/td><td>Ajout, suppression, renommage, d\u00e9placement de feuilles<\/td><\/tr><tr><td>\ud83d\uddc3\ufe0f Saisie et mise en forme des donn\u00e9es<\/td><td>Formatage des cellules, police, couleur, bordures<\/td><\/tr><tr><td>\ud83e\uddee Utilisation des formules de base<\/td><td>Somme, moyenne, minimum, maximum, etc.<\/td><\/tr><tr><td>\ud83d\udd0d Tri et filtrage<\/td><td>Organisation et recherche de donn\u00e9es sp\u00e9cifiques<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udd39 <strong>2. Fonctions avanc\u00e9es<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Comp\u00e9tence<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>\ud83d\udd22 Fonctions conditionnelles<\/td><td>SI, ET, OU, SI imbriqu\u00e9s<\/td><\/tr><tr><td>\ud83d\udd04 Fonctions de recherche<\/td><td>RECHERCHEV, RECHERCHEH, INDEX, EQUIV<\/td><\/tr><tr><td>\ud83d\udd52 Fonctions date et heure<\/td><td>AUJOURDHUI, MAINTENANT, JOUR, MOIS, ANNEE<\/td><\/tr><tr><td>\ud83e\udde9 Fonctions texte<\/td><td>CONCATENER, GAUCHE, DROITE, STXT<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udd39 <strong>3. Analyse et visualisation<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Comp\u00e9tence<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>\ud83d\udcc8 Cr\u00e9ation de graphiques<\/td><td>Histogrammes, camemberts, courbes, graphiques combin\u00e9s<\/td><\/tr><tr><td>\ud83e\uddee Tableaux crois\u00e9s dynamiques<\/td><td>R\u00e9sum\u00e9 et analyse rapide de grandes donn\u00e9es<\/td><\/tr><tr><td>\ud83d\udcca Mise en forme conditionnelle<\/td><td>Visualisation dynamique selon crit\u00e8res<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udd39 <strong>4. Collaboration et partage<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Comp\u00e9tence<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>\ud83e\udd1d Co-\u00e9dition<\/td><td>Travail collaboratif en temps r\u00e9el<\/td><\/tr><tr><td>\ud83d\udcbe Sauvegarde et export<\/td><td>Formats XLSX, CSV, PDF<\/td><\/tr><tr><td>\ud83d\udce7 Int\u00e9gration avec Outlook<\/td><td>Partage rapide par email<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udd39 <strong>6. Comp\u00e9tences transverses<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Comp\u00e9tence<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>\ud83d\udcda Formation et support<\/td><td>Assistance aux utilisateurs<\/td><\/tr><tr><td>\ud83d\udcdd Cr\u00e9ation de mod\u00e8les<\/td><td>Mod\u00e8les pour tableaux budg\u00e9taires, planning, suivi<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udd39 1. Bases et gestion de feuilles Comp\u00e9tence Description \ud83d\udcca Cr\u00e9ation et gestion des feuilles Ajout, suppression, renommage, d\u00e9placement de feuilles \ud83d\uddc3\ufe0f Saisie et mise en forme des donn\u00e9es Formatage des cellules, police, couleur, bordures \ud83e\uddee Utilisation des formules de base Somme, moyenne, minimum, maximum, etc. \ud83d\udd0d Tri et filtrage Organisation et recherche de donn\u00e9es [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-868","page","type-page","status-publish","hentry","wpbf-post"],"_links":{"self":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages\/868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mnugier.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=868"}],"version-history":[{"count":3,"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages\/868\/revisions"}],"predecessor-version":[{"id":1004,"href":"https:\/\/mnugier.fr\/index.php?rest_route=\/wp\/v2\/pages\/868\/revisions\/1004"}],"wp:attachment":[{"href":"https:\/\/mnugier.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}