{"id":554,"date":"2021-11-12T08:59:19","date_gmt":"2021-11-12T07:59:19","guid":{"rendered":"http:\/\/declick.be\/?page_id=554"},"modified":"2025-12-08T11:03:11","modified_gmt":"2025-12-08T10:03:11","slug":"excel-avance","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/excel-avance\/","title":{"rendered":"Excel avanc\u00e9"},"content":{"rendered":"\n<p>Les fichiers utilis\u00e9s lors de ce cours sont les suivants&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/11\/1-Revision-Introduction.xlsx\">1-Revision-Introduction.xlsx<\/a> : r\u00e9vision des notions de bases, \u00e9valuation du niveau des participants et introduction \u00e0 certains points de mati\u00e8re revus en cours de formation&nbsp;:<ul><li>Fonctions simples et \u00ab&nbsp;avanc\u00e9es&nbsp;\u00bb<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>Cellules nomm\u00e9es<\/li>\n\n\n\n<li>R\u00e9f\u00e9rences de cellule<\/li>\n\n\n\n<li>Cr\u00e9ation de graphiques<\/li>\n\n\n\n<li>Filtres automatiques et filtres avanc\u00e9s<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/12\/2-Recettes-Depenses.xlsm\">2-Recettes-Depenses.xlsm<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/12\/2-Recettes-Depenses_Corrige-1.xlsm\">2-Recettes-Depenses_Corrige.xlsm<\/a>&nbsp;: r\u00e9alisation d\u2019une application avec Excel qui met en \u00e9vidence les notions suivantes&nbsp;:\n<ul class=\"wp-block-list\">\n<li>\u00c9tude et utilisation de fonctions avanc\u00e9es<\/li>\n\n\n\n<li>Liaisons<\/li>\n\n\n\n<li>Gestion des zones nomm\u00e9es<\/li>\n\n\n\n<li>Filtres avanc\u00e9s<\/li>\n\n\n\n<li>Cr\u00e9ation et utilisation des macros<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/3-Employes.xls\">3-Employes.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/3-Employes_Solution.xls\">3-Employes_Solution.xls<\/a>&nbsp;: \u00e9tudes de fonctions ou fonctionnalit\u00e9s avanc\u00e9es d\u2019Excel&nbsp;:\n<ul class=\"wp-block-list\">\n<li>Fonctions avanc\u00e9es&nbsp;: SI, ET, OU, RECHERCHEV, calculs sur les dates, \u2026<\/li>\n\n\n\n<li>Tris, filtres<\/li>\n\n\n\n<li>Tableaux crois\u00e9s dynamiques, graphiques crois\u00e9s dynamiques<\/li>\n\n\n\n<li>Les sous-totaux<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/4-ExerciceSup.xls\">4-ExerciceSup.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/4-ExerciceSup2.xls\">4-ExerciceSup2.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/4-ExerciceSup3.xls\">4-ExerciceSup3.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/4-ExerciceSup4.xlsx\">4-ExerciceSup4.xlsx<\/a>&nbsp;: diff\u00e9rents exercices de mise en application des notions avanc\u00e9es d\u2019Excel<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/06\/5-ExerciceSup5-ListerOnglets-1.xlsm\">5-ExerciceSup1-ListerOnglets.xlsm<\/a> et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2024\/06\/5-ExerciceSup6-RemplirListeParFormulaire-1.xlsm\">5-ExerciceSup2-RemplirListeParFormulaire.xlsm<\/a> : 2 petits nouveaux publi\u00e9s en 2024<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/01\/RechercheX.xlsm\">6-ExerciceSup-RechercheX<\/a> : Ajout\u00e9 en 2025, 2 cas de RechercheX par valeur proche (le terme n&rsquo;est plus utilis\u00e9 pour la RechercheX mais c&rsquo;est bien de cela qu&rsquo;il s&rsquo;agit!) et 3 mises en forme conditionnelles particuli\u00e8res<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Les fichiers utilis\u00e9s lors de ce cours sont les suivants&nbsp;:<\/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-554","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/comments?post=554"}],"version-history":[{"count":23,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/554\/revisions"}],"predecessor-version":[{"id":2091,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/554\/revisions\/2091"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}