{"id":10653,"date":"2022-11-30T01:08:06","date_gmt":"2022-11-30T00:08:06","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10653"},"modified":"2022-11-30T13:56:55","modified_gmt":"2022-11-30T12:56:55","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-4eme-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10653","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (4\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">La partie de la formation consacr\u00e9e \u00e0 Excel touche \u00e0 sa fin cette semaine. Apr\u00e8s un premier volet portant introduction du sujet de l\u2019analyse de donn\u00e9es, un deuxi\u00e8me et un troisi\u00e8me volet abordant les fonctions fonctions de calcul d\u2019Excel ainsi que la mise en forme des donn\u00e9es. Ce quatri\u00e8me volet se consacre essentiellement au tableau crois\u00e9 dynamique (TCD).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10655\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-4-TCD.png\" alt=\"Volet 4 - TCD\" width=\"1060\" height=\"787\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-4-TCD.png 1060w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-4-TCD-300x223.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-4-TCD-1024x760.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-4-TCD-768x570.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-4-TCD-730x542.png 730w\" sizes=\"auto, (max-width: 1060px) 100vw, 1060px\" \/><\/p>\n<p style=\"text-align: justify;\">Au programme cette semaine :<\/p>\n<ul>\n<li>Supprimer les doublons<\/li>\n<li>Les tableaux crois\u00e9s dynamiques<\/li>\n<li>Calculs it\u00e9ratifs (r\u00e9solution de syst\u00e8mes d\u2019\u00e9quations \u00e0 x inconnues)<\/li>\n<li>Travailler en r\u00e9seau<\/li>\n<li>Rep\u00e9rer les ant\u00e9c\u00e9dents et les d\u00e9pendants<\/li>\n<li>Ouvrir une nouvelle instance d\u2019Excel<\/li>\n<li>R\u00e9cup\u00e9rer un classeur non enregistr\u00e9<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">La formation consacr\u00e9e \u00e0 Excel est maintenant termin\u00e9e. La semaine prochaine d\u00e9butera la partie d\u00e9di\u00e9e \u00e0 l&#8217;automatisation et au VBA.<\/p>\n<p style=\"text-align: justify;\">Le support de formation est t\u00e9l\u00e9chargeable 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;\">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%284%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>La partie de la formation consacr\u00e9e \u00e0 Excel touche \u00e0 sa fin cette semaine. Apr\u00e8s un premier volet portant introduction du sujet de l\u2019analyse de donn\u00e9es, un deuxi\u00e8me et un troisi\u00e8me volet abordant les fonctions fonctions de calcul d\u2019Excel ainsi que la mise en forme des donn\u00e9es. Ce quatri\u00e8me volet se consacre essentiellement au tableau &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10653\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (4\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%284%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,50,48,641,470],"tags":[166,2813,2260,2814,439,1633,438,68,182],"class_list":["post-10653","post","type-post","status-publish","format-standard","hentry","category-analyse-de-donnees-et-automatisation-avec-excel-et-access","category-audit-de-donnees","category-excel","category-formation-professionnelle","category-techniques-daudit","tag-analyse-de-donnees","tag-antecedent","tag-calcul-iteratif","tag-dependant","tag-doublons","tag-excel","tag-supprimer-les-doublons","tag-tableau-croise-dynamique","tag-tcd"],"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\/10653","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=10653"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10653\/revisions"}],"predecessor-version":[{"id":10661,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10653\/revisions\/10661"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}