{"id":1225,"date":"2022-11-20T13:45:53","date_gmt":"2022-11-20T12:45:53","guid":{"rendered":"http:\/\/declick.be\/?page_id=1225"},"modified":"2023-06-19T09:01:13","modified_gmt":"2023-06-19T07:01:13","slug":"ac-uccle-formules-et-options-complementaires","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/ac-uccle-formules-et-options-complementaires\/","title":{"rendered":"AC Uccle &#8211; Formules et options compl\u00e9mentaires"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Programme de la formation<\/h1>\n\n\n\n<p>Cette journ\u00e9e de formation est consacr\u00e9e \u00e0 l&rsquo;\u00e9tude de formules et fonctions avanc\u00e9es ainsi qu&rsquo;\u00e0 la d\u00e9couverte de techniques de travail compl\u00e9mentaires.<\/p>\n\n\n\n<p>Le programme de la formation est le suivant .Chaque point sera trait\u00e9 par l&rsquo;exemple afin de mettre en lumi\u00e8re les diff\u00e9rentes fonctionnalit\u00e9s complexes de l&rsquo;utilisation d&rsquo;Excel.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cr\u00e9er des formules conditionnelles, conditions multiples, conditions imbriqu\u00e9es<\/li>\n\n\n\n<li>Utiliser des fonctions matricielles<\/li>\n\n\n\n<li>Utiliser des formules de recherche<\/li>\n\n\n\n<li>Effectuer des calculs sur les dates<\/li>\n\n\n\n<li>Utiliser des fonctions financi\u00e8res<\/li>\n\n\n\n<li>Utiliser la valeur cible et le solveur<\/li>\n\n\n\n<li>Utiliser la consolidation<\/li>\n\n\n\n<li>Cr\u00e9er des tables \u00e0 simple et \u00e0 double entr\u00e9e<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\">Exercices du cours<\/h1>\n\n\n\n<p>Tous les fichiers utilis\u00e9s et \u00e9tudi\u00e9s lors de ce cours se trouvent sur le site suivant&nbsp;: <a href=\"http:\/\/www.declick.be\">declick.be<\/a> via \u2018Exercices divers .. AC Uccle \u2013 Formules et options compl\u00e9mentaires<\/p>\n\n\n\n<p>Vous trouverez ci-dessous les fichiers via lesquels les diff\u00e9rents points de mati\u00e8re de ce cours seront \u00e9tudi\u00e9s ainsi que les th\u00e8mes abord\u00e9s\u00a0:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-aa9b2ebd-1fe2-4d41-b7bc-aaac8fe657d4\" href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice02-1.xls\">AC-Uccle-Exercice02-1<\/a><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice02-1.xls\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-aa9b2ebd-1fe2-4d41-b7bc-aaac8fe657d4\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice01.xlsm\">AC-Uccle-Exercice01.xlsm<\/a>\u00a0: \n<ul class=\"wp-block-list\">\n<li><span style=\"color: initial;\">SI, SI.Conditions<\/span><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fonctions de recherche<\/li>\n\n\n\n<li>Introduction au calcul sur les dates<\/li>\n\n\n\n<li>Introduction aux formules matricielles<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice02-1.xls\">AC-Uccle-Exercice02.xls<\/a>\u00a0:\n<ul class=\"wp-block-list\">\n<li>Calculs sur les dates et les heures<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice03.xls\">AC-Uccle-Exercice03.xls<\/a>\u00a0et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice03-Corrige.xls\">AC-Uccle-Exercice03-Corrig\u00e9.xls<\/a> :<ul><li>Fonctions financi\u00e8res<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>Valeur cible<\/li>\n\n\n\n<li>Cr\u00e9ation de tables \u00e0 simple et \u00e0 double entr\u00e9e<\/li>\n\n\n\n<li>Introduction au solveur<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2023\/06\/AC-Uccle-Exercice04.xlsx\">AC-Uccle-Exercice04.xlsx<\/a>\u00a0:\n<ul class=\"wp-block-list\">\n<li>La consolidation des donn\u00e9es<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Programme de la formation Cette journ\u00e9e de formation est consacr\u00e9e \u00e0 l&rsquo;\u00e9tude de formules et fonctions avanc\u00e9es ainsi qu&rsquo;\u00e0 la d\u00e9couverte de techniques de travail compl\u00e9mentaires. Le programme de la formation est le suivant&#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-1225","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/1225","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=1225"}],"version-history":[{"count":23,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/1225\/revisions"}],"predecessor-version":[{"id":1376,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/1225\/revisions\/1376"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=1225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}