{"id":14992,"date":"2026-09-14T08:45:24","date_gmt":"2026-09-14T12:45:24","guid":{"rendered":"https:\/\/www.uajms.edu.bo\/posgrado\/?p=14992"},"modified":"2026-09-14T09:44:25","modified_gmt":"2026-09-14T13:44:25","slug":"curso-corto-analisis-de-datos-con-excel-y-google-sheets","status":"publish","type":"post","link":"https:\/\/www.uajms.edu.bo\/posgrado\/2026\/09\/14\/curso-corto-analisis-de-datos-con-excel-y-google-sheets\/","title":{"rendered":"CURSO CORTO: AN\u00c1LISIS DE DATOS CON EXCEL Y GOOGLE SHEETS"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/BOTON19.jpg\"><img decoding=\"async\" width=\"397\" height=\"43\" data-attachment-id=\"14993\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/inicio-2\/boton19-3\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/BOTON19.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;,&quot;alt&quot;:&quot;&quot;}\" data-image-title=\"BOTON19\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/BOTON19.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/BOTON19.jpg\" alt=\"\" class=\"wp-image-14993\" style=\"width:303px;height:auto\"\/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">El curso est\u00e1 orientado al desarrollo de competencias pr\u00e1cticas para el an\u00e1lisis de datos utilizando Microsoft Excel y Google Sheets. El participante aprender\u00e1 a organizar, limpiar, transformar y analizar informaci\u00f3n, aplicar funciones y herramientas de an\u00e1lisis, construir tablas y gr\u00e1ficos din\u00e1micos y elaborar dashboards para presentar resultados de manera clara y apoyar la toma de decisiones. Se trabajar\u00e1 con casos pr\u00e1cticos y ejercicios aplicados, utilizando ambas herramientas para identificar sus principales similitudes, diferencias y posibilidades de uso.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5.jpg\"><img decoding=\"async\" width=\"300\" height=\"32\" data-attachment-id=\"6021\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/2023\/08\/21\/diplomado-en-metodologia-de-la-investigacion-cientifica\/boton11-5\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON11-5\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5-300x32.jpg\" alt=\"\" class=\"wp-image-6021\" srcset=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5-300x32.jpg 300w, https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5.jpg 397w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Al finalizar el curso, el participante ser\u00e1 capaz de analizar datos utilizando Excel y Google Sheets, aplicando t\u00e9cnicas de organizaci\u00f3n, limpieza, transformaci\u00f3n, c\u00e1lculo, resumen y visualizaci\u00f3n de informaci\u00f3n.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Competencias espec\u00edficas:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2022 Organizar bases de datos bajo criterios adecuados para el an\u00e1lisis.<br>\u2022 Aplicar f\u00f3rmulas y funciones para obtener indicadores y resultados.<br>\u2022 Limpiar y transformar datos para su an\u00e1lisis.<br>\u2022 Utilizar tablas y gr\u00e1ficos din\u00e1micos para resumir informaci\u00f3n.<br>\u2022 Construir dashboards con indicadores y visualizaciones.<br>\u2022 Comparar y seleccionar herramientas de Excel y Google Sheets seg\u00fan la necesidad de an\u00e1lisis.<em><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1.jpg\"><img decoding=\"async\" width=\"300\" height=\"32\" data-attachment-id=\"6024\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/2023\/08\/21\/diplomado-en-metodologia-de-la-investigacion-cientifica\/boton13-1\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON13-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1-300x32.jpg\" alt=\"\" class=\"wp-image-6024\" srcset=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1-300x32.jpg 300w, https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1.jpg 397w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Curso 100% virtual<\/em><\/strong><em>, las clases s\u00edncronas se desarrollan mediante Google meet y el apoyo acad\u00e9mico en plataforma moodle (Clases grabadas, actividades y recursos)<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"32\" data-attachment-id=\"6025\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/2023\/08\/21\/diplomado-en-metodologia-de-la-investigacion-cientifica\/boton14-1\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON14-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1-300x32.jpg\" alt=\"\" class=\"wp-image-6025\" srcset=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1-300x32.jpg 300w, https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1.jpg 397w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>Profesionales: Bs. <\/strong><\/em><strong>300<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>Grupos de 5 Participantes Bs. <\/strong><\/em><strong>200<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>Estudiantes: Bs. <\/strong><\/em><strong>100<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Descuentos Especiales del 50% a trabajadores (Administrativos y docentes) de la UAJMS.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>CUENTA BANCARIA: BANCO UNI\u00d3N \u2013 CUENTA CORRIENTE N\u00b0 1-6035089<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/04\/BOTON16.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"43\" data-attachment-id=\"10521\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/?attachment_id=10521\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/04\/BOTON16.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON16\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/04\/BOTON16.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/04\/BOTON16.jpg\" alt=\"\" class=\"wp-image-10521\" style=\"width:305px;height:auto\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fotocopia o Foto del Carnet de Identidad<\/li>\n\n\n\n<li>Fotocopia o Foto del Comprobante (Deposito o transferencia Bancaria).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Los requisitos puede enviar v\u00eda Whatsapp al n\u00famero&nbsp;<a href=\"https:\/\/api.whatsapp.com\/send?phone=59172988960\">72988960<\/a><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"32\" data-attachment-id=\"6023\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/2023\/08\/21\/diplomado-en-metodologia-de-la-investigacion-cientifica\/boton12-1\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON12-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1-300x32.jpg\" alt=\"\" class=\"wp-image-6023\" srcset=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1-300x32.jpg 300w, https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1.jpg 397w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Carga Horaria:<\/strong><\/td><td><strong>60 Hrs. Acad\u00e9micas<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>El curso tiene una duraci\u00f3n de 4 SEMANAS con un horario predefinido del siguiente:<\/em><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><em>Horario<\/em><\/td><td><em>Lunes<\/em><\/td><td><em>Martes<\/em><\/td><td><em>Mi\u00e9rcoles<\/em><\/td><td><em>Jueves<\/em><\/td><td><em>Viernes<\/em><\/td><td><em>S\u00e1bado<\/em><\/td><\/tr><tr><td><em>19:15 a 21:<\/em>00 pm.<\/td><td><strong>\u2612<\/strong><\/td><td><strong>\u2610<\/strong><\/td><td><strong>\u2612<\/strong><\/td><td><strong>\u2610<\/strong><\/td><td><strong>\u2612<\/strong><\/td><td><strong>\u2610<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"color: #0c757d\"><strong>CERTIFICACI\u00d3N DEL CURSO:<\/strong><\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Certificado en condici\u00f3n de<strong> APROBADO <\/strong>a participantes que lograron una nota final promedio de m\u00e1s de 70 puntos sobre un total de 100.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Certificado en condici\u00f3n de<strong> PARTICIPANTE<\/strong> a quienes no hayan logrado el promedio de aprobaci\u00f3n pero que tuvieron una participaci\u00f3n regular del Curso.<\/em><\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"32\" data-attachment-id=\"6034\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/2023\/08\/14\/diplomado-en-protocolo-de-estambul\/boton17-2\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON17\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1-300x32.jpg\" alt=\"\" class=\"wp-image-6034\" srcset=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1-300x32.jpg 300w, https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1.jpg 397w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Este curso est\u00e1 dise\u00f1ado para:<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2714\ufe0f<\/em><em> Profesionales que trabajan con datos y desean optimizar su eficiencia en Excel.<\/em><em><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2714\ufe0f<\/em><em> Analistas financieros, administrativos y contables que buscan mejorar la toma de decisiones.<\/em><em><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2714\ufe0f<\/em><em> Empresarios, emprendedores y gestores que necesitan organizar informaci<\/em><em>\u00f3<\/em><em>n de manera efectiva.<\/em><em><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2714\ufe0f<\/em><em> Estudiantes y egresados de carreras administrativas, econ<\/em><em>\u00f3<\/em><em>micas y afines.<\/em><em><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u2714\ufe0f<\/em><em> Cualquier persona con conocimientos b<\/em><em>\u00e1<\/em><em>sicos de Excel que quiera avanzar a un nivel superior.<\/em><em><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/02\/CONTENIDO.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"43\" data-attachment-id=\"9703\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/?attachment_id=9703\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/02\/CONTENIDO.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"CONTENIDO\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/02\/CONTENIDO.jpg\" src=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/02\/CONTENIDO.jpg\" alt=\"\" class=\"wp-image-9703\" style=\"width:296px;height:auto\"\/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>M\u00d3DULO 1. FUNDAMENTOS DEL AN\u00c1LISIS DE DATOS<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Conceptos b\u00e1sicos de datos e informaci\u00f3n<\/li>\n\n\n\n<li>Estructura de una base de datos<\/li>\n\n\n\n<li>Tipos de datos y errores frecuentes<\/li>\n\n\n\n<li>Buenas pr\u00e1cticas para preparar informaci\u00f3n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>M\u00d3DULO 2. EXCEL Y GOOGLE SHEETS PARA EL AN\u00c1LISIS<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Entorno de trabajo y organizaci\u00f3n de archivos<\/li>\n\n\n\n<li>Formatos, filtros y ordenamiento<\/li>\n\n\n\n<li>Herramientas de colaboraci\u00f3n en Google Sheets<\/li>\n\n\n\n<li>Similitudes y diferencias entre Excel y Google Sheets<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>M\u00d3DULO 3. LIMPIEZA Y TRANSFORMACI\u00d3N DE DATOS<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Detecci\u00f3n y eliminaci\u00f3n de duplicados<\/li>\n\n\n\n<li>Correcci\u00f3n de datos inconsistentes<\/li>\n\n\n\n<li>Separar y combinar informaci\u00f3n<\/li>\n\n\n\n<li>Transformaci\u00f3n de textos, fechas y n\u00fameros<\/li>\n\n\n\n<li>Introducci\u00f3n a Power Query en Excel<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>M\u00d3DULO 4. F\u00d3RMULAS Y FUNCIONES PARA EL AN\u00c1LISIS<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Funciones matem\u00e1ticas y estad\u00edsticas<\/li>\n\n\n\n<li>Funciones l\u00f3gicas<\/li>\n\n\n\n<li>SUMAR.SI.CONJUNTO y CONTAR.SI.CONJUNTO<\/li>\n\n\n\n<li>BUSCARX y funciones de b\u00fasqueda<\/li>\n\n\n\n<li>Funciones de texto y fecha<\/li>\n\n\n\n<li>FILTRAR y funciones de matrices din\u00e1micas<\/li>\n\n\n\n<li>Equivalencias y diferencias entre Excel y Google Sheets<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>M\u00d3DULO 5. TABLAS Y TABLAS DIN\u00c1MICAS<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>.<\/em>Tablas estructuradas en Excel<\/li>\n\n\n\n<li>Tablas din\u00e1micas<\/li>\n\n\n\n<li>Agrupaci\u00f3n, filtros y segmentaci\u00f3n<\/li>\n\n\n\n<li>Resumen de informaci\u00f3n en Google Sheets<\/li>\n\n\n\n<li>An\u00e1lisis por categor\u00edas, per\u00edodos y dimensiones<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>M\u00d3DULO 6. VISUALIZACI\u00d3N Y GR\u00c1FICOS<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Selecci\u00f3n del gr\u00e1fico adecuado<\/li>\n\n\n\n<li>Gr\u00e1ficos de columnas, l\u00edneas, barras y combinados<\/li>\n\n\n\n<li>Gr\u00e1ficos y visualizaciones en Google Sheets<\/li>\n\n\n\n<li>Buenas pr\u00e1cticas para comunicar resultados<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>M\u00d3DULO 7. DASHBOARD PARA LA TOMA DE DECISIONES<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Dise\u00f1o de indicadores KPI<\/li>\n\n\n\n<li>Construcci\u00f3n de un dashboard<\/li>\n\n\n\n<li>Interactividad mediante filtros y segmentadores<\/li>\n\n\n\n<li>Presentaci\u00f3n de resultados<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>M\u00d3DULO 8. PROYECTO PR\u00c1CTICO DE AN\u00c1LISIS DE DATOS<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2022 Preparaci\u00f3n de una base de datos<\/li>\n\n\n\n<li>\u2022 Limpieza y transformaci\u00f3n<\/li>\n\n\n\n<li>\u2022 An\u00e1lisis mediante funciones y tablas din\u00e1micas<\/li>\n\n\n\n<li>\u2022 Construcci\u00f3n de indicadores y gr\u00e1ficos<\/li>\n\n\n\n<li>\u2022 Elaboraci\u00f3n y presentaci\u00f3n de un dashboard en Excel o Google Sheets<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2024\/08\/BOTON18.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"43\" data-attachment-id=\"8205\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/?attachment_id=8205\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2024\/08\/BOTON18.jpg\" data-orig-size=\"397,43\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"BOTON18\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2024\/08\/BOTON18.jpg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2024\/08\/BOTON18.jpg\" alt=\"\" class=\"wp-image-8205\"\/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.1 Datos personales<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. Ing. Marco Antonio Lavayen Rodriguez.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Especialista en Microsoft Excel con 20 a\u00f1os de experiencia.<\/em> <em>Certificaciones en herramientas de Microsoft Office.Experiencia docente en capacitaciones empresariales y acad\u00e9micas<\/em>.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/WhatsApp-Image-2026-09-14-at-08.22.02.jpeg\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"1600\" data-attachment-id=\"14991\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/inicio-2\/whatsapp-image-2026-09-14-at-08-22-02\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/WhatsApp-Image-2026-09-14-at-08.22.02.jpeg\" data-orig-size=\"1600,1600\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;,&quot;alt&quot;:&quot;&quot;}\" data-image-title=\"WhatsApp Image 2026-09-14 at 08.22.02\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/WhatsApp-Image-2026-09-14-at-08.22.02.jpeg\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2026\/09\/WhatsApp-Image-2026-09-14-at-08.22.02.jpeg\" alt=\"\" class=\"wp-image-14991\"\/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>El curso est\u00e1 orientado al desarrollo de competencias pr\u00e1cticas para el an\u00e1lisis de datos utilizando Microsoft Excel y Google Sheets. El participante aprender\u00e1 a organizar, limpiar, transformar y analizar informaci\u00f3n, [&hellip;]<\/p>\n","protected":false},"author":118,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"_joinchat":[],"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":true},"categories":[274],"tags":[],"class_list":["post-14992","post","type-post","status-publish","format-standard","hentry","category-cursos-cortos"],"views":15851,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5Qmml-3TO","publishpress_future_action":{"enabled":false,"date":"2026-10-02 00:48:01","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/posts\/14992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/users\/118"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/comments?post=14992"}],"version-history":[{"count":4,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/posts\/14992\/revisions"}],"predecessor-version":[{"id":14999,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/posts\/14992\/revisions\/14999"}],"wp:attachment":[{"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/media?parent=14992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/categories?post=14992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/tags?post=14992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}