{"id":3069,"date":"2023-03-06T12:50:30","date_gmt":"2023-03-06T17:50:30","guid":{"rendered":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/?post_type=cursos&#038;p=3069"},"modified":"2023-03-07T13:36:02","modified_gmt":"2023-03-07T18:36:02","slug":"analisis-de-datos-en-excel","status":"publish","type":"cursos","link":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/","title":{"rendered":"An\u00e1lisis de Datos en Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Temario<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. Herramientas<\/strong><br>1.1. Suma<br>1.2. Tablas<br>1.3. Relleno<br>1.4. An\u00e1lisis<br>1.5. Divisi\u00f3n<br>1.6. Gr\u00e1ficos<br>1.7. Transposici\u00f3n<br>1.8. Tablas din\u00e1micas<br>1.9. Listas desplegables<br>1.10. Ordenaci\u00f3n y filtrado<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. F\u00f3rmulas<\/strong><br>2.1. Concepto<br>2.2. Funciones<br>2.3. Min y Max<br>2.4. Promedios<br>2.5. Buscar V\/H<br>2.6. Fecha y hora<br>2.7. Instrucciones Si<br>2.8. Errores de f\u00f3rmula<br>2.9. Unir texto y n\u00fameros<br>2.10. Funciones condicionales<br>2.11. Asistente para funciones<br>2.12. Funciones de bases de datos BDSuma, BDMax, BDMin, BDPromedio, BDContar<br>2.13. Funciones l\u00f3gicas Si, Si error, Y, O, SumarSi, SumarSiConjunto, ContarSiConjunto, PromedioSiConjunto<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. An\u00e1lisis Gr\u00e1fico<\/strong><br>3.1. Crear un gr\u00e1fico<br>3.2. Tabla con gr\u00e1fico<br>3.3. Gr\u00e1ficos din\u00e1micos<br>3.4. Segundo gr\u00e1fico circular<br>3.5. Etiquetas de varios niveles<br>3.6. Filtrar los datos de un gr\u00e1fico<br>3.7. Conecte un t\u00edtulo del gr\u00e1fico a una celda<br>3.8. Eje secundario para crear un gr\u00e1fico combinado<br>3.9. Elementos de gr\u00e1fico para obtener una vista previa<br>3.10. Seleccionar columnas espec\u00edficas antes de crear un gr\u00e1fico<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Maneja eficientemente gran cantidad de datos , genera y gr\u00e1fica informes \u00a1Desarrolla aplicativos en Excel!<\/p>\n","protected":false},"featured_media":2733,"template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false},"class_list":["post-3069","cursos","type-cursos","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>An\u00e1lisis de Datos en Excel - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1<\/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:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An\u00e1lisis de Datos en Excel - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\" \/>\n<meta property=\"og:description\" content=\"Maneja eficientemente gran cantidad de datos , genera y gr\u00e1fica informes \u00a1Desarrolla aplicativos en Excel!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-07T18:36:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/\",\"name\":\"An\u00e1lisis de Datos en Excel - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\",\"isPartOf\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg\",\"datePublished\":\"2023-03-06T17:50:30+00:00\",\"dateModified\":\"2023-03-07T18:36:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#primaryimage\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg\",\"contentUrl\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg\",\"width\":600,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"cursos\",\"item\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An\u00e1lisis de Datos en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/\",\"name\":\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\",\"description\":\"Instituci\u00f3n de educaci\u00f3n superior\",\"publisher\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization\",\"name\":\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png\",\"contentUrl\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png\",\"width\":57,\"height\":73,\"caption\":\"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1\"},\"image\":{\"@id\":\"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"An\u00e1lisis de Datos en Excel - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","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:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"An\u00e1lisis de Datos en Excel - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","og_description":"Maneja eficientemente gran cantidad de datos , genera y gr\u00e1fica informes \u00a1Desarrolla aplicativos en Excel!","og_url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/","og_site_name":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","article_modified_time":"2023-03-07T18:36:02+00:00","og_image":[{"width":600,"height":300,"url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/","name":"An\u00e1lisis de Datos en Excel - Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","isPartOf":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg","datePublished":"2023-03-06T17:50:30+00:00","dateModified":"2023-03-07T18:36:02+00:00","breadcrumb":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#primaryimage","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg","contentUrl":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2022\/11\/curso-de-excel-datos.jpg","width":600,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/analisis-de-datos-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/"},{"@type":"ListItem","position":2,"name":"cursos","item":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/cursos\/"},{"@type":"ListItem","position":3,"name":"An\u00e1lisis de Datos en Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#website","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/","name":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","description":"Instituci\u00f3n de educaci\u00f3n superior","publisher":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#organization","name":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/","url":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png","contentUrl":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-content\/uploads\/2021\/09\/logo-politecnico-santafe-bogota.png","width":57,"height":73,"caption":"Polit\u00e9cnico Santaf\u00e9 de Bogot\u00e1"},"image":{"@id":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/cursos\/3069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/cursos"}],"about":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/types\/cursos"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/media\/2733"}],"wp:attachment":[{"href":"https:\/\/www.politecnicosantafedebogota.edu.co\/portal\/wp-json\/wp\/v2\/media?parent=3069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}