Sistemas+aplicados

=** SYLLABUS ** = =** [|TECNOLOGIA APLICADA]  ** = = =

**ACTIVIDAD NÚMERO UNO**
==** ******************************************************** ** ==

** A. LECTURAS PREVIAS **
===** [|Guia_Generalidades_de_Excel[1]] ** === ===** [|Guia_de_Formulas] ** === ===** [|Guia_Referencias_Relativas_y_Absolutas] ** ===

** B. EJEMPLO Y ACTIVIDAD A REALIZAR **
===** [|EJEMPLO REFERENCIAS] ** ===

** A. LECTURAS PREVIAS Y ACTIVIDADES HA DESARROLLAR **
===** [|Guia_Formatos_y_Formatos_condicionales[1]] ** ===

** [] **
===**Actividad de Ordenar y Filtrar [|claseordenyfiltrossub] ** ===

**ACTIVIDAD NÚMERO TRES**
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** TEMA: Tablas Dinámicas y Funciones de Texto ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDAD A DESARROLLAR ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [] ** == <span style="background-color: #ffffff; display: block; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS **
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|Guia_Funciones_LOGICAS]  ** ==

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** B. ACTIVIDAD A DESARROLLAR **
=<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** [|tarealogicas]  ** = =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ****************************************************************************** ** = =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ACTIVIDAD NÚMERO CINCO ** = ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** TEMA Funciones Anidadas (SI- Y – O – Suma – Promedio) ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDAD A DESARROLLAR ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|FUNCIONES ANIDADAS] ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** *************************************************************************************** ** == =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ACTIVIDAD NÚMERO SEIS ** =

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** TEMA: Funciones Estadísticas **
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDADES A DESARROLLAR ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|Guia_Funciones_Estadisticas]  ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|CONCEPTO DE MODA. MEDIANA Y PROMEDIO]  ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|Taller de Estadisticas]  ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** ********************************************************************************* ** == =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ACTIVIDAD NÚMERO SIETE ** =

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** TEMA: Funciones BuscarV **
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDADES A DESARROLLAR ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|FUNCIÓN DE BUSQUEDA]  ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|TALLER FUNCIONES DE BUSQUEDA]  ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** ********************************************************************************* ** == =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ACTIVIDAD NÚMERO OCHO ** = =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** TEMA:Formularios ** = ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDADES A DESARROLLAR ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [|GUIA DE FORMULARIOS]  ** == ==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** ********************************************************************************* ** == =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ACTIVIDAD NÚMERO NUEVE ** =

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** TEMA:Formularios y Macros **
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDADES A DESARROLLAR ** ==

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [] ** ==

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** [] ** ==

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;"> ** [|GUIA FORMULARIOS CON MACROS] ** ==

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** ********************************************************************************************************* ** == =<span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** ACTIVIDAD NÚMERO DIEZ ** =

<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** TEMA: Ejercicios con Macros **
==<span style="background-color: #ffffff; color: #6f7a33; font-family: 'Helvetica Neue',Arial,Helvetica,Geneva,sans-serif; font-size: 24px; text-align: left;">** A. LECTURAS PREVIAS Y ACTIVIDADES A DESARROLLAR ** == <span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** Crear las siguientes macros teniendo en cuenta la información de excel de la parte final. ** <span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** 1. Crear una macro que ordene de forma Ascendente los apellidos ** <span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** 2. Crear una macro que ordene de forma Descendente los nombres ** <span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** 3. Crear una Macro en donde muestre un formato un condicional entre 23.000 y 116.000 de color Rojo y los menores de 22.999 de color verde ** <span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;">** 4. Asignarle botón a cada una de las macros creadas ** <span style="background-color: #ffffff; font-family: Georgia,'Times New Roman',Times,serif; text-align: left;"> ** [|claseordenyfiltrossub] **