{"id":9852,"date":"2025-03-14T10:35:03","date_gmt":"2025-03-14T14:35:03","guid":{"rendered":"https:\/\/www.uajms.edu.bo\/posgrado\/?p=9852"},"modified":"2025-09-12T15:06:20","modified_gmt":"2025-09-12T19:06:20","slug":"cc-excel-intermedio-avanzado","status":"publish","type":"post","link":"https:\/\/www.uajms.edu.bo\/posgrado\/2025\/03\/14\/cc-excel-intermedio-avanzado\/","title":{"rendered":"CURSO CORTO: EXCEL INTERMEDIO &#8211; AVANZADO"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON11-5-300x32.jpg\" 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<ul class=\"wp-block-list\">\n<li><em>Aplicar herramientas avanzadas de Excel para manipulaci\u00f3n y an\u00e1lisis eficiente de datos.<\/em><\/li>\n\n\n\n<li><em>Utilizar funciones avanzadas (l<\/em><em>\u00f3<\/em><em>gicas, de b<\/em><em>\u00fa<\/em><em>squeda, matem<\/em><em>\u00e1<\/em><em>ticas y de texto) para resolver problemas pr<\/em><em>\u00e1<\/em><em>cticos.<\/em><\/li>\n\n\n\n<li><em>Gestionar bases de datos y automatizar procesos mediante tablas din<\/em><em>\u00e1<\/em><em>micas y Power Query.<\/em><\/li>\n\n\n\n<li><em>Crear gr<\/em><em>\u00e1<\/em><em>ficos din<\/em><em>\u00e1<\/em><em>micos e informes interactivos para la toma de decisiones.<\/em><\/li>\n\n\n\n<li><em>Implementar macros y principios de VBA para la automatizaci<\/em><em>\u00f3<\/em><em>n de tareas repetitivas.<\/em><\/li>\n\n\n\n<li><em>Aplicar herramientas avanzadas como Solver, an<\/em><em>\u00e1<\/em><em>lisis de hip<\/em><em>\u00f3<\/em><em>tesis y modelos de simulaci<\/em><em>\u00f3<\/em><em>n.<\/em><\/li>\n\n\n\n<li><em>Usar medidas de seguridad y validaci\u00f3n de datos para mejorar la integridad de la informaci\u00f3n<\/em><\/li>\n<\/ul>\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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON13-1-300x32.jpg\" 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=\"has-text-align-justify\"><strong><em>Curso 100% virtual<\/em><\/strong><em>, las clases s\u00edncronas se desarrollan mediante zoom 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 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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON14-1-300x32.jpg\" 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><em><strong>Profesionales: Bs. <\/strong><\/em><strong>300<\/strong><\/p>\n\n\n\n<p><em><strong>Estudiantes: Bs. <\/strong><\/em><strong>100<\/strong><\/p>\n\n\n\n<p>Descuentos Especiales del 50% a trabajadores (Administrativos y docentes) de la UAJMS.<\/p>\n\n\n\n<p><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\/2025\/04\/23\/curso-corto-diseno-visual-con-canva-herramientas-publicitarias-para-emprendedores-y-pymes\/boton16-4\/\" 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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/04\/BOTON16.jpg\" 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><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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON12-1-300x32.jpg\" 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>48 Hrs. Acad\u00e9micas<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><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:30 a 21:<\/em>30 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><span style=\"color: #0c757d\"><strong>CERTIFICACI\u00d3N DEL CURSO:<\/strong><\/span><\/p>\n\n\n\n<p><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><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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2023\/08\/BOTON17-1-300x32.jpg\" 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><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><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><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><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><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\/2025\/02\/25\/curso-corto-formacion-para-tribunales-de-trabajos-finales-de-especialidad-y-maestria-en-educacion-superior\/contenido\/\" 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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/02\/CONTENIDO.jpg\" 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><strong>Unidad I.  Fundamentos Avanzados de Excel<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Repaso de atajos y t\u00e9cnicas de productividad.<\/em><\/li>\n\n\n\n<li><em>Referencias absolutas, relativas y mixtas.<\/em><\/li>\n\n\n\n<li><em>Formato condicional avanzado.<\/em><\/li>\n\n\n\n<li><em>Validaci\u00f3n de datos y restricciones en celdas<\/em><\/li>\n<\/ul>\n\n\n\n<p><strong>Unidad II. Funciones Avanzadas<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Funciones l\u00f3gicas: SI, Y, O, SI.ERROR.<\/em><\/li>\n\n\n\n<li><em>Funciones de b\u00fasqueda y referencia: BUSCARX, INDICE, COINCIDIR, CONSULTAV.<\/em><\/li>\n\n\n\n<li><em>Funciones de texto y manipulaci\u00f3n de datos.<\/em><\/li>\n\n\n\n<li><em>Funciones matem\u00e1ticas y estad\u00edsticas.<\/em><\/li>\n<\/ul>\n\n\n\n<p><strong>Unidad III. An\u00e1lisis y Manejo de Datos<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Ordenamiento y filtros avanzados.<\/em><\/li>\n\n\n\n<li><em>Uso de tablas din\u00e1micas y segmentaci\u00f3n de datos.<\/em><\/li>\n\n\n\n<li><em>Introducci\u00f3n a Power Query para transformaci\u00f3n de datos.<\/em><\/li>\n\n\n\n<li><em>Uso de subtotales y consolidaci\u00f3n de datos.<\/em><\/li>\n<\/ul>\n\n\n\n<p><strong>Unidad IV. Creaci\u00f3n de Reportes y Gr\u00e1ficos Avanzados<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Creaci\u00f3n de gr\u00e1ficos avanzados y din\u00e1micos.<\/em><\/li>\n\n\n\n<li><em>Dashboards interactivos con segmentaciones y gr\u00e1ficos vinculados.<\/em><\/li>\n\n\n\n<li><em>Tablas din\u00e1micas avanzadas con an\u00e1lisis de tendencias.<\/em><\/li>\n\n\n\n<li><em>Uso de minigr\u00e1ficos para an\u00e1lisis visual r\u00e1pido<\/em><\/li>\n<\/ul>\n\n\n\n<p><strong>Unidad V. Automatizaci\u00f3n con Macros y VBA<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Introducci\u00f3n a las macros: grabaci\u00f3n y ejecuci\u00f3n.<\/em><\/li>\n\n\n\n<li><em>Edici\u00f3n de macros en Visual Basic for Applications (VBA).<\/em><\/li>\n\n\n\n<li><em>Creaci\u00f3n de botones y formularios interactivos.<\/em><\/li>\n\n\n\n<li><em>Automatizaci\u00f3n de reportes y procesos repetitivos.<\/em><\/li>\n<\/ul>\n\n\n\n<p><strong>Unidad VI. An\u00e1lisis de Datos y Modelos Predictivos<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Solver y optimizaci\u00f3n de escenarios.<\/em><\/li>\n\n\n\n<li><em>An\u00e1lisis de hip\u00f3tesis: Tabla de datos, Buscar objetivo y Escenarios.<\/em><\/li>\n\n\n\n<li><em>Simulaci\u00f3n de datos y pron\u00f3sticos con funciones avanzadas.<\/em><\/li>\n\n\n\n<li><em>Introducci\u00f3n a Power Pivot y DAX.<\/em><\/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\/2024\/08\/07\/cc-herramientas-digitales-para-docentes-2026\/boton18-2\/\" 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-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2024\/08\/BOTON18.jpg\" 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><strong>3.1 Datos personales<\/strong><\/p>\n\n\n\n<p><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\/2025\/09\/flyer-excel-avanzado-oct.png\"><img loading=\"lazy\" decoding=\"async\" width=\"2550\" height=\"2551\" data-attachment-id=\"11660\" data-permalink=\"https:\/\/www.uajms.edu.bo\/posgrado\/inicio-2\/flyer-excel-avanzado-oct\/\" data-orig-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/09\/flyer-excel-avanzado-oct.png\" data-orig-size=\"2550,2551\" 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;}\" data-image-title=\"flyer-excel-avanzado-oct\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/09\/flyer-excel-avanzado-oct.png\" data-large-file=\"https:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/09\/flyer-excel-avanzado-oct.png\" src=\"http:\/\/www.uajms.edu.bo\/posgrado\/wp-content\/uploads\/sites\/10\/2025\/09\/flyer-excel-avanzado-oct.png\" alt=\"\" class=\"wp-image-11660\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Curso 100% virtual, las clases s\u00edncronas se desarrollan mediante zoom y el apoyo acad\u00e9mico en plataforma moodle (Clases grabadas, actividades y recursos). Profesionales: Bs. 300 Estudiantes: Bs. 100 Descuentos Especiales [&hellip;]<\/p>\n","protected":false},"author":118,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_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}},"categories":[274],"tags":[],"class_list":["post-9852","post","type-post","status-publish","format-standard","hentry","category-cursos-cortos"],"views":12408,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5Qmml-2yU","publishpress_future_action":{"enabled":false,"date":"2026-04-11 16:52:28","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\/9852","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=9852"}],"version-history":[{"count":4,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/posts\/9852\/revisions"}],"predecessor-version":[{"id":11701,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/posts\/9852\/revisions\/11701"}],"wp:attachment":[{"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/media?parent=9852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/categories?post=9852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uajms.edu.bo\/posgrado\/wp-json\/wp\/v2\/tags?post=9852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}