{"id":9817,"date":"2024-05-23T10:33:31","date_gmt":"2024-05-23T13:33:31","guid":{"rendered":"https:\/\/playcomp.cl\/?post_type=product&#038;p=9817"},"modified":"2024-10-24T17:01:14","modified_gmt":"2024-10-24T20:01:14","slug":"excel-nivel-intermedio-2","status":"publish","type":"product","link":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/","title":{"rendered":"Excel, nivel Intermedio"},"content":{"rendered":"<p><strong>Objetivo:<\/strong><br \/>\nAplicar distintas herramientas de excel intermedio para modificar tanto el ambiente de trabajo, como la informaci\u00f3n en las planillas, por medio de funciones, que permitan gestionar y analizar de manera m\u00e1s c\u00f3moda y f\u00e1cil una base de datos .<\/p>\n<p><strong>Requisitos previos:<\/strong> Se requiere que el alumno utilice Excel a Nivel Usuario<\/p>\n<p><strong>M\u00f3dulo 1 Trabajo con libro y hoja de c\u00e1lculo<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nReconocer las herramientas que permiten adaptar el ambiente de trabajo de una o varias ventanas<br \/>\nContenido:<br \/>\nPersonalizar el libro de trabajo<br \/>\n&#8211; Presentaci\u00f3n de ventanas<br \/>\n&#8211; Ejecutar pegado especial<br \/>\n&#8211; Proteger y compartir<br \/>\n&#8211; Evaluaci\u00f3n formativa 1<\/p>\n<p><strong>M\u00f3dulo 2 \u00c1reas de Trabajo<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nDistinguir las caracter\u00edsticas de los nombres de rango utiliz\u00e1ndolas en f\u00f3rmulas funciones y diferentes herramientas de Excel<\/p>\n<p><strong>Contenido:<\/strong><br \/>\nConstrucci\u00f3n nombres de rangos<br \/>\n&#8211; Administrar nombre rango<br \/>\n&#8211; Evaluaci\u00f3n formativa 2<\/p>\n<p><strong>M\u00f3dulo 3 Funciones<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nOrganizar cifras, fechas y textos en una base de datos por medio de diferentes tipos funciones<\/p>\n<p><strong>Contenido:<\/strong><br \/>\nManejo de funciones matem\u00e1ticas<br \/>\n&#8211; Manejo de funciones financieras<br \/>\n&#8211; Manejo de funciones y herramientas de texto<br \/>\n&#8211; Manejo de funciones de fecha<br \/>\n&#8211; Funciones estad\u00edsticas<br \/>\n&#8211; Evaluaci\u00f3n formativa 3<\/p>\n<p><strong>M\u00f3dulo 4 Validaci\u00f3n de datos y uso de herramientas de auditoria<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nUtilizar auditor\u00eda de datos para determinar de d\u00f3nde preceden los datos de una f\u00f3rmula y validaci\u00f3n para elegir qu\u00e9 informaci\u00f3n ingresar en una celda<\/p>\n<p><strong>Contenido:<\/strong><br \/>\nValidaci\u00f3n de datos y uso de herramientas<br \/>\nde auditor\u00eda<br \/>\n&#8211; Validar datos en la hoja<br \/>\n&#8211; Auditor\u00eda de f\u00f3rmulas<br \/>\n&#8211; Evaluaci\u00f3n formativa 4<\/p>\n<p><strong>M\u00f3dulo 5 Manejo de Funciones.<\/strong><\/p>\n<p><strong>Objetivo<\/strong><br \/>\nAplicar herramientas y\/o funciones de base de datos para buscar y ordenar grandes cantidades de informaci\u00f3n<\/p>\n<p><strong>Contenido:<\/strong><br \/>\nManejo de funciones de b\u00fasqueda<br \/>\n&#8211; Generar tablas<br \/>\n&#8211; Creaci\u00f3n de tablas din\u00e1micas<br \/>\n&#8211; An\u00e1lisis de Datos e interpretaci\u00f3n de resultados<br \/>\n&#8211; Evaluaci\u00f3n formativa 5<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Objetivo: Aplicar distintas herramientas de excel intermedio para modificar tanto el ambiente de trabajo, como la informaci\u00f3n en las planillas, por medio de funciones, que permitan gestionar y analizar de manera m\u00e1s c\u00f3moda y f\u00e1cil una base de datos . Requisitos previos: Se requiere que el alumno utilice Excel a Nivel Usuario M\u00f3dulo 1 Trabajo&#8230;<\/p>\n","protected":false},"featured_media":10405,"template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[131],"product_tag":[],"class_list":{"0":"post-9817","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 Intermedio - 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-intermedio-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel, nivel Intermedio - Play Comp\" \/>\n<meta property=\"og:description\" content=\"Objetivo: Aplicar distintas herramientas de excel intermedio para modificar tanto el ambiente de trabajo, como la informaci\u00f3n en las planillas, por medio de funciones, que permitan gestionar y analizar de manera m\u00e1s c\u00f3moda y f\u00e1cil una base de datos . Requisitos previos: Se requiere que el alumno utilice Excel a Nivel Usuario M\u00f3dulo 1 Trabajo...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-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:01:14+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=\"2 minutos\" \/>\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-intermedio-2\/\",\"url\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/\",\"name\":\"Excel, nivel Intermedio - Play Comp\",\"isPartOf\":{\"@id\":\"https:\/\/playcomp.cl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png\",\"datePublished\":\"2024-05-23T13:33:31+00:00\",\"dateModified\":\"2024-10-24T20:01:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-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-intermedio-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 Intermedio\"}]},{\"@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 Intermedio - 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-intermedio-2\/","og_locale":"es_ES","og_type":"article","og_title":"Excel, nivel Intermedio - Play Comp","og_description":"Objetivo: Aplicar distintas herramientas de excel intermedio para modificar tanto el ambiente de trabajo, como la informaci\u00f3n en las planillas, por medio de funciones, que permitan gestionar y analizar de manera m\u00e1s c\u00f3moda y f\u00e1cil una base de datos . Requisitos previos: Se requiere que el alumno utilice Excel a Nivel Usuario M\u00f3dulo 1 Trabajo...","og_url":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/","og_site_name":"Play Comp","article_publisher":"https:\/\/www.facebook.com\/playcompchile\/","article_modified_time":"2024-10-24T20:01:14+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":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/","url":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/","name":"Excel, nivel Intermedio - Play Comp","isPartOf":{"@id":"https:\/\/playcomp.cl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/#primaryimage"},"image":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/#primaryimage"},"thumbnailUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Excel.con_.png","datePublished":"2024-05-23T13:33:31+00:00","dateModified":"2024-10-24T20:01:14+00:00","breadcrumb":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/index.php\/producto\/excel-nivel-intermedio-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-intermedio-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 Intermedio"}]},{"@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\/9817","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=9817"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_brand?post=9817"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_cat?post=9817"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_tag?post=9817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}