{"id":3156,"date":"2025-11-18T02:17:55","date_gmt":"2025-11-18T02:17:55","guid":{"rendered":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/?post_type=product&#038;p=3156"},"modified":"2026-02-19T19:38:50","modified_gmt":"2026-02-19T19:38:50","slug":"excel-365-2019-2021-dashboards","status":"publish","type":"product","link":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/product\/excel-365-2019-2021-dashboards\/","title":{"rendered":"Excel 365\/2019-2021 Dashboards"},"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]Para obtener una ventaja verdaderamente competitiva, debe poder extraer inteligencia organizacional procesable de sus datos sin procesar y presentarla en un formato visualmente atractivo que permita a los responsables de la toma de decisiones ver las tendencias clave y obtener informaci\u00f3n. Y eso es exactamente lo que este curso pretende ayudarte a hacer.<\/p>\n<p>Este curso se basa en el conocimiento fundamental presentado en el curso Microsoft Excel para Office 365\/2021 B\u00e1sico e introduce los conceptos b\u00e1sicos del an\u00e1lisis de datos y c\u00f3mo usar Excel para crear paneles informativos.[\/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]En este curso, analizar\u00e1 y visualizar\u00e1 datos utilizando Excel y herramientas asociadas. Usted podr\u00e1:<\/p>\n<ol>\n<li>Realizar fundamentos de an\u00e1lisis de datos.<\/li>\n<li>Visualice datos con Excel.<\/li>\n<li>Analice datos con f\u00f3rmulas y funciones.<\/li>\n<li>Analizar datos con tablas din\u00e1micas.<\/li>\n<li>Presente informaci\u00f3n visual con paneles en Excel.<\/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  >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 dise\u00f1ado para estudiantes que ya tienen conocimientos y habilidades fundamentales en Excel y que desean comenzar a aprovechar la funcionalidad de an\u00e1lisis de datos con Excel utilizando funciones, gr\u00e1ficos y tablas din\u00e1micas, y utilizando visualizaciones en gr\u00e1ficos y paneles en Excel.[\/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, debe tener una habilidad b\u00e1sica con hojas de c\u00e1lculo de Excel, especialmente en la creaci\u00f3n de libros con f\u00f3rmulas y funciones. Puede obtener este nivel de conocimiento y habilidad tomando el siguiente curso de Operaciones L\u00f3gicas o cualquier equivalente:<\/p>\n<ul>\n<li>Microsoft Excel para Office 365\/2021 B\u00e1sico<\/li>\n<li>Se recomienda encarecidamente tener experiencia adicional en el lugar de trabajo con Excel.<\/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  >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: Fundamentos del an\u00e1lisis de datos\u00bb tab_id=\u00bb1742487131810-bf1c00d0-27b1&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Introducci\u00f3n a la ciencia de datos<\/li>\n<li>Crear y modificar tablas<\/li>\n<li>Ordenar y filtrar datos<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 2: Visualizaci\u00f3n de datos con Excel\u00bb tab_id=\u00bb1742487349033-f885ecc5-ca64&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Visualizar datos con gr\u00e1ficos<\/li>\n<li>Modificar y dar formato a los gr\u00e1ficos<\/li>\n<li>Aplicar las mejores pr\u00e1cticas en el dise\u00f1o de gr\u00e1ficos<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 3: An\u00e1lisis de datos con f\u00f3rmulas y funciones\u00bb tab_id=\u00bb1761765792020-f191c932-10f2&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Analizar datos con f\u00f3rmulas y rangos con nombre<\/li>\n<li>Analizar datos con funciones<\/li>\n<li>Implementar validaci\u00f3n de datos, formularios y controles<\/li>\n<li>Crear visualizaciones condicionales con funciones de b\u00fasqueda<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 4: An\u00e1lisis de datos con tablas din\u00e1micas\u00bb tab_id=\u00bb1761765791841-4559bfc5-4ebf\u00bb][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Crear una tabla din\u00e1mica<\/li>\n<li>Analizar datos de tablas din\u00e1micas<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=\u00bbM\u00f3dulo 5: Presentaci\u00f3n de perspectivas visuales con paneles en Excel\u00bb tab_id=\u00bb1761765791399-05a525de-3ad6&#8243;][vc_column_text css=\u00bb\u00bb css_params=\u00bb\u00bb]<\/p>\n<ul>\n<li>Visualizar datos con gr\u00e1ficos din\u00e1micos<\/li>\n<li>Filtrar datos usando segmentaciones y l\u00edneas de tiempo<\/li>\n<li>Crear un Dashboard en Excel<\/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]<a href=\"#\">CompTIA Project+ (Examen PK0-005)<\/a>[\/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]Para obtener una ventaja verdaderamente competitiva, debe poder extraer inteligencia organizacional procesable de sus datos sin procesar y presentarla en un formato [&hellip;]<\/p>\n","protected":false},"featured_media":3157,"template":"","meta":{"inline_featured_image":false,"_joinchat":[]},"product_brand":[],"product_cat":[218,169,219],"product_tag":[],"class_list":["post-3156","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\/3156","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\/3157"}],"wp:attachment":[{"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/media?parent=3156"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product_brand?post=3156"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product_cat?post=3156"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/develop1.webstudiopanama.com\/Tecnasa\/wp-json\/wp\/v2\/product_tag?post=3156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}