{"id":15631,"date":"2019-10-30T13:58:28","date_gmt":"2019-10-30T19:58:28","guid":{"rendered":"https:\/\/coparmexjal.org.mx\/?post_type=mec-events&#038;p=15631"},"modified":"2020-11-03T10:36:16","modified_gmt":"2020-11-03T16:36:16","slug":"excel-intermedio-avanzado-3","status":"publish","type":"mec-events","link":"https:\/\/coparmexjal.org.mx\/cpx\/cursos\/excel-intermedio-avanzado-3\/","title":{"rendered":"Excel Intermedio &#8211; Avanzado"},"content":{"rendered":"<p>[vc_row][vc_column width=\u00bb2\/3&#8243;][vc_column_text]<\/p>\n<p>Conoce y y aplicar la herramienta de Microsoft Excel para b\u00fasquedas y an\u00e1lisis avanzados de informaci\u00f3n.<\/p>\n<p><strong>Pre-requisitos:<\/strong> Uso de Microsoft Excel a nivel b\u00e1sico por 6 meses o m\u00e1s tiempo.<\/p>\n<p><strong>\u00bfPara qui\u00e9n es este curso?<\/strong><\/p>\n<ul>\n<li>Cualquier persona que necesite elevar su conocimiento sobre la herramienta Microsoft Excel para ahorrar tiempo en el an\u00e1lisis de informaci\u00f3n, la generaci\u00f3n de reportes y la validaci\u00f3n de la informaci\u00f3n.<\/li>\n<li>Mandos medios que requieren conocer funciones avanzadas para preparaci\u00f3n y an\u00e1lisis de reportes.<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][vc_column width=\u00bb1\/3&#8243;][vc_column_text]Instructor:<br \/>\n<strong>CONSULTIA<\/strong>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_tta_accordion style=\u00bbmodern\u00bb active_section=\u00bb0&#8243; no_fill=\u00bbtrue\u00bb collapsible_all=\u00bbtrue\u00bb title=\u00bbTemario\u00bb][vc_tta_section title=\u00bbOrdenar datos.\u00bb tab_id=\u00bb1572040042016-5cce572d-ba10&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFiltrar datos\u00bb tab_id=\u00bb1572040042052-a5098803-647b\u00bb][\/vc_tta_section][vc_tta_section title=\u00bbEliminar datos duplicados\u00bb tab_id=\u00bb1572040325111-9bec5bc2-a1ac\u00bb][\/vc_tta_section][vc_tta_section title=\u00bbUsar formato condicional\u00bb tab_id=\u00bb1572040361398-293d9e3e-5032&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbValidar datos de entrada\u00bb tab_id=\u00bb1572040399963-4665332b-08d5&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbDesbloquear celdas y proteger hojas de trabajo\u00bb tab_id=\u00bb1572290429730-b06b7a12-0dc0&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFunciones de fecha\u00bb tab_id=\u00bb1572290440089-a84a8db0-c9f9&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFunciones de texto\u00bb tab_id=\u00bb1572290451044-88f07bb5-7864&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFunciones l\u00f3gicas (SI, O, Y)\u00bb tab_id=\u00bb1572290459681-25f17a99-560b\u00bb][\/vc_tta_section][vc_tta_section title=\u00bbFunciones de b\u00fasqueda\u00bb tab_id=\u00bb1572290469602-c2357df1-8703&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFunciones de informaci\u00f3n\u00bb tab_id=\u00bb1572290477696-87dc97c1-2a0d\u00bb][\/vc_tta_section][vc_tta_section title=\u00bbFunciones condicionales\u00bb tab_id=\u00bb1572290485146-38187192-e548&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFunci\u00f3n ConsultaV, BuscarV\u00bb tab_id=\u00bb1572290492620-c42fcc9c-d685&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbTablas Din\u00e1micas\u00bb tab_id=\u00bb1572290503505-53a2e226-25d9&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbMacros sencillas del men\u00fa Vista\u00bb tab_id=\u00bb1572290511697-32c30695-e339&#8243;][\/vc_tta_section][\/vc_tta_accordion][\/vc_column][\/vc_row][vc_row][vc_column width=\u00bb1\/2&#8243;][vc_column_text]<\/p>\n<p style=\"font-size: 20px;\"><strong style=\"color: #0071ce;\">Socio Coparmex:<\/strong><br \/>\nsolicita tu c\u00f3digo promocional y obt\u00e9n <strong style=\"color: #96bd13;\">un descuento adicional <\/strong> en todos los cursos.<\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=\u00bb1\/2&#8243;][vc_tta_accordion style=\u00bbmodern\u00bb c_icon=\u00bbtriangle\u00bb active_section=\u00bb0&#8243; no_fill=\u00bbtrue\u00bb collapsible_all=\u00bbtrue\u00bb][vc_tta_section title=\u00bbQuiero que me contacte un asesor\u00bb tab_id=\u00bb1591597474213-713bf5f3-522a\u00bb][dhvc_form id=\u00bb19061&#8243;][\/vc_tta_section][\/vc_tta_accordion][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column width=\u00bb2\/3&#8243;][vc_column_text] Conoce y y aplicar la herramienta de Microsoft Excel para b\u00fasquedas y an\u00e1lisis avanzados de informaci\u00f3n. Pre-requisitos: Uso de Microsoft Excel a nivel b\u00e1sico por 6 meses o m\u00e1s tiempo. \u00bfPara qui\u00e9n es este curso? Cualquier persona que necesite elevar su conocimiento sobre la herramienta Microsoft Excel para ahorrar tiempo en el an\u00e1lisis &hellip; <\/p>\n","protected":false},"author":1,"featured_media":9626,"comment_status":"closed","ping_status":"closed","template":"","tags":[],"mec_category":[898],"mec_speaker":[937],"class_list":["post-15631","mec-events","type-mec-events","status-publish","has-post-thumbnail","hentry","mec_category-academia-de-administracion"],"_links":{"self":[{"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec-events\/15631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec-events"}],"about":[{"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/types\/mec-events"}],"author":[{"embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/comments?post=15631"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/media\/9626"}],"wp:attachment":[{"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/media?parent=15631"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/tags?post=15631"},{"taxonomy":"mec_category","embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec_category?post=15631"},{"taxonomy":"mec_speaker","embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec_speaker?post=15631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}