{"id":8320,"date":"2022-12-15T16:20:41","date_gmt":"2022-12-15T15:20:41","guid":{"rendered":"https:\/\/asispa.org\/formacion\/?post_type=product&p=8320"},"modified":"2023-06-26T11:27:23","modified_gmt":"2023-06-26T09:27:23","slug":"excel-avanzado","status":"publish","type":"product","link":"https:\/\/asispa.org\/formacion\/curso\/excel-avanzado\/","title":{"rendered":"Excel avanzado"},"content":{"rendered":"

[et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.16″ _module_preset=\u00bbdefault\u00bb background_color=\u00bbRGBA(255,255,255,0)\u00bb custom_margin=\u00bb0px|0px|0px|0px|false|false\u00bb custom_padding=\u00bb0px|0px|0px|0px|false|false\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_row _builder_version=\u00bb4.17.2″ _module_preset=\u00bbdefault\u00bb use_background_color_gradient=\u00bbon\u00bb background_color_gradient_direction=\u00bb282deg\u00bb background_color_gradient_stops=\u00bb#008644 0%|#00448a 100%\u00bb background_color_gradient_start=\u00bb#1b6e2f\u00bb background_color_gradient_end=\u00bb#00448a\u00bb background_enable_image=\u00bboff\u00bb background_blend=\u00bbmultiply\u00bb width=\u00bb100%\u00bb max_width=\u00bb100%\u00bb min_height=\u00bb130px\u00bb min_height_tablet=\u00bb130px\u00bb min_height_phone=\u00bb130px\u00bb min_height_last_edited=\u00bbon|desktop\u00bb custom_margin=\u00bb0px|0px|0px|0px|false|false\u00bb custom_padding=\u00bb||||false|false\u00bb custom_css_main_element=\u00bbdisplay: flex;||flex-direction: column;||justify-content: center;\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb custom_css_main_element_tablet=\u00bb||\u00bb custom_css_main_element_phone=\u00bb||\u00bb custom_css_main_element_last_edited=\u00bbon|desktop\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.16″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb text_font=\u00bb|700|||||||\u00bb text_text_color=\u00bb#FFFFFF\u00bb text_font_size=\u00bb36px\u00bb text_line_height=\u00bb1.2em\u00bb text_orientation=\u00bbcenter\u00bb width=\u00bb60%\u00bb module_alignment=\u00bbcenter\u00bb text_font_size_tablet=\u00bb24px\u00bb text_font_size_phone=\u00bb24px\u00bb text_font_size_last_edited=\u00bbon|phone\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

ASISPA Formaci\u00f3n: Especializaci\u00f3n. Teleformaci\u00f3n<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb custom_margin=\u00bb||0px||false|false\u00bb custom_padding=\u00bb20px||20px||false|false\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text admin_label=\u00bbT\u00edtulo curso\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb text_font=\u00bb||||||||\u00bb text_text_color=\u00bb#FFFFFF\u00bb text_font_size=\u00bb40px\u00bb text_line_height=\u00bb45px\u00bb header_font=\u00bb||||||||\u00bb header_text_align=\u00bbcenter\u00bb header_text_color=\u00bb#00448A\u00bb header_line_height=\u00bb45px\u00bb width=\u00bb80%\u00bb width_tablet=\u00bb90%\u00bb width_phone=\u00bb90%\u00bb width_last_edited=\u00bbon|tablet\u00bb module_alignment=\u00bbcenter\u00bb custom_margin=\u00bb||0px||false|false\u00bb custom_padding=\u00bb||0px||false|false\u00bb text_font_size_tablet=\u00bb30px\u00bb text_font_size_phone=\u00bb25px\u00bb text_font_size_last_edited=\u00bbon|phone\u00bb text_line_height_tablet=\u00bb35px\u00bb text_line_height_phone=\u00bb30px\u00bb text_line_height_last_edited=\u00bbon|desktop\u00bb header_font_size_tablet=\u00bb30px\u00bb header_font_size_phone=\u00bb25px\u00bb header_font_size_last_edited=\u00bbon|phone\u00bb header_line_height_tablet=\u00bb35px\u00bb header_line_height_phone=\u00bb30px\u00bb header_line_height_last_edited=\u00bbon|desktop\u00bb global_colors_info=\u00bb{}\u00bb custom_css_main_element_last_edited=\u00bboff|desktop\u00bb]<\/p>\n

Excel avanzado<\/h1>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding_last_edited=\u00bboff|desktop\u00bb _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb background_enable_image=\u00bboff\u00bb background_blend=\u00bbmultiply\u00bb width=\u00bb100%\u00bb max_width=\u00bb100%\u00bb min_height=\u00bb130px\u00bb min_height_tablet=\u00bb\u00bb min_height_phone=\u00bb\u00bb min_height_last_edited=\u00bbon|desktop\u00bb custom_margin=\u00bb0px|0px|0px|0px|false|false\u00bb custom_padding=\u00bb0px||0px||false|false\u00bb custom_padding_tablet=\u00bb50px||50px||false|false\u00bb custom_padding_phone=\u00bb50px||50px||false|false\u00bb custom_css_main_element=\u00bbdisplay: flex;||flex-direction: column;||justify-content: center;\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb custom_css_main_element_last_edited=\u00bbon|desktop\u00bb custom_css_main_element_phone=\u00bb||\u00bb custom_css_main_element_tablet=\u00bb||\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_image src=\u00bbhttps:\/\/asispa.org\/formacion\/wp-content\/uploads\/2022\/12\/excel-avanzado-slide.jpg\u00bb alt=\u00bbcurso excel avanzado online\u00bb title_text=\u00bbcurso excel avanzado online\u00bb align=\u00bbcenter\u00bb force_fullwidth=\u00bbon\u00bb src_tablet=\u00bbhttps:\/\/asispa.org\/formacion\/wp-content\/uploads\/2022\/12\/excel-avanzado-peq.jpg\u00bb src_phone=\u00bbhttps:\/\/asispa.org\/formacion\/wp-content\/uploads\/2022\/12\/excel-avanzado-peq.jpg\u00bb src_last_edited=\u00bbon|phone\u00bb disabled_on=\u00bboff|off|off\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb height_tablet=\u00bb\u00bb height_phone=\u00bb\u00bb height_last_edited=\u00bbon|phone\u00bb custom_margin=\u00bb||||false|false\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb3_5,2_5″ _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb background_color=\u00bbRGBA(255,255,255,0)\u00bb width_tablet=\u00bb90%\u00bb width_phone=\u00bb90%\u00bb width_last_edited=\u00bbon|tablet\u00bb custom_margin=\u00bb50px||50px||false|false\u00bb custom_margin_tablet=\u00bb10px||40px||false|false\u00bb custom_margin_phone=\u00bb0px||20px||false|false\u00bb custom_margin_last_edited=\u00bbon|phone\u00bb custom_padding=\u00bb0px|0px|0px|0px|false|false\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb3_5″ module_class=\u00bbcolumna1-infoppal\u00bb _builder_version=\u00bb4.16″ _module_preset=\u00bbdefault\u00bb background_enable_color=\u00bboff\u00bb custom_padding=\u00bb30px||||false|false\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text module_class=\u00bbpuntos-destacados\u00bb _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Convocatoria abierta<\/p>\n

[\/et_pb_text][et_pb_text module_class=\u00bbpuntos-destacados\u00bb _builder_version=\u00bb4.17.3″ _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Modalidad:\u00a0
Online<\/p>\n

[\/et_pb_text][et_pb_text module_class=\u00bbpuntos-destacados\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Horas:
20 h<\/p>\n

[\/et_pb_text][et_pb_text module_class=\u00bbtexto-intro-producto\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

El objetivo del curso de Excel avanzado es aprender la aplicaci\u00f3n y dise\u00f1o de funciones avanzadas de Excel, el trabajo con datos externos e interconexi\u00f3n de Excel y Access. \u00a1Ap\u00fantate!<\/p>\n

[\/et_pb_text][et_pb_accordion open_toggle_text_color=\u00bb#FFFFFF\u00bb open_toggle_background_color=\u00bb#f1f1f1″ closed_toggle_background_color=\u00bb#f1f1f1″ icon_color=\u00bb#00448A\u00bb use_icon_font_size=\u00bbon\u00bb icon_font_size=\u00bb28px\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb toggle_text_color=\u00bb#3C3C3C\u00bb toggle_level=\u00bbh2″ toggle_font_size=\u00bb21px\u00bb background_color=\u00bbRGBA(255,255,255,0)\u00bb border_width_all=\u00bb0px\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_accordion_item title=\u00bbContenido del curso\u00bb open=\u00bbon\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

1. FUNCIONES.<\/strong>
1.1. Anidar funciones.<\/p>\n

2. BASES DE DATOS.<\/strong>
2.1. Filtros avanzados.
2.2. Validaci\u00f3n de datos.
2.3. Depurar bases de datos: valores \u00fanicos<\/p>\n

3. FORMULARIOS: BOTONES DE FORMULARIOS.<\/strong><\/p>\n

4. VISTAS.<\/strong>
4.1. Agrupar y desagrupar.
4.2. Autoesquema.<\/p>\n

5. ESTRUCTURAS DE CONTROL.<\/strong>
5.1. Dominio de tablas din\u00e1micas.
5.2. Consolidaci\u00f3n de datos.<\/p>\n

6. AN\u00c1LISIS DE DATOS.<\/strong>
6.1. Buscar objetivo.
6.2. Escenarios.
6.3. Tablas de una y dos variables.<\/p>\n

7. SOLVER: PLANTILLAS.<\/strong><\/p>\n

8. MACROS.<\/strong>
8.1. Grabaci\u00f3n de macros. Creaci\u00f3n de macros.
8.2. Reproducci\u00f3n de macros.
8.3. Eliminaci\u00f3n de macros.
8.4. Crear iconos y botones que ejecuten macros.
8.5. Seguridad de macros.<\/p>\n

9. OBTENCI\u00d3N DE DATOS EXTERNOS.<\/strong>
9.1. Desde Access
9.2. Desde texto.
9.3. Otras posibilidades.
9.4. Conexi\u00f3n con Access: Importaci\u00f3n. Vinculaci\u00f3n.<\/p>\n

10. RANGOS.<\/strong>
10.1. Nombres.
10.2. Modificar rangos.
10.3. Quitar duplicados.<\/p>\n

11. INSERCI\u00d3N DE OBJETOS.<\/strong><\/p>\n

[\/et_pb_accordion_item][et_pb_accordion_item title=\u00bbCompetencias\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb open=\u00bboff\u00bb]<\/p>\n

Inform\u00e1tica y comunicaciones.<\/p>\n

[\/et_pb_accordion_item][et_pb_accordion_item title=\u00bbCaracter\u00edsticas del curso\u00bb _builder_version=\u00bb4.19.0″ _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb open=\u00bboff\u00bb]<\/p>\n