{"id":348,"date":"2021-10-12T17:11:41","date_gmt":"2021-10-12T15:11:41","guid":{"rendered":"http:\/\/declick.be\/?page_id=348"},"modified":"2025-02-21T11:02:51","modified_gmt":"2025-02-21T10:02:51","slug":"excel-bases-2","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/excel-bases-2\/","title":{"rendered":"Excel bases"},"content":{"rendered":"\n<p>Les bases d&rsquo;Excel et un peu plus :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En 11 points repris dans 11 fichiers d\u00e9crits et t\u00e9l\u00e9chargeables ci-dessous. Dans chacun de ces fichiers sera abord\u00e9 un th\u00e8me de mati\u00e8re pr\u00e9cis :<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Excel01_Format_Mise-en-page.xls\">Excel01_Format_Mise-en-page<\/a> : principalement, \u00e9tude de la mise en forme et de la mise en page<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Excel02_Copier-Coller.xls\">Excel02_Copier-Coller<\/a> : comme son nom l&rsquo;indique, du copier et du coller &#8230; sp\u00e9cial Excel<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Excel03_Calcul-de-base.xls\">Excel03_Calcul-de-base<\/a> : calcul de bases, fonctions tr\u00e8s basiques mais aussi r\u00e9f\u00e9rences absolues, relatives et mixtes des cellules<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Excel04_Mise-en-forme-conditionnelle.xls\">Excel04_Mise-en-forme-conditionnelle<\/a> : mise en forme selon une ou plusieurs conditions<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Excel05_Fonctions.xls\">Excel05_Fonctions<\/a> et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel05_Fonctions_ExSup.xls\">Excel05_Fonctions_ExSup<\/a> : \u00e9tude des fonctions basiques et moins basiques d&rsquo;Excel<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel06_Dates-Heures.xls\">Excel06_Dates Heures<\/a> : calculs sur les dates et les heures<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel07_Graphiques.xls\">Excel07_Graphiques<\/a> et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel07_Graphiques_ExSup.xlsx\">Excel07_Graphiques_ExSup<\/a> : \u00e9tude des graphiques<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel08_Validation-de-donnees.xls\">Excel08_Validation de donn\u00e9es<\/a> : les validations de donn\u00e9es ou comment cr\u00e9er des r\u00e8gles pour un encodage correct ?<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel09_Tris_Filtres.xls\">Excel09_Tris_Filtres<\/a> : trier et filtrer correctement des listes de donn\u00e9es<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel10_SiEtOu.xls\">Excel10_SiEtOu<\/a> et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel10_SiEtOu_ExSup.xls\">Excel10_SiEtOu_ExSup<\/a> : \u00e9tude plus sp\u00e9cifique de la fonction SI et des fonctions ET et OU<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Excel11_TableauxCroisesDynamiques.xlsx\">Excel11_TableauxCrois\u00e9sDynamiques<\/a> : les incontournables tableaux crois\u00e9s dynamiques (Pivot Table)<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Et des exercices de mise en application des points pr\u00e9c\u00e9dents :<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision1.xlsx\">Revision1.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision1_Solution.xlsx\">Revision1_Solution.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision1_Solution.pdf\">Revision1_Solution.pdf<\/a> : exercices sur les mati\u00e8res vues dans les fichiers 01 et 03<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision2.xlsx\">Revision2.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision2Solution.xlsx\">Revision2Solution.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision2Solution.pdf\">Revision2Solution.pdf<\/a> : r\u00e9vision des fichiers 01 et 03, introduction aux fichiers 04 et 05<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision3.xlsx\">Revision3.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision3Solution.xlsx\">Revision3Solution.xlsx<\/a> : r\u00e9vision des fichiers 01, 03, 04 et 05<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/12\/Revision4.xls\">Revision4.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/12\/Revision4-Question1.pdf\">Revision4-Question1.pdf<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/12\/Revision4-Question6.pdf\">Revision4-Question6.pdf<\/a> : idem pr\u00e9c\u00e9dent + 07<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision5.xlsx\">Revision5.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision5Solution.xlsx\">Revision5Solution.xlsx<\/a> : idem pr\u00e9c\u00e9dent + 06<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/12\/Revision6.xlsx\">Revision6.xlsx<\/a> : r\u00e9vision des fichiers 01, 02, 03 et 07<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision7.xlsx\">Revision7.xlsx<\/a> : r\u00e9vision des fichiers 03, 08 et 11<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision8.xlsx\">Revision8.xlsx<\/a> : r\u00e9vision des fichiers 09<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision9.xlsx\">Revision9.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision9Solution.xlsx\">Revision9Solution.xlsx<\/a> : r\u00e9vision g\u00e9n\u00e9rale<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Revision10.xlsx\">Revision10.xlsx<\/a> : r\u00e9vision g\u00e9n\u00e9rale<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/12\/Revision11.xlsx\">Revision11.xlsx<\/a> : r\u00e9vision des fichiers 03, 04 et 05<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/12\/Revision12.xls\">R\u00e9vision12.xls<\/a> : r\u00e9vision g\u00e9n\u00e9rale<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mais aussi des examens sur lesquels vos pr\u00e9d\u00e9cesseur(e)s (**) se sont cass\u00e9 les dents :<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Test-2013-1.xlsx\">Test 2013-1.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Test-2013-1-Solution.xlsx\">Test 2013-1 Solution.xlsx<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Test-2013-2.xlsx\">Test 2013-2.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/11\/Test-2013-2-Solution.xlsx\">Test 2013-2 Solution.xlsx<\/a><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>(**) Le f\u00e9minin des mots en &lsquo;eur&rsquo; : Belges, Fran\u00e7ais, Qu\u00e9b\u00e9cois et Suisses ont des avis divergents sur la question. Vive la beaut\u00e9 de notre tr\u00e8s ch\u00e8re langue &#8230; faites votre choix mais \u00e7a fait d\u00e9bat<\/p>\n<cite><a href=\"https:\/\/www.question-orthographe.fr\/question\/feminin-de-predecesseur-feminin-de-successeur\/\"><\/a><a href=\"https:\/\/www.question-orthographe.fr\/question\/feminin-de-predecesseur-feminin-de-successeur\/\">F\u00e9minin de pr\u00e9d\u00e9cesseur \/ F\u00e9minin de successeur &#8211; Question Orthographe Voltaire (question-orthographe.fr)<\/a><\/cite><\/blockquote>\n\n\n\n<p>&#8230;<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Les bases d&rsquo;Excel et un peu plus : (**) Le f\u00e9minin des mots en &lsquo;eur&rsquo; : Belges, Fran\u00e7ais, Qu\u00e9b\u00e9cois et Suisses ont des avis divergents sur la question. Vive la beaut\u00e9 de notre tr\u00e8s&#46;&#46;&#46;<\/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-348","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/348","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=348"}],"version-history":[{"count":30,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/348\/revisions"}],"predecessor-version":[{"id":2009,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/348\/revisions\/2009"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}