{"id":3160,"date":"2025-11-18T02:36:09","date_gmt":"2025-11-18T02:36:09","guid":{"rendered":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/?post_type=product&#038;p=3160"},"modified":"2026-02-19T19:39:24","modified_gmt":"2026-02-19T19:39:24","slug":"excel-365-2019-2021-avanzado","status":"publish","type":"product","link":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/product\/excel-365-2019-2021-avanzado\/","title":{"rendered":"Excel 365\/2019-2021 Avanzado"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb{\u00abcss_margin_top_lg\u00ab:\u00ab35px\u00ab}\u00bb css=\u00bb.vc_custom_1771511282012{margin-top: -50px !important;margin-bottom: 25px !important;}\u00bb custom_css_response=\u00bb@media(max-width:991px){.vc_custom_1771511282012{margin-top:35px!important;}}\u00bb el_class=\u00bbbox-horarios\u00bb][vc_column offset=\u00bbvc_col-md-4&#8243; conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb]<div class=\"porto-sicon-box ico-firts_descripcion  wpb_custom_a7d3f3b196ad8e3b04a965ab1c411077 style_1 left-icon\"><div class=\"porto-sicon-left\"><div class=\"porto-just-icon-wrapper porto-icon advanced\" style=\"color:var(--porto-light-color);background:var(--porto-primary-color);width:50px;height:50px;line-height:50px;font-size:25px;\"><i class=\"Simple-Line-Icons-share-alt\"><\/i><\/div><\/div><div class=\"porto-sicon-body\"><div class=\"porto-sicon-header\"><h3 class=\"porto-sicon-title\" style=\"\">Modalidad<\/h3><p>Online en vivo<\/p><\/div> <!-- header --><\/div><\/div><!-- porto-sicon-box -->[\/vc_column][vc_column offset=\u00bbvc_col-md-4&#8243; conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb]<div class=\"porto-sicon-box ico-firts_descripcion  wpb_custom_a7d3f3b196ad8e3b04a965ab1c411077 style_1 left-icon\"><div class=\"porto-sicon-left\"><div class=\"porto-just-icon-wrapper porto-icon advanced\" style=\"color:var(--porto-light-color);background:var(--porto-primary-color);width:50px;height:50px;line-height:50px;font-size:25px;\"><i class=\"Simple-Line-Icons-clock\"><\/i><\/div><\/div><div class=\"porto-sicon-body\"><div class=\"porto-sicon-header\"><h3 class=\"porto-sicon-title\" style=\"\">Duraci\u00f3n (horas)<\/h3><p>40 horas<\/p><\/div> <!-- header --><\/div><\/div><!-- porto-sicon-box -->[\/vc_column][vc_column offset=\u00bbvc_col-md-4&#8243; conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb]<div class=\"porto-sicon-box ico-firts_descripcion  wpb_custom_a7d3f3b196ad8e3b04a965ab1c411077 style_1 left-icon\"><div class=\"porto-sicon-left\"><div class=\"porto-just-icon-wrapper porto-icon advanced\" style=\"color:var(--porto-light-color);background:var(--porto-primary-color);width:50px;height:50px;line-height:50px;font-size:25px;\"><i class=\"Simple-Line-Icons-calendar\"><\/i><\/div><\/div><div class=\"porto-sicon-body\"><div class=\"porto-sicon-header\"><h3 class=\"porto-sicon-title\" style=\"\">Horario<\/h3><p>6:30 p.m. a 9:30 p.m.<\/p><\/div> <!-- header --><\/div><\/div><!-- porto-sicon-box -->[\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761677518{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column]<div class=\"porto-u-heading  wpb_custom_8401c117e3d4ec3f020bf8bf001d4e53 porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0 \"><div class=\"porto-u-main-heading\"><h1  >Descripci\u00f3n general<\/h1><\/div><style>.porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0.porto-u-heading{text-align:left}<\/style><\/div>[vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]Este curso se basa en los conocimientos b\u00e1sicos e intermedios presentados en los cursos Microsoft Excel 365\/2021 B\u00e1sico y Microsoft Excel 365\/2021 Intermedio para ayudarlo a aprovechar al m\u00e1ximo su experiencia en Excel. La capacidad de colaborar con colegas, automatizar tareas complejas o repetitivas y usar l\u00f3gica condicional para construir y aplicar f\u00f3rmulas y funciones elaboradas pondr\u00e1 todo el poder de Excel al alcance de su mano. Cuanto m\u00e1s aprenda sobre c\u00f3mo hacer que Excel haga el trabajo duro por usted, m\u00e1s podr\u00e1 concentrarse en obtener las respuestas que necesita de la gran cantidad de datos que genera su organizaci\u00f3n.[\/vc_column_text][\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761683862{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column]<div class=\"porto-u-heading  wpb_custom_8401c117e3d4ec3f020bf8bf001d4e53 porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0 \"><div class=\"porto-u-main-heading\"><h1  >Objetivos<\/h1><\/div><style>.porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0.porto-u-heading{text-align:left}<\/style><\/div>[vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Trabaje con varias hojas de c\u00e1lculo y libros.<\/li>\n<li>Comparta y proteja libros de trabajo.<\/li>\n<li>Automatice la funcionalidad del libro.<\/li>\n<li>Utilice las funciones de b\u00fasqueda y la auditor\u00eda de f\u00f3rmulas.<\/li>\n<li>Datos de previsi\u00f3n.<\/li>\n<li>Crear mini gr\u00e1ficos y datos de mapas.<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761683862{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column]<div class=\"porto-u-heading  wpb_custom_8401c117e3d4ec3f020bf8bf001d4e53 porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0 \"><div class=\"porto-u-main-heading\"><h1  >Audiencia<\/h1><\/div><style>.porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0.porto-u-heading{text-align:left}<\/style><\/div>[vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]Este curso est\u00e1 dirigido a estudiantes que son usuarios experimentados de Excel y tienen el deseo o la necesidad de aumentar sus habilidades para trabajar con algunas de las caracter\u00edsticas m\u00e1s avanzadas de Excel. Es probable que los estudiantes necesiten solucionar problemas de libros de trabajo grandes y complejos, automatizar tareas repetitivas, participar en asociaciones de colaboraci\u00f3n que involucren datos de libros de trabajo, construir funciones complejas de Excel y usar esas funciones para realizar an\u00e1lisis rigurosos de conjuntos de datos extensos y complejos.[\/vc_column_text][\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761683862{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column]<div class=\"porto-u-heading  wpb_custom_8401c117e3d4ec3f020bf8bf001d4e53 porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0 \"><div class=\"porto-u-main-heading\"><h1  >Prerrequisitos<\/h1><\/div><style>.porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0.porto-u-heading{text-align:left}<\/style><\/div>[vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]Para garantizar el \u00e9xito, los estudiantes deben tener experiencia pr\u00e1ctica en el mundo real creando y analizando conjuntos de datos mediante el uso de Excel. Las tareas espec\u00edficas que los estudiantes deben poder realizar incluyen: crear f\u00f3rmulas y usar funciones de Excel; crear, ordenar y filtrar conjuntos de datos y tablas; presentar datos mediante gr\u00e1ficos b\u00e1sicos; crear y trabajar con tablas din\u00e1micas, segmentaciones de datos y gr\u00e1ficos din\u00e1micos; y personalizar el entorno de Excel.<\/p>\n<p>Para cumplir con estos requisitos previos, los estudiantes pueden tomar los siguientes cursos de Operaciones L\u00f3gicas, o deben poseer el nivel de habilidad equivalente:<\/p>\n<ol>\n<li>Microsoft Excel 365\/2021 B\u00e1sico<\/li>\n<li>Microsoft Excel 365\/2021 Intermedio<\/li>\n<\/ol>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761683862{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column]<div class=\"porto-u-heading  wpb_custom_8401c117e3d4ec3f020bf8bf001d4e53 porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0 \"><div class=\"porto-u-main-heading\"><h1  >Contenido del curso<\/h1><\/div><style>.porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0.porto-u-heading{text-align:left}<\/style><\/div>[vc_tta_accordion title_tag=\u00bbh1&#8243; section_title_tag=\u00bbh6&#8243; style=\u00bbflat\u00bb spacing=\u00bb5&#8243; gap=\u00bb5&#8243; c_icon=\u00bbchevron\u00bb active_section=\u00bb\u00bb collapsible_all=\u00bbtrue\u00bb css_params=\u00bb\u00bb][vc_tta_section title=\u00bbM\u00f3dulo 1: Trabajar con varias hojas de c\u00e1lculo y libros\u00bb tab_id=\u00bb1742487131810-bf1c00d0-27b1&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Usar enlaces y referencias externas<\/li>\n<li>Usar referencias 3D<\/li>\n<li>Consolide los datos<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 2: Compartir y proteger libros\u00bb tab_id=\u00bb1742487349033-f885ecc5-ca64&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Colaborar en un libro<\/li>\n<li>Proteger hojas de c\u00e1lculo y libros<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 3: Automatizaci\u00f3n de la funcionalidad del libro\u00bb tab_id=\u00bb1761765792020-f191c932-10f2&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Aplicar validaci\u00f3n de datos<\/li>\n<li>Buscar datos y f\u00f3rmulas no v\u00e1lidos con errores<\/li>\n<li>Trabajar con macros<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 4: Uso de funciones de b\u00fasqueda y auditor\u00eda de f\u00f3rmulas\u00bb tab_id=\u00bb1763433223114-d40c0885-17a1&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Usar funciones de b\u00fasqueda<\/li>\n<li>Celdas de rastreo<\/li>\n<li>Ver y evaluar f\u00f3rmulas<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 5: Datos de previsi\u00f3n\u00bb tab_id=\u00bb1763433263607-5da5a0f4-33d8&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Determinar los resultados potenciales mediante tablas de datos<\/li>\n<li>Determinar los resultados potenciales mediante escenarios<\/li>\n<li>Usar la funci\u00f3n B\u00fasqueda de objetivos<\/li>\n<li>Tendencias de datos de pron\u00f3stico<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 6: Creaci\u00f3n de mini gr\u00e1ficos y datos de mapeo\u00bb tab_id=\u00bb1763433297758-4486681d-ac11&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Crear mini gr\u00e1ficos<\/li>\n<li>Datos del mapa<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][\/vc_tta_accordion][\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761683862{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column]<div class=\"porto-u-heading  wpb_custom_8401c117e3d4ec3f020bf8bf001d4e53 porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0 \"><div class=\"porto-u-main-heading\"><h1  >Certificaci\u00f3n relacionada<\/h1><\/div><style>.porto-u-ad87e2eaf3f9c495180fe0156ddf3eb0.porto-u-heading{text-align:left}<\/style><\/div>[vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]Microsoft Excel (Microsoft 365 Apps y Office 2019): Examen MO-200 y Microsoft Excel Expert (Microsoft 365 Apps y Office 2019): Examen MO-201.[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb{\u00abcss_margin_top_lg\u00ab:\u00ab35px\u00ab}\u00bb css=\u00bb.vc_custom_1771511282012{margin-top: -50px !important;margin-bottom: 25px !important;}\u00bb custom_css_response=\u00bb@media(max-width:991px){.vc_custom_1771511282012{margin-top:35px!important;}}\u00bb el_class=\u00bbbox-horarios\u00bb][vc_column offset=\u00bbvc_col-md-4&#8243; conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb][\/vc_column][vc_column offset=\u00bbvc_col-md-4&#8243; conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb][\/vc_column][vc_column offset=\u00bbvc_col-md-4&#8243; conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb][\/vc_column][\/vc_row][vc_row conditional_render=\u00bb%5B%7B%22value_role%22%3A%22administrator%22%7D%5D\u00bb css_params=\u00bb\u00bb css=\u00bb.vc_custom_1761761677518{margin-bottom: 35px !important;border-bottom-width: 1px !important;padding-bottom: 15px !important;border-bottom-style: solid !important;border-color: #dddddd !important;}\u00bb][vc_column][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]Este curso se basa en los conocimientos b\u00e1sicos e intermedios presentados en los cursos Microsoft Excel 365\/2021 B\u00e1sico y Microsoft Excel 365\/2021 [&hellip;]<\/p>\n","protected":false},"featured_media":3161,"template":"","meta":{"inline_featured_image":false,"_joinchat":[]},"product_brand":[],"product_cat":[218,169,219],"product_tag":[],"class_list":["post-3160","product","type-product","status-publish","has-post-thumbnail","product_cat-analisis-de-datos","product_cat-aplicaciones-de-oficina","product_cat-microsoft-excel","first","instock","product-type-simple"],"_links":{"self":[{"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product\/3160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/media\/3161"}],"wp:attachment":[{"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/media?parent=3160"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product_brand?post=3160"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product_cat?post=3160"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product_tag?post=3160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}