{"id":504,"date":"2018-02-27T19:09:19","date_gmt":"2018-02-27T19:09:19","guid":{"rendered":"https:\/\/dogmasolutions.com.ar\/training\/?p=504"},"modified":"2018-02-27T19:10:33","modified_gmt":"2018-02-27T19:10:33","slug":"excel-seminario-funciones","status":"publish","type":"post","link":"https:\/\/dogmasolutions.com.ar\/training\/excel-seminario-funciones\/","title":{"rendered":"Seminario Funciones"},"content":{"rendered":"<p><strong><em>Audiencia: <\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Destinado a todos aquellos usuarios que manejan habitualmente la aplicaci\u00f3n, y que necesiten mejores conocimientos de f\u00f3rmulas en Excel, al finalizar el taller complementar\u00e1n mejor sus conocimientos y podr\u00e1n llevar a cabo c\u00e1lculos, estad\u00edsticas, presupuestos, informes, etc. un poco m\u00e1s elaborados.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em>Requisitos<\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Haber cursado Microsoft\u00a0<strong><a href=\"http:\/\/www.exotraining.com\/cursos\/microsoft-office\/excel\/ms-excel-nivel-1.html\">Excel Nivel B\u00e1sico<\/a>,<\/strong> o tener s\u00f3lidos conocimientos equivalentes<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em>Contenidos<\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>B\u00e1sicas<\/strong><\/li>\n<\/ul>\n<p>\u25aa SUMA<\/p>\n<p>\u25aa CONTAR<\/p>\n<p>\u25aa PROMEDIO<\/p>\n<p>\u25aa MAX<\/p>\n<p>\u25aa MIN<\/p>\n<p>\u25aa CONTARA<\/p>\n<p>\u25aa HOY<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Condicionales<\/strong><\/li>\n<\/ul>\n<p>\u25aa SI<\/p>\n<p>\u25aa CONTAR.SI<\/p>\n<p>\u25aa SUMAR.SI<\/p>\n<p>\u25aa CONTAR.SI.CONJUNTO<\/p>\n<p>\u25aa SUMAR.SI.CONJUNTO<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Texto<\/strong><\/li>\n<\/ul>\n<p>\u25aa IZQUIERDA<\/p>\n<p>\u25aa DERECHA<\/p>\n<p>\u25aa EXTRAE<\/p>\n<p>\u25aa LARGO<\/p>\n<p>\u25aa NOMPROPIO<\/p>\n<p>\u25aa CONCATENAR<\/p>\n<p>\u25aa DERECHA<\/p>\n<p>\u25aa IZQUIERDA<\/p>\n<p>\u25aa ESPACIOS<\/p>\n<p>\u25aa HALLAR<\/p>\n<p>\u25aa EXTRAE<\/p>\n<p>\u25aa MINUSC<\/p>\n<p>\u25aa MAYUSC<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>B\u00fasqueda<\/strong><\/li>\n<\/ul>\n<p>\u25aa BUSCARV<\/p>\n<p>\u25aa BUSCARH<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Funciones anidadas<\/strong><\/li>\n<\/ul>\n<p>\u25aa SI<\/p>\n<p>\u25aa Y<\/p>\n<p>\u25aa O<\/p>\n<p>\u25aa COINCIDIR<\/p>\n<p>\u25aa INDICE<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Introducci\u00f3n a funciones matriciales<\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Audiencia: &nbsp; Destinado a todos aquellos usuarios que manejan habitualmente la aplicaci\u00f3n, y que necesiten mejores conocimientos de f\u00f3rmulas en Excel, al finalizar el taller complementar\u00e1n mejor sus conocimientos y podr\u00e1n llevar a cabo c\u00e1lculos, estad\u00edsticas, presupuestos, informes, etc. un poco m\u00e1s elaborados. &nbsp; Requisitos &nbsp; Haber cursado Microsoft\u00a0Excel Nivel B\u00e1sico, o tener s\u00f3lidos conocimientos [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[32],"tags":[],"class_list":["post-504","post","type-post","status-publish","format-standard","hentry","category-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/posts\/504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/comments?post=504"}],"version-history":[{"count":2,"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/posts\/504\/revisions"}],"predecessor-version":[{"id":506,"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/posts\/504\/revisions\/506"}],"wp:attachment":[{"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/media?parent=504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/categories?post=504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dogmasolutions.com.ar\/training\/wp-json\/wp\/v2\/tags?post=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}