{"id":10890,"date":"2023-01-08T22:34:05","date_gmt":"2023-01-08T21:34:05","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10890"},"modified":"2023-11-01T19:39:47","modified_gmt":"2023-11-01T18:39:47","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-5eme-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10890","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (5\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel. Ce cinqui\u00e8me volet aborde le <strong>langage VBA<\/strong> et l&#8217;automatisation.<\/p>\n<p style=\"text-align: justify;\">La programmation n&#8217;est pas un sujet r\u00e9serv\u00e9 aux d\u00e9veloppeurs professionnels. Bien au contraire. <strong>Tout un chacun peut s&#8217;approprier ce sujet<\/strong> sans connaissance approfondie des techniques de programmation.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10894\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-5-VBA.png\" alt=\"Volet 5 VBA\" width=\"1172\" height=\"879\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-5-VBA.png 1172w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-5-VBA-300x225.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-5-VBA-1024x768.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-5-VBA-768x576.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-5-VBA-730x548.png 730w\" sizes=\"auto, (max-width: 1172px) 100vw, 1172px\" \/><\/p>\n<p style=\"text-align: justify;\">Au programme :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Automatisation et programmation : quid ?<\/li>\n<li style=\"text-align: justify;\">L\u2019environnement de d\u00e9veloppement int\u00e9gr\u00e9 (EDI)<\/li>\n<li style=\"text-align: justify;\">D\u00e9couvrir la programmation en VBA gr\u00e2ce \u00e0 l\u2019enregistreur de macro d\u2019Excel<\/li>\n<li style=\"text-align: justify;\">Classeurs exemples VBA<\/li>\n<li style=\"text-align: justify;\">Lire et \u00e9crire des donn\u00e9es dans une feuille de calcul<\/li>\n<li style=\"text-align: justify;\">Manipuler des cha\u00eenes de caract\u00e8res (bases)<\/li>\n<li style=\"text-align: justify;\">Variables<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Le prochain volet continuera de d\u00e9velopper le sujet de l\u2019automatisation et du VBA.<\/p>\n<p style=\"text-align: justify;\">Le support de formation ainsi que les classeurs Excel comprenant les macros VBA sont t\u00e9l\u00e9chargeables ci-apr\u00e8s.<\/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; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">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 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%285%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. Ce cinqui\u00e8me volet aborde le langage VBA et l&#8217;automatisation. La programmation n&#8217;est pas un sujet r\u00e9serv\u00e9 aux d\u00e9veloppeurs professionnels. Bien au contraire. Tout un chacun peut s&#8217;approprier ce sujet sans connaissance approfondie des techniques de programmation. Au programme : Automatisation et programmation : &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10890\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (5\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%285%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,215],"tags":[815,1841,2849,254,2850,840,1641],"class_list":["post-10890","post","type-post","status-publish","format-standard","hentry","category-analyse-de-donnees-et-automatisation-avec-excel-et-access","category-formation-professionnelle","category-vba","tag-automatisation","tag-chaines-de-caracteres","tag-classeur-excel","tag-edi","tag-feuille-de-travail","tag-variables","tag-vba"],"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\/10890","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=10890"}],"version-history":[{"count":9,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10890\/revisions"}],"predecessor-version":[{"id":10902,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10890\/revisions\/10902"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}