{"id":9818,"date":"2024-05-23T10:36:35","date_gmt":"2024-05-23T13:36:35","guid":{"rendered":"https:\/\/playcomp.cl\/?post_type=product&#038;p=9818"},"modified":"2024-10-24T17:02:58","modified_gmt":"2024-10-24T20:02:58","slug":"excel-nivel-avanzado-gestion-de-bases-y-programacion-2","status":"publish","type":"product","link":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/","title":{"rendered":"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n"},"content":{"rendered":"<p><strong>Objetivo:<\/strong><br \/>\nAplicar las herramientas avanzadas de Ms Excel para gestionar la informaci\u00f3n obtenida de una base de datos en una o varias planillas de c\u00e1lculo.<\/p>\n<p><strong>Requisitos previos:<\/strong> Se requiere que el alumno utilice Excel Nivel Intermedio<\/p>\n<p><strong>M\u00f3dulo 1 T C\u00e1lculos avanzados<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nCalcular determinados valores mediante herramientas de Excel que permiten entregar datos espec\u00edficos en diferentes escenarios<br \/>\nContenido:<\/p>\n<ul>\n<li>T\u00e9cnica de anidamiento de funciones<\/li>\n<li>Consolidaci\u00f3n: Evaluaci\u00f3n formativa<\/li>\n<\/ul>\n<p><strong>M\u00f3dulo 2 An\u00e1lisis de Datos<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nCalcular determinados valores mediante herramientas de Excel que permiten entregar datos espec\u00edficos en diferentes escenarios<br \/>\nContenido:<\/p>\n<ul>\n<li>B\u00fasqueda de determinados valores<\/li>\n<li>B\u00fasqueda de determinados valores con restricciones<\/li>\n<\/ul>\n<p><strong>M\u00f3dulo 3 Gesti\u00f3n de Datos<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nOrganizar grandes cantidades de datos utilizando herramientas y funciones avanzadas para obtener datos espec\u00edficos de una planilla<\/p>\n<p><strong>Contenido:<\/strong><br \/>\nManejo de funciones matem\u00e1ticas<\/p>\n<ul>\n<li>Agrupamiento y generaci\u00f3n de esquemas<\/li>\n<li>Manejo de filtros avanzados<\/li>\n<li>Manejo de funciones de bases de datos<\/li>\n<li>Creaci\u00f3n y manejo de la informaci\u00f3n en una tabla din\u00e1mica<\/li>\n<li>Tratamiento para an\u00e1lisis de los datos en una tabla din\u00e1mica<\/li>\n<li>Tratamiento para an\u00e1lisis de los datos en una tabla din\u00e1mica<\/li>\n<li>Elementos avanzados de tabla din\u00e1mica<\/li>\n<\/ul>\n<p><strong>M\u00f3dulo 4 Gesti\u00f3n de Datos Externos<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nClasificar la informaci\u00f3n de una base de datos usando herramientas que trabajan datos externos complementarias a Microsoft Excel<\/p>\n<p><strong>Contenido:<\/strong><\/p>\n<ul>\n<li>Crear una consulta usando Ms Query<\/li>\n<li>Aplicar filtros y c\u00e1lculos en las consultas<\/li>\n<li>Obtenci\u00f3n de datos externos<\/li>\n<\/ul>\n<p><strong>M\u00f3dulo 5 Automatizaci\u00f3n de Procesos<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nAplicar herramientas de Macros de Visual Basic, para la automatizaci\u00f3n de diversos procesos<\/p>\n<p><strong>Contenido:<\/strong><\/p>\n<ul>\n<li>Creaci\u00f3n de Macros<\/li>\n<li>Edici\u00f3n de Macros<\/li>\n<li>Generar formularios<\/li>\n<li>Ejecuci\u00f3n<\/li>\n<li>Depuraci\u00f3n Visual Basic<\/li>\n<li>Asignaci\u00f3n de comandos<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Objetivo: Aplicar las herramientas avanzadas de Ms Excel para gestionar la informaci\u00f3n obtenida de una base de datos en una o varias planillas de c\u00e1lculo. Requisitos previos: Se requiere que el alumno utilice Excel Nivel Intermedio M\u00f3dulo 1 T C\u00e1lculos avanzados Objetivo Calcular determinados valores mediante herramientas de Excel que permiten entregar datos espec\u00edficos en&#8230;<\/p>\n","protected":false},"featured_media":10405,"template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[131],"product_tag":[],"class_list":{"0":"post-9818","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-planilla-de-calculos","8":"first","9":"instock","10":"shipping-taxable","11":"product-type-simple"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n - Play Comp<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n - Play Comp\" \/>\n<meta property=\"og:description\" content=\"Objetivo: Aplicar las herramientas avanzadas de Ms Excel para gestionar la informaci\u00f3n obtenida de una base de datos en una o varias planillas de c\u00e1lculo. Requisitos previos: Se requiere que el alumno utilice Excel Nivel Intermedio M\u00f3dulo 1 T C\u00e1lculos avanzados Objetivo Calcular determinados valores mediante herramientas de Excel que permiten entregar datos espec\u00edficos en...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Play Comp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/playcompchile\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-24T20:02:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png\" \/>\n\t<meta property=\"og:image:width\" content=\"361\" \/>\n\t<meta property=\"og:image:height\" content=\"361\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/\",\"url\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/\",\"name\":\"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n - Play Comp\",\"isPartOf\":{\"@id\":\"https:\/\/playcomp.cl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png\",\"datePublished\":\"2024-05-23T13:36:35+00:00\",\"dateModified\":\"2024-10-24T20:02:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#primaryimage\",\"url\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png\",\"contentUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png\",\"width\":361,\"height\":361},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/playcomp.cl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tienda\",\"item\":\"https:\/\/playcomp.cl\/index.php\/tienda\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/playcomp.cl\/#website\",\"url\":\"https:\/\/playcomp.cl\/\",\"name\":\"Play Comp\",\"description\":\"Organismo T\u00e9cnico de Capacitaci\u00f3n\",\"publisher\":{\"@id\":\"https:\/\/playcomp.cl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/playcomp.cl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/playcomp.cl\/#organization\",\"name\":\"Play Comp\",\"url\":\"https:\/\/playcomp.cl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png\",\"contentUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png\",\"width\":423,\"height\":112,\"caption\":\"Play Comp\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/playcompchile\/\",\"https:\/\/www.instagram.com\/playcomp_capacitacion?igsh=OGtwZzBsYW5qbTF5\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n - Play Comp","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/","og_locale":"es_ES","og_type":"article","og_title":"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n - Play Comp","og_description":"Objetivo: Aplicar las herramientas avanzadas de Ms Excel para gestionar la informaci\u00f3n obtenida de una base de datos en una o varias planillas de c\u00e1lculo. Requisitos previos: Se requiere que el alumno utilice Excel Nivel Intermedio M\u00f3dulo 1 T C\u00e1lculos avanzados Objetivo Calcular determinados valores mediante herramientas de Excel que permiten entregar datos espec\u00edficos en...","og_url":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/","og_site_name":"Play Comp","article_publisher":"https:\/\/www.facebook.com\/playcompchile\/","article_modified_time":"2024-10-24T20:02:58+00:00","og_image":[{"width":361,"height":361,"url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/","url":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/","name":"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n - Play Comp","isPartOf":{"@id":"https:\/\/playcomp.cl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#primaryimage"},"image":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#primaryimage"},"thumbnailUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png","datePublished":"2024-05-23T13:36:35+00:00","dateModified":"2024-10-24T20:02:58+00:00","breadcrumb":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#primaryimage","url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png","contentUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png","width":361,"height":361},{"@type":"BreadcrumbList","@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-avanzado-gestion-de-bases-y-programacion-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/playcomp.cl\/"},{"@type":"ListItem","position":2,"name":"Tienda","item":"https:\/\/playcomp.cl\/index.php\/tienda\/"},{"@type":"ListItem","position":3,"name":"EXCEL, Nivel Avanzado, gesti\u00f3n de bases y programaci\u00f3n"}]},{"@type":"WebSite","@id":"https:\/\/playcomp.cl\/#website","url":"https:\/\/playcomp.cl\/","name":"Play Comp","description":"Organismo T\u00e9cnico de Capacitaci\u00f3n","publisher":{"@id":"https:\/\/playcomp.cl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/playcomp.cl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/playcomp.cl\/#organization","name":"Play Comp","url":"https:\/\/playcomp.cl\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/","url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png","contentUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png","width":423,"height":112,"caption":"Play Comp"},"image":{"@id":"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/playcompchile\/","https:\/\/www.instagram.com\/playcomp_capacitacion?igsh=OGtwZzBsYW5qbTF5"]}]}},"_links":{"self":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product\/9818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/media\/10405"}],"wp:attachment":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/media?parent=9818"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_brand?post=9818"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_cat?post=9818"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_tag?post=9818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}