{"id":11587,"date":"2018-07-10T13:46:58","date_gmt":"2018-07-10T18:46:58","guid":{"rendered":"http:\/\/coparmexjal.org.mx\/?post_type=mec-events&#038;p=11587"},"modified":"2023-11-03T17:03:40","modified_gmt":"2023-11-03T23:03:40","slug":"excel-intermedio","status":"publish","type":"mec-events","link":"https:\/\/coparmexjal.org.mx\/cpx\/cursos\/excel-intermedio\/","title":{"rendered":"Excel Intermedio"},"content":{"rendered":"<p>[vc_row][vc_column][vc_column_text]Conoce y y aplica 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_row][vc_row css=\u00bb.vc_custom_1669927006070{background-color: #f9f9f9 !important;}\u00bb][vc_column][vc_row_inner][vc_column_inner width=\u00bb1\/4&#8243;][vc_column_text]<b><span style=\"color: #339966;\">Fechas:<\/span><br \/>\n<\/b><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;17, 24 de abril; 8 y 15 de mayo 2024&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:829,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;11&quot;:4,&quot;12&quot;:0}\">17, 24 de abril; 8 y 15 de mayo 2024<\/span>[\/vc_column_text][vc_column_text]<b><span style=\"color: #339966;\">Duraci\u00f3n:<\/span><br \/>\n<\/b>12 horas[\/vc_column_text][vc_column_text]<b><span style=\"color: #339966;\">Horario:<\/span><br \/>\n<\/b><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Mi\u00e9rcoles&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:829,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;11&quot;:4,&quot;12&quot;:0}\">Mi\u00e9rcoles<\/span> de<span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;16:00 a 19:00 hrs&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:829,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;11&quot;:4,&quot;12&quot;:0}\"> 16:00 a 19:00 hrs.<\/span>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=\u00bb1\/2&#8243;][vc_column_text]<b><span style=\"color: #339966;\">Nivel de conocimiento:<\/span><br \/>\n<\/b><strong>B\u00e1sico<\/strong>, es necesario contar con conocimientos previos en Excel, haber tomado un curso o utilizarlo como herramienta de trabajo.[\/vc_column_text][\/vc_column_inner][vc_column_inner width=\u00bb1\/4&#8243;][vc_column_text]<b><span style=\"color: #339966;\">Habilidades del participante:<br \/>\n<\/span><\/b>-Dominio de plataformas digitales<br \/>\n-Dominio b\u00e1sico de f\u00f3rmulas en Excel<\/p>\n<p><b><span style=\"color: #339966;\">Requerimientos para tomar el curso:<br \/>\n<\/span><\/b>-Disposici\u00f3n para aprender<br \/>\n-Equipo de c\u00f3mputo para tomar la sesi\u00f3n<br \/>\n-Contar el programa Excel en tu equipo[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]<b><span style=\"color: #339966;\">Aprender\u00e1s:<br \/>\n<\/span><\/b>-Ordenar y filtrar datos<br \/>\n-Utilizar funciones de b\u00fasqueda para eficientar las actividades de tu empresa<br \/>\n-Utilizar tablas din\u00e1micas<br \/>\n-Proteger tus documentos de Excel bloqueando celdas y protegiendo tus hojas de trabajo[\/vc_column_text][vc_row_inner][vc_column_inner width=\u00bb1\/2&#8243;][vc_column_text]<b><span style=\"color: #339966;\">Obtienes:<\/span><br \/>\n<\/b>Diploma, clase pr\u00e1ctica y constancia DC-3[\/vc_column_text][\/vc_column_inner][vc_column_inner width=\u00bb1\/2&#8243;][\/vc_column_inner][\/vc_row_inner][\/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=\u00bbListas y tablas\u00bb tab_id=\u00bb1572040042016-5cce572d-ba10&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbFila de totales y filtros avanzados\u00bb tab_id=\u00bb1572040042052-a5098803-647b\u00bb][\/vc_tta_section][vc_tta_section title=\u00bbFormato condicional\u00bb tab_id=\u00bb1572040325111-9bec5bc2-a1ac\u00bb][\/vc_tta_section][vc_tta_section title=\u00bbFunciones de conjunto\u00bb tab_id=\u00bb1572040361398-293d9e3e-5032&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbTablas din\u00e1micas\u00bb tab_id=\u00bb1572040399963-4665332b-08d5&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbGr\u00e1ficos din\u00e1micos\u00bb tab_id=\u00bb1572290429730-b06b7a12-0dc0&#8243;][\/vc_tta_section][vc_tta_section title=\u00bbMacros grabadas\u00bb tab_id=\u00bb1572290440089-a84a8db0-c9f9&#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 active_section=\u00bb0&#8243; collapsible_all=\u00bbtrue\u00bb][vc_tta_section title=\u00bbQuiero que me contacte un asesor\u00bb tab_id=\u00bb1592500042006-800fdc9e-0f56&#8243;][dhvc_form id=\u00bb19061&#8243;][\/vc_tta_section][\/vc_tta_accordion][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Conoce y aplica la herramienta de Microsoft Excel para b\u00fasquedas y an\u00e1lisis avanzados de informaci\u00f3n.<\/p>\n","protected":false},"author":1,"featured_media":9626,"comment_status":"closed","ping_status":"closed","template":"","tags":[],"mec_category":[661],"mec_speaker":[937],"class_list":["post-11587","mec-events","type-mec-events","status-publish","has-post-thumbnail","hentry","mec_category-administracion"],"_links":{"self":[{"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec-events\/11587","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=11587"}],"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=11587"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/tags?post=11587"},{"taxonomy":"mec_category","embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec_category?post=11587"},{"taxonomy":"mec_speaker","embeddable":true,"href":"https:\/\/coparmexjal.org.mx\/cpx\/wp-json\/wp\/v2\/mec_speaker?post=11587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}