{"id":11880,"date":"2023-12-07T06:52:35","date_gmt":"2023-12-07T05:52:35","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=11880"},"modified":"2023-12-07T22:43:26","modified_gmt":"2023-12-07T21:43:26","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-11eme-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=11880","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (11\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel, les trois suivants au langage VBA et l\u2019automatisation, le huiti\u00e8me volet \u00e0 la d\u00e9couverte du logiciel de gestion de bases de donn\u00e9es Access. Les neuvi\u00e8me et dixi\u00e8me volets couvrent les <strong>requ\u00eates SQL<\/strong>. Ce onzi\u00e8me et dernier volet cl\u00f4ture ce th\u00e8me et ouvre certains sujets dont l&#8217;<strong>analyse de donn\u00e9es comptables<\/strong> (<a href=\"https:\/\/www.auditsi.eu\/?page_id=8535\">projet PADoCC_Ecritures<\/a>).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11881\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/10\/Volet-11-SQL-IIF.png\" alt=\"Volet 11 SQL IIF\" width=\"1046\" height=\"757\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/10\/Volet-11-SQL-IIF.png 1046w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/10\/Volet-11-SQL-IIF-300x217.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/10\/Volet-11-SQL-IIF-1024x741.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/10\/Volet-11-SQL-IIF-768x556.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/10\/Volet-11-SQL-IIF-730x528.png 730w\" sizes=\"auto, (max-width: 1046px) 100vw, 1046px\" \/><\/p>\n<p style=\"text-align: justify;\">Les principaux abord\u00e9s sont :<\/p>\n<ul>\n<li>Cr\u00e9ation de champs calcul\u00e9s : fonctions texte, num\u00e9riques, date, conversion de donn\u00e9es&#8230;<\/li>\n<li>Tests conditionnels (IIf), op\u00e9rateurs de comparaison, bool\u00e9ens&#8230;<\/li>\n<li>Concat\u00e9nation et imbrication<\/li>\n<li>Calculs : op\u00e9rateurs arithm\u00e9tiques, r\u00e8gles de priorit\u00e9&#8230;<\/li>\n<li>Analyse de donn\u00e9es comptables (projet PADoCC_Ecritures) : audit de la TVA, analyse des sch\u00e9mas d&#8217;\u00e9critures, d\u00e9tection des doublons d&#8217;achats, analyse des flux financiers&#8230;<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Le support de formation est t\u00e9l\u00e9chargeable ci-apr\u00e8s.<\/p>\n<p style=\"text-align: justify;\">Cette s\u00e9rie d&#8217;articles est maintenant achev\u00e9e.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Retrouver&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">tous les volets de cette s\u00e9rie<\/a> d\u00e9di\u00e9e \u00e0 l\u2019analyse de donn\u00e9es et \u00e0 l\u2019automatisation avec Excel et Access<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Analyse%20de%20donn%C3%A9es%20et%20automatisation%20avec%20Excel%20et%20Access%20%2811%C3%A8me%20volet%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel, les trois suivants au langage VBA et l\u2019automatisation, le huiti\u00e8me volet \u00e0 la d\u00e9couverte du logiciel de gestion de bases de donn\u00e9es Access. Les neuvi\u00e8me et dixi\u00e8me volets couvrent les requ\u00eates SQL. Ce onzi\u00e8me et dernier volet cl\u00f4ture ce th\u00e8me et ouvre certains &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=11880\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (11\u00e8me volet)&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Analyse%20de%20donn%C3%A9es%20et%20automatisation%20avec%20Excel%20et%20Access%20%2811%C3%A8me%20volet%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[2765,641,282],"tags":[60,1831,166,1981,839,692,2773,105,439,285,2188,1693,1142,2061,1698,2719,57,1005,1643,222],"class_list":["post-11880","post","type-post","status-publish","format-standard","hentry","category-analyse-de-donnees-et-automatisation-avec-excel-et-access","category-formation-professionnelle","category-sql","tag-access","tag-algebre-de-boole","tag-analyse-de-donnees","tag-audit-de-la-tva","tag-calculs","tag-champ-calcule","tag-concatenation","tag-conversion-de-donnees","tag-doublons","tag-iif","tag-imbrication","tag-operateurs-arithmetiques","tag-operateurs-de-comparaison","tag-padocc","tag-priorite","tag-requete","tag-requete-sql","tag-schema-decriture","tag-sql","tag-tests-conditionnels"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/11880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11880"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/11880\/revisions"}],"predecessor-version":[{"id":11883,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/11880\/revisions\/11883"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}