{"id":19826,"date":"2020-11-12T09:00:46","date_gmt":"2020-11-12T07:00:46","guid":{"rendered":"https:\/\/express.olivia.es\/2020\/11\/12\/massa-us-dexcel\/"},"modified":"2022-09-06T14:44:27","modified_gmt":"2022-09-06T12:44:27","slug":"massa-us-dexcel","status":"publish","type":"post","link":"https:\/\/olivia.es\/express\/ca\/massa-us-dexcel\/","title":{"rendered":"Massa \u00fas d&#8217;Excel?"},"content":{"rendered":"<p>Microsoft Excel s&#8217;ha convertit en una eina imprescindible per a la majoria de nosaltres, per\u00f2 massa sovint se li d\u00f3na un \u00fas per al qual no est\u00e0 dissenyat o que no era la seva intenci\u00f3 inicial.<\/p><p>Durant tots aquests \u00faltims anys he observat com moltes Pime utilitzen Excel per a tasques tan peculiars com per exemple:<\/p><ul class=\"wp-block-list\"><li>Inventari de productes<\/li><li>Relaci\u00f3 de n\u00fameros de s\u00e8rie d&#8217;equipament<\/li><li>Emissi\u00f3 de factures<\/li><li>Introducci\u00f3 d&#8217;hores en empreses de serveis<\/li><li>Gesti\u00f3 de la planificaci\u00f3 de persones<\/li><li>I un llarg etc\u00e8tera\u2026.<\/li><\/ul><p>Els problemes m\u00e9s comuns s\u00f3n del tipus:<\/p><ul class=\"wp-block-list\"><li>Hi ha diferents versions dins de cada empresa, i no tots els usuaris treballen a l&#8217;un\u00edson.<\/li><li>\u00c9s alguna cosa complex que dues persones de manera simult\u00e0nia puguin modificar la informaci\u00f3 que existeix dins d&#8217;aquest Excel (encara que eines com Microsoft SharePoint poden solucionar part d&#8217;aquest problema).<\/li><li>Manipulaci\u00f3 de l&#8217;estructura de les dades<\/li><li>Dificultat en la creaci\u00f3 de regles, s\u00ed, ja sabem que es poden crear regles en una cel\u00b7la, per\u00f2 digueu-me quantes dels fulls de c\u00e0lcul que teniu, incorporen aquesta caracter\u00edstica\u2026<\/li><\/ul><p>Moltes d&#8217;aquestes funcions les podria o hauria de fer el ERP, i no em malinterpreteu, no ser\u00e9 jo qui defenestre a Excel, per\u00f2 suposo que coincidirem que Excel no hauria de ser l&#8217;eina per a emetre una factura, i si avui no es fa amb el ERP\u2026 no ser\u00e0 que ha arribat el moment de comen\u00e7ar a pensar en un canvi?<\/p><p>Sovint s&#8217;ha recorregut a Excel per a fer aquestes labors per comoditat, simplicitat en l&#8217;\u00fas, entorn amigable, etc\u2026. Per\u00f2 amb el ERP de Microsoft, anomenat Business Central, \u00e9s possible usar una aplicaci\u00f3 que junta el millor d&#8217;Excel, amb la pot\u00e8ncia i integraci\u00f3 entre departaments que proporciona una aplicaci\u00f3 de Gesti\u00f3.<\/p><p>De fet, Business Central segueix comptat amb Excel com una magn\u00edfica eina per a l&#8217;an\u00e0lisi d&#8217;informaci\u00f3 (que \u00e9s una de les seves principals raons de vida), com un canal de generaci\u00f3 de Reports, i tamb\u00e9 com no, com una manera senzilla de poder editar dades de manera massiva.<\/p><p>Si encara no coneixes Business Central, et recomanem que visitis aquesta p\u00e0gina: <a href=\"https:\/\/express.olivia.es\/ca\/business-central-microsoft-dynamics-365-erp-cloud\/\" data-type=\"page\" data-id=\"19377\">Business Central<\/a><\/p><p><\/p><p><\/p><p><\/p><div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div><div class=\"badge-base LI-profile-badge\" data-locale=\"es_ES\" data-size=\"large\" data-theme=\"light\" data-type=\"VERTICAL\" data-vanity=\"davidvenero\" data-version=\"v1\"><a class=\"badge-base__link LI-simple-link\" href=\"https:\/\/es.linkedin.com\/in\/davidvenero?trk=profile-badge\">David Venero<\/a><\/div><script src=\"https:\/\/platform.linkedin.com\/badges\/js\/profile.js\" async=\"\" defer=\"\" type=\"text\/javascript\"><\/script>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel s&#8217;ha convertit en una eina imprescindible per a la majoria de nosaltres, per\u00f2 massa sovint se li d\u00f3na un \u00fas per al qual no est\u00e0 dissenyat o que no era la seva intenci\u00f3 inicial. Durant tots aquests \u00faltims anys he observat com moltes Pime utilitzen Excel per a tasques tan peculiars com per [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":19280,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[99,95],"tags":[96,97,98],"class_list":["post-19826","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-erp-pymes-ca","category-olivia-express-ca","tag-business-central-ca","tag-erp-ca","tag-pime"],"_links":{"self":[{"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/posts\/19826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/comments?post=19826"}],"version-history":[{"count":4,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/posts\/19826\/revisions"}],"predecessor-version":[{"id":19830,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/posts\/19826\/revisions\/19830"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/media\/19280"}],"wp:attachment":[{"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/media?parent=19826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/categories?post=19826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/olivia.es\/express\/ca\/wp-json\/wp\/v2\/tags?post=19826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}