{"id":1373,"date":"2012-01-08T16:01:32","date_gmt":"2012-01-08T14:01:32","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=1373"},"modified":"2013-12-19T11:20:18","modified_gmt":"2013-12-19T09:20:18","slug":"odd-it-module-danalyse-de-donnees-pour-excel","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=1373","title":{"rendered":"ODD-IT : module d&#8217;analyse de donn\u00e9es pour EXCEL"},"content":{"rendered":"<p style=\"text-align: justify;\">ACL et IDEA sont les logiciels d\u2019analyse de donn\u00e9es les plus connus du march\u00e9. Toutefois, leur co\u00fbt d\u2019acquisition et le\u00a0temps n\u00e9cessaire \u00e0 leur correcte ma\u00eetrise n\u00e9cessitent, pour rentabiliser cet investissement, un portefeuille clients cons\u00e9quent.<\/p>\n<p style=\"text-align: justify;\">Pour les commissaires aux comptes g\u00e9rant un nombre de mandats plus r\u00e9duit, ODD-IT appara\u00eet comme une alternative : co\u00fbt raisonnable (150 \u20ac HT \/ an), souple et ais\u00e9 \u00e0 prendre en main. Il ne rivalise pas avec ACL ou IDEA mais constitue la bo\u00eete \u00e0 outils indispensable de l\u2019auditeur.<\/p>\n<p style=\"text-align: justify;\">ODD-IT est un compl\u00e9ment \u00e0 d\u2019EXCEL : il se pr\u00e9sente sous la forme d\u2019un ruban d\u2019outils int\u00e9gr\u00e9 de mani\u00e8re totalement transparente \u00e0 EXCEL. De ce fait, la prise en main de cet outil par l\u2019utilisateur d\u00e9j\u00e0 familiaris\u00e9 \u00e0 EXCEL est facilit\u00e9e.<\/p>\n<p style=\"text-align: justify;\">Parmi la multitude de fonctionnalit\u00e9s impl\u00e9ment\u00e9es \u00e0 EXCEL, ODD-IT propose :<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\">la mise en forme de donn\u00e9es pr\u00e9alablement \u00e0 leur analyse,<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">des outils d\u2019analyse de donn\u00e9es, tels : l\u2019\u00e9chantillonnage, l\u2019extraction des doublons, l\u2019identification des ruptures dans une s\u00e9quence de num\u00e9rotation, la loi de Benford, la recherche des inversions base \/ TVA sur des journaux de ventes ou d\u2019achat.<\/div>\n<\/li>\n<\/ul>\n<div id=\"attachment_1380\" style=\"width: 526px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/01\/ODD-IT-Tests-daudit.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1380\" class=\" wp-image-1380\" title=\"ODD-IT - Tests d'audit\" alt=\"\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/01\/ODD-IT-Tests-daudit.jpg\" width=\"516\" height=\"421\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/01\/ODD-IT-Tests-daudit.jpg 516w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/01\/ODD-IT-Tests-daudit-300x244.jpg 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/01\/ODD-IT-Tests-daudit-1x1.jpg 1w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/a><p id=\"caption-attachment-1380\" class=\"wp-caption-text\">Aper\u00e7u des tests d&#8217;audit propos\u00e9s par ODD-IT<\/p><\/div>\n<p style=\"text-align: justify;\">ODD-IT assure tra\u00e7abilit\u00e9 (journalisation) des traitements op\u00e9r\u00e9s sur les donn\u00e9es et permet de r\u00e9aliser ais\u00e9ment les travaux d\u2019analyse de donn\u00e9es en conformit\u00e9 avec les NEP, notamment la NEP 240 \u00ab Prise en consid\u00e9ration de la possibilit\u00e9 de fraudes lors de l&#8217;audit des comptes \u00bb.<\/p>\n<p style=\"text-align: justify;\">Plus d\u2019info sur ODD-IT sur le site de l\u2019\u00e9diteur : <a href=\"http:\/\/www.high-novation.com\/odd-it.php\">http:\/\/www.high-novation.com\/odd-it.php<\/a>.<\/p>\n<p style=\"text-align: justify;\">Formations sur ODD-IT : <a href=\"http:\/\/michelpironformation.com\/\">http:\/\/michelpironformation.com\/<\/a><\/p>\n<p style=\"text-align: justify;\"><a title=\"En savoir plus sur les logiciels d'audit et d'analyse de donn\u00e9es...\" href=\"http:\/\/www.auditsi.eu\/?s=logiciel+d%27audit\">En savoir plus sur les logiciels d&#8217;audit et d&#8217;analyse de donn\u00e9es&#8230;<\/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 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=\"ODD-IT%20%3A%20module%20d%27analyse%20de%20donn%C3%A9es%20pour%20EXCEL\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>ACL et IDEA sont les logiciels d\u2019analyse de donn\u00e9es les plus connus du march\u00e9. Toutefois, leur co\u00fbt d\u2019acquisition et le\u00a0temps n\u00e9cessaire \u00e0 leur correcte ma\u00eetrise n\u00e9cessitent, pour rentabiliser cet investissement, un portefeuille clients cons\u00e9quent. Pour les commissaires aux comptes g\u00e9rant un nombre de mandats plus r\u00e9duit, ODD-IT appara\u00eet comme une alternative : co\u00fbt raisonnable (150 &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=1373\" class=\"more-link\">Continue reading &lsquo;ODD-IT : module d&#8217;analyse de donn\u00e9es pour EXCEL&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=\"ODD-IT%20%3A%20module%20d%27analyse%20de%20donn%C3%A9es%20pour%20EXCEL\";<\/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":[50,7,48,8,641,4,49,21,469],"tags":[166,439,127,1633,642,638,640,66,360,639,220,1623,394,637,26,180,56],"class_list":["post-1373","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-breves","category-excel","category-extractions-de-donnees","category-formation-professionnelle","category-fraude","category-logiciels-daudit","category-nep","category-reglementation-et-demarche-daudit","tag-analyse-de-donnees","tag-doublons","tag-echantillonnage","tag-excel","tag-formation","tag-high-novation","tag-inversion-de-tvaht","tag-journalisation","tag-logiciel-daudit","tag-loi-de-benford","tag-michel-piron","tag-nep","tag-nep-240","tag-odd-it","tag-prevention-de-la-fraude","tag-rupture-de-sequence","tag-tracabilite"],"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\/1373","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=1373"}],"version-history":[{"count":1,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1373\/revisions"}],"predecessor-version":[{"id":4255,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1373\/revisions\/4255"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}