{"id":10572,"date":"2022-11-25T02:13:50","date_gmt":"2022-11-25T01:13:50","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10572"},"modified":"2022-11-25T19:42:54","modified_gmt":"2022-11-25T18:42:54","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-3eme-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10572","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (3\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">Cette semaine encore, le programme de la formation sur l&#8217;analyse de donn\u00e9es et l&#8217;automatisation est charg\u00e9. Pour m\u00e9moire, le <a href=\"https:\/\/www.auditsi.eu\/?p=10413\">premier volet<\/a> a introduit le sujet de l\u2019analyse de donn\u00e9es et notamment la conformit\u00e9 des donn\u00e9es, le <a href=\"https:\/\/www.auditsi.eu\/?p=10419\">deuxi\u00e8me volet<\/a> a quant \u00e0 lui abord\u00e9 quelques fonctions fonctions d\u2019Excel d\u00e9di\u00e9es aux calculs et \u00e0 la mise en forme des donn\u00e9es. Le troisi\u00e8me volet cl\u00f4t le th\u00e8me des fonctions de calcul et de la mise en forme des donn\u00e9es.<\/p>\n<p style=\"text-align: justify;\">L&#8217;analyse de donn\u00e9es sous Excel ne devrait plus avoir de secret pour vous&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10573\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-3.png\" alt=\"Formation analyse donn\u00e9es volet 3\" width=\"1212\" height=\"888\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-3.png 1212w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-3-300x220.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-3-1024x750.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-3-768x563.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-3-730x535.png 730w\" sizes=\"auto, (max-width: 1212px) 100vw, 1212px\" \/><\/p>\n<p style=\"text-align: justify;\">L&#8217;analyse de donn\u00e9es passe entre autres choses par la recherche des erreurs (voire des fraudes). En la mati\u00e8re, Excel peut se r\u00e9v\u00e9ler particuli\u00e8rement redoutable pour tromper ses utilisateurs&#8230; Il est donc n\u00e9cessaire de conna\u00eetre les chausse-trappes pour essayer de ma\u00eetriser ce risque.<\/p>\n<p style=\"text-align: justify;\">Exemple : 15 x 1000 \u20ac = 19 000 \u20ac&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10576\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Formats-personnalises.png\" alt=\"Volet 3 - Formats personnalis\u00e9s\" width=\"494\" height=\"234\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Formats-personnalises.png 494w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Formats-personnalises-300x142.png 300w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/p>\n<p style=\"text-align: justify;\">Excel dispose \u00e9galement d&#8217;outils pour mettre en lumi\u00e8re des informations discordantes, par exemple des doublons :<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10574\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Detecton-doublons.png\" alt=\"Volet 3 - D\u00e9tecton doublons\" width=\"541\" height=\"319\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Detecton-doublons.png 541w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Detecton-doublons-300x177.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/p>\n<p style=\"text-align: justify;\">Au programme cette semaine :<\/p>\n<ul>\n<li>Alg\u00e8bre de Boole (ou arithm\u00e9tique bool\u00e9enne)<\/li>\n<li>Recherche multicrit\u00e8res avec RECHERCHEX<\/li>\n<li>Nouvelles fonctions Excel 2021 : FILTRE et TRIER<\/li>\n<li>Changer la couleur des onglets d\u2019un classeur<\/li>\n<li>Modifier l\u2019affichage des feuilles de calcul<\/li>\n<li>Figer les volets<\/li>\n<li>Prot\u00e9ger les formules de calcul<\/li>\n<li>Fiabiliser la saisie des donn\u00e9es<\/li>\n<li>Cr\u00e9er des liens hypertexte<\/li>\n<li>Organiser les donn\u00e9es avec le mode Plan<\/li>\n<li>Ins\u00e9rer des sous-totaux dans une liste de donn\u00e9es<\/li>\n<li>Filtres, tris et sous-totaux<\/li>\n<li>Le mode tableau<\/li>\n<li>Personnaliser l\u2019affichage de ses donn\u00e9es<\/li>\n<li>Mettre en lumi\u00e8re ses donn\u00e9es<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10577\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Liens-dynamiques.png\" alt=\"Volet 3 - Liens dynamiques\" width=\"784\" height=\"166\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Liens-dynamiques.png 784w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Liens-dynamiques-300x64.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Liens-dynamiques-768x163.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Volet-3-Liens-dynamiques-730x155.png 730w\" sizes=\"auto, (max-width: 784px) 100vw, 784px\" \/><\/p>\n<p style=\"text-align: justify;\">Le support de formation est t\u00e9l\u00e9chargeable ci-apr\u00e8s. Bonne lecture.<\/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 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%283%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>Cette semaine encore, le programme de la formation sur l&#8217;analyse de donn\u00e9es et l&#8217;automatisation est charg\u00e9. Pour m\u00e9moire, le premier volet a introduit le sujet de l\u2019analyse de donn\u00e9es et notamment la conformit\u00e9 des donn\u00e9es, le deuxi\u00e8me volet a quant \u00e0 lui abord\u00e9 quelques fonctions fonctions d\u2019Excel d\u00e9di\u00e9es aux calculs et \u00e0 la mise en &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10572\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (3\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%283%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":[1831,166,2796,2513,439,153,1633,2798,294,1621,1594,2027,1382,1145,1310,1629,2774,291,2703,1137,2801,2775],"class_list":["post-10572","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-algebre-de-boole","tag-analyse-de-donnees","tag-arithmetique-booleenne","tag-conformite","tag-doublons","tag-erreur","tag-excel","tag-filtre","tag-filtres","tag-fraude","tag-lien-hypertexte","tag-lien_hypertexte","tag-mise-en-forme","tag-mode-plan","tag-multicritere","tag-protection-des-donnees","tag-recherchex","tag-sous-total","tag-tableau-de-donnees","tag-tri","tag-trier","tag-volets"],"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\/10572","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=10572"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10572\/revisions"}],"predecessor-version":[{"id":10580,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10572\/revisions\/10580"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}