{"id":10419,"date":"2022-11-16T00:58:05","date_gmt":"2022-11-15T23:58:05","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10419"},"modified":"2023-01-19T22:48:52","modified_gmt":"2023-01-19T21:48:52","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-2eme-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10419","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (2\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">La semaine derni\u00e8re, nous avons entam\u00e9 une formation traitant de l&#8217;analyse de donn\u00e9es et de l&#8217;automatisation avec Excel et Access. Le <a href=\"https:\/\/www.auditsi.eu\/?p=10413\">premier volet<\/a> a introduit le sujet de l&#8217;analyse de donn\u00e9es et notamment la conformit\u00e9 des donn\u00e9es. Dans ce deuxi\u00e8me volet, seront abord\u00e9s quelques fonctions fonctions d&#8217;Excel d\u00e9di\u00e9es aux calculs et \u00e0 la mise en forme des donn\u00e9es.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10518\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-2.png\" alt=\"Formation analyse donn\u00e9es volet 2\" width=\"1022\" height=\"785\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-2.png 1022w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-2-300x230.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-2-768x590.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Formation-analyse-donnees-volet-2-730x561.png 730w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/p>\n<p style=\"text-align: justify;\">Au programme cette semaine :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Conversion de donn\u00e9es (CNUM et CTXT) ;<\/li>\n<li style=\"text-align: justify;\">Formatage (TEXTE) et traitement de cha\u00eenes de caract\u00e8res (fonctions GAUCHE, DROITE, STXT, NBCAR, REPT, NOMPROPRE, MAJUSCULE, MINUSCULE, SUPPRESPACE, SUBSTITUE, EPURAGE, CAR, CODE), table ASCII, concat\u00e9nation et imbrication&#8230;<\/li>\n<li>Traitement et calcul de dates (fonctions AUJOURDHUI, DATE, JOUR, MOIS, ANNEE, FOURSEM, FIN.MOIS, DATEDIF<\/li>\n<li>Op\u00e9rateurs arithm\u00e9tiques et r\u00e8gles de priorit\u00e9<\/li>\n<li>Fonctions NB, MIN, MAX, ALEA.ENTRE.BORNES<\/li>\n<li>Arondir un nombre (fonctions ARRONDI, ARRONDI.INF, ARRONDI.SUP, ENT, TRONQUE)<\/li>\n<li>Fonction TRANSPOSE<\/li>\n<li>Calculs conditionnels multicrit\u00e8res (fonctions SOMME.SI.ENS, NB.SI.ENS, MIN.SI.ENS, MAX.SI.ENS)<\/li>\n<li>Calculs en trois dimensions<\/li>\n<li>Nommer des cellules et plages de cellules<\/li>\n<li>Personnaliser ou contourner les messages d&#8217;erreur (fonction SIERREUR)<\/li>\n<li>Caract\u00e8res g\u00e9n\u00e9riques<\/li>\n<li>Rechercher des donn\u00e9es (fonctions RECHERCHEV et RECHERCHEX)<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Le support de formation est t\u00e9l\u00e9chargeable ci-apr\u00e8s.<\/p>\n<p>En attendant le prochain \u00e9pisode, voici quelques id\u00e9es de lecture :<\/p>\n<p>Magazines :<\/p>\n<ul>\n<li>Data Intelligence Magazine n\u00b01 (traitement et exploitation des donn\u00e9es), 11\/2022<\/li>\n<li>Le guide complet Excel, Des bases aux usages avanc\u00e9s (Hors s\u00e9rie)<\/li>\n<\/ul>\n<p>Quelques sites internet :<\/p>\n<ul>\n<li>Cha\u00eene Youtube de <a href=\"https:\/\/www.youtube.com\/channel\/UCfKlAQp4wC_pRpYt7clm70Q\" target=\"_blank\" rel=\"noopener\">Boris NORO<\/a> (the Spreadsheet Man)<\/li>\n<li>Ga\u00ebtan Mourmant (<a href=\"https:\/\/www.xlerateur.com\/\" target=\"_blank\" rel=\"noopener\">XLerateur<\/a>)<\/li>\n<li>Programmation, requ\u00eates, bases de donn\u00e9es, tableurs\u2026 : <a href=\"https:\/\/www.developpez.com\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.developpez.com\/<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Livres :<\/p>\n<ul>\n<li>Business intelligence avec Excel, Des donn\u00e9es brutes \u00e0 l\u2019analyse strat\u00e9gique, Boris NORO, ENI<\/li>\n<li>Power Query et le langage M, Faciliter la pr\u00e9paration, l\u2019enrichissement et le traitement des donn\u00e9es d\u2019analyse, Fr\u00e9d\u00e9ric LE GUEN, Cathy MONIER, ENI<\/li>\n<li>Langage DAX pour PowerPivot et Excel 2016, Guide de r\u00e9f\u00e9rence et mise en pratique, Thierry DOMELAND, ENI<\/li>\n<li>Tableaux de synth\u00e8se et tableaux de bord, Traitez et analysez de gros volumes de donn\u00e9es avec Excel 2016, Pierre RIGOLET, ENI<\/li>\n<li>VBA pour Access, Cr\u00e9ez des applications professionnelles, Claude DUIGOU, ENI<\/li>\n<li>VBA pour Excel, Cr\u00e9ez des applications professionnelles, Claude DUIGOU, ENI<\/li>\n<li>Halte aux fraudes, Pr\u00e9venir et d\u00e9tecter les fraudes en entreprises, Olivier GALLET, DUNOD<\/li>\n<li>EXCEL 2016, ENI<\/li>\n<li>Excel expert, Fonctions, TCD, simulations, visualisation, bases de donn\u00e9es, Nathalie BARBARY, EYROLLES<\/li>\n<\/ul>\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 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%282%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 semaine derni\u00e8re, nous avons entam\u00e9 une formation traitant de l&#8217;analyse de donn\u00e9es et de l&#8217;automatisation avec Excel et Access. Le premier volet a introduit le sujet de l&#8217;analyse de donn\u00e9es et notamment la conformit\u00e9 des donn\u00e9es. Dans ce deuxi\u00e8me volet, seront abord\u00e9s quelques fonctions fonctions d&#8217;Excel d\u00e9di\u00e9es aux calculs et \u00e0 la mise en &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10419\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (2\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%282%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":[1542,166,2053,2054,2055,940,1658,2867,2777,2024,1841,2868,1390,2778,2773,105,2772,1932,1388,2866,2051,2338,1655,1387,2188,1827,2782,1751,1750,2783,2780,1304,1393,2781,528,688,2774,1540,2187,1302,1389,1391,1938,1936,2769,2052],"class_list":["post-10419","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-alea-entre-bornes","tag-analyse-de-donnees","tag-arrondi","tag-arrondi-inf","tag-arrondi-sup","tag-ascii","tag-aujourdhui","tag-boris-noro","tag-car","tag-caractere-generique","tag-chaines-de-caracteres","tag-claude-duigou","tag-cnum","tag-code","tag-concatenation","tag-conversion-de-donnees","tag-ctxt","tag-datedif","tag-droite","tag-eni","tag-ent","tag-epurage","tag-fin-mois","tag-gauche","tag-imbrication","tag-joursem","tag-majuscule","tag-max","tag-min","tag-minuscule","tag-nb","tag-nb-si-ens","tag-nbcar","tag-nompropre","tag-olivier-gallet","tag-recherchev","tag-recherchex","tag-rept","tag-sierreur","tag-somme-si-ens","tag-stxt","tag-substitue","tag-supprespace","tag-texte","tag-transpose","tag-tronque"],"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\/10419","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=10419"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10419\/revisions"}],"predecessor-version":[{"id":10520,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10419\/revisions\/10520"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}