{"id":582,"date":"2011-05-01T18:43:19","date_gmt":"2011-05-01T17:43:19","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=582"},"modified":"2014-05-06T22:13:42","modified_gmt":"2014-05-06T20:13:42","slug":"mettre-en-oeuvre-le-travail-collaboratif-avec-la-fonction-de-partage-reseau-d%e2%80%99excel","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=582","title":{"rendered":"Mettre en \u0153uvre le travail collaboratif avec la fonction de partage r\u00e9seau d\u2019EXCEL"},"content":{"rendered":"<p style=\"text-align: justify;\">EXCEL est comme chacun le sait un formidable outil de calcul. Il est utilis\u00e9 au quotidien pour remplir toutes sortes de t\u00e2ches n\u00e9cessitant de mettre en forme des tableaux de calcul, simulations et autres contr\u00f4les divers.<\/p>\n<p style=\"text-align: justify;\">Ce tableur est dot\u00e9 d\u2019une fonction de partage r\u00e9seau qui permet \u00e0 plusieurs utilisateurs de se connecter simultan\u00e9ment \u00e0 une m\u00eame feuille de calcul.<\/p>\n<p style=\"text-align: justify;\">Cette fonctionnalit\u00e9 offre deux int\u00e9r\u00eats majeurs\u00a0:<\/p>\n<ul>\n<li>Elle ouvre la voie au travail collaboratif \u00e0 moindre co\u00fbt pour des projets ais\u00e9ment personnalisables et flexibles,<\/li>\n<li>Elle permet la supervision en temps r\u00e9el des travaux des collaborateurs.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\">Mise en \u0153uvre\u00a0:<\/span><\/p>\n<p style=\"text-align: justify;\">Cette fonction est log\u00e9e dans le menu \u00ab\u00a0R\u00e9vision\u00a0\u00bb \/ \u00ab\u00a0Partager le classeur\u00a0\u00bb. Pour l\u2019activer, il suffit de cocher la case intitul\u00e9e \u00ab\u00a0Permettre une modification multi-utilisateur\u00a0\u00bb et de valider. La feuille de calcul s\u2019enregistre et devient disponible \u00e0 une ouverture simultan\u00e9e par plusieurs utilisateurs. Pour que les modifications d\u2019un utilisateur soit visible par les autres, il faut enregistrer la feuille. Bien entendu chaque utilisateur doit travailler sur une partie de feuille diff\u00e9rente sans quoi, EXCEL proposera de g\u00e9rer les conflits\u2026<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2011\/05\/XL-partage-r\u00e9seau.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-584  aligncenter\" title=\"XL partage r\u00e9seau\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2011\/05\/XL-partage-r\u00e9seau.bmp\" alt=\"\" width=\"271\" height=\"208\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\">Exemple d\u2019utilisation tir\u00e9 de l&#8217;application <a title=\"Projet AppliAUDIT, formalisation de la mission de commissariat aux comptes\" href=\"http:\/\/www.auditsi.eu\/?page_id=2009\">AppliAUDIT<\/a> :<\/span><\/p>\n<p style=\"text-align: justify;\">Lors du contr\u00f4le des comptes d\u2019une entreprise, une balance g\u00e9n\u00e9rale est g\u00e9n\u00e9ralement annot\u00e9e.<\/p>\n<p style=\"text-align: justify;\"><em>Extrait d&#8217;une balance g\u00e9n\u00e9rale de cycle (BGC) annot\u00e9e par l&#8217;auditeur :<\/em><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2011\/05\/XL-partage-r\u00e9seau2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-586\" title=\"XL partage r\u00e9seau2\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2011\/05\/XL-partage-r\u00e9seau2.bmp\" alt=\"\" width=\"573\" height=\"109\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Le partage de cette balance en r\u00e9seau permet au chef de mission de suivre l\u2019avancement de l\u2019audit\u00a0 et de traiter rapidement les points en suspens.<\/p>\n<p style=\"text-align: justify;\"><em>Supervision de l&#8217;avancement de l&#8217;audit de la BGC et identification des cycles comprenant des points en suspens :<\/em><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2011\/05\/XL-partage-r\u00e9seau3.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-588\" title=\"XL partage r\u00e9seau3\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2011\/05\/XL-partage-r\u00e9seau3.bmp\" alt=\"\" width=\"572\" height=\"162\" \/><\/a><a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d&#8217;articles Ma\u00eetriser Excel<\/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=\"Mettre%20en%20%C5%93uvre%20le%20travail%20collaboratif%20avec%20la%20fonction%20de%20partage%20r%C3%A9seau%20d%E2%80%99EXCEL\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>EXCEL est comme chacun le sait un formidable outil de calcul. Il est utilis\u00e9 au quotidien pour remplir toutes sortes de t\u00e2ches n\u00e9cessitant de mettre en forme des tableaux de calcul, simulations et autres contr\u00f4les divers. Ce tableur est dot\u00e9 d\u2019une fonction de partage r\u00e9seau qui permet \u00e0 plusieurs utilisateurs de se connecter simultan\u00e9ment \u00e0 &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=582\" class=\"more-link\">Continue reading &lsquo;Mettre en \u0153uvre le travail collaboratif avec la fonction de partage r\u00e9seau d\u2019EXCEL&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=\"Mettre%20en%20%C5%93uvre%20le%20travail%20collaboratif%20avec%20la%20fonction%20de%20partage%20r%C3%A9seau%20d%E2%80%99EXCEL\";<\/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":[7,40,48,49,1326],"tags":[281,173,1632,17,1633,321,320,323,322,319],"class_list":["post-582","post","type-post","status-publish","format-standard","hentry","category-breves","category-controle-des-comptes","category-excel","category-logiciels-daudit","category-maitriser-excel","tag-audit-des-comptes","tag-balance-generale","tag-controle-des-comptes","tag-demarche-daudit","tag-excel","tag-fonction-partage-reseau","tag-reseau","tag-resolution-des-conflits","tag-supervision","tag-travail-collaboratif"],"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\/582","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=582"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/582\/revisions"}],"predecessor-version":[{"id":4820,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/582\/revisions\/4820"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}