{"id":10413,"date":"2022-11-09T02:37:50","date_gmt":"2022-11-09T01:37:50","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10413"},"modified":"2022-11-13T17:18:10","modified_gmt":"2022-11-13T16:18:10","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-1er-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10413","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (1er volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">J\u2019ai pr\u00e9par\u00e9 un support de formation acc\u00e9l\u00e9r\u00e9e \u00e0 l\u2019analyse de donn\u00e9es et \u00e0 l\u2019automatisation de t\u00e2ches pour les deux alternants que j\u2019accueille dans mon service. Cette formation pratique a pour ambition de transmettre une m\u00e9thodologie et d&#8217;assurer la prise en main des outils pour exploiter les donn\u00e9es comptables.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10414\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-1.png\" alt=\"Formation analyse donn\u00e9es volet 1\" width=\"1070\" height=\"807\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-1.png 1070w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-1-300x226.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-1-1024x772.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-1-768x579.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-1-730x551.png 730w\" sizes=\"auto, (max-width: 1070px) 100vw, 1070px\" \/><\/p>\n<p style=\"text-align: justify;\">Au programme&nbsp;:<\/p>\n<ul>\n<li style=\"text-align: justify;\">Introduction \u00e0 l\u2019analyse de donn\u00e9es<\/li>\n<li style=\"text-align: justify;\">Tableur Excel<\/li>\n<li style=\"text-align: justify;\">Automatisation &amp; langage VBA<\/li>\n<li style=\"text-align: justify;\">SGBDR Access<\/li>\n<li style=\"text-align: justify;\">Requ\u00eates SQL<\/li>\n<li style=\"text-align: justify;\">Exploiter les tables PADoCC_Ecritures<\/li>\n<li style=\"text-align: justify;\">Cas pratiques<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Vu l&#8217;ampleur du programme, cette formation est \u00e9tal\u00e9e sur plusieurs semaines.<\/p>\n<p style=\"text-align: justify;\">Au menu cette semaine&nbsp;:<\/p>\n<ul>\n<li style=\"text-align: justify;\">Pourquoi analyser des donn\u00e9es&nbsp;?<\/li>\n<li style=\"text-align: justify;\">Processus ETL (Extract-Transfom-Load)<\/li>\n<li style=\"text-align: justify;\">Conformit\u00e9 des donn\u00e9es<\/li>\n<li style=\"text-align: justify;\">Formalisation des contr\u00f4les<\/li>\n<li style=\"text-align: justify;\">Raccourcis clavier Excel<\/li>\n<li style=\"text-align: justify;\">Int\u00e9grer des donn\u00e9es dans Excel (copier\/coller, importation de donn\u00e9es, connexion aux bases de donn\u00e9es, extraction de donn\u00e9es de fichiers PDF, de photos\u2026)<\/li>\n<\/ul>\n<div id=\"attachment_10495\" style=\"width: 860px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-10495\" class=\"size-full wp-image-10495\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/COLLAGE-SPECIAL-TRANSPOSE.png\" alt=\"Collage Sp\u00e9cial Transpos\u00e9\" width=\"850\" height=\"301\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/COLLAGE-SPECIAL-TRANSPOSE.png 850w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/COLLAGE-SPECIAL-TRANSPOSE-300x106.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/COLLAGE-SPECIAL-TRANSPOSE-768x272.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/COLLAGE-SPECIAL-TRANSPOSE-730x259.png 730w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><p id=\"caption-attachment-10495\" class=\"wp-caption-text\">Collage Sp\u00e9cial Transpos\u00e9<\/p><\/div>\n<p style=\"text-align: justify;\">Je propose aux lecteurs int\u00e9ress\u00e9s de t\u00e9l\u00e9charger le support de cette semaine ci-apr\u00e8s. Bonne lecture.<\/p>\n<p style=\"text-align: justify;\">A suivre&#8230;<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Retrouver <a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">tous les volets de cette s\u00e9rie<\/a> d\u00e9di\u00e9e \u00e0 l&#8217;analyse de donn\u00e9es et \u00e0 l&#8217;automatisation 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;\">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%281er%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>J\u2019ai pr\u00e9par\u00e9 un support de formation acc\u00e9l\u00e9r\u00e9e \u00e0 l\u2019analyse de donn\u00e9es et \u00e0 l\u2019automatisation de t\u00e2ches pour les deux alternants que j\u2019accueille dans mon service. Cette formation pratique a pour ambition de transmettre une m\u00e9thodologie et d&#8217;assurer la prise en main des outils pour exploiter les donn\u00e9es comptables. Au programme&nbsp;: Introduction \u00e0 l\u2019analyse de donn\u00e9es &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10413\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (1er 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%281er%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,48,641,470],"tags":[166,815,2513,1596,2707,307,428,985,2767,2766],"class_list":["post-10413","post","type-post","status-publish","format-standard","hentry","category-analyse-de-donnees-et-automatisation-avec-excel-et-access","category-excel","category-formation-professionnelle","category-techniques-daudit","tag-analyse-de-donnees","tag-automatisation","tag-conformite","tag-copier-coller","tag-etl","tag-fichier-pdf","tag-formalisation","tag-importation-de-donnees","tag-integration-de-donnees","tag-raccourcis-clavier"],"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\/10413","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=10413"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10413\/revisions"}],"predecessor-version":[{"id":10494,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10413\/revisions\/10494"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}