Excel Avanzado
Excel Avanzado
|
||||
Try Limited, Free Training:
Upgrade to Experience:
-
LinkedIn-ready certificates that verify your skills
-
Skill assessments
-
Unlocked courses & interactive content
-
Customizable content; create your own courses
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Tablas Dinámicas | Limited Free Learning | |||
| Crear Tablas Dinámicas | Click to start | Not Started | Not included | |
| Agregar Múltiples Campos de Tablas Dinámicas | Not included | Not Started | Not included | |
| Cambiar el Cálculo de una Tabla Dinámica | Not included | Not Started | Not included | |
| Agregar Campos Calculados | Not included | Not Started | Not included | |
| La Función IMPORTARDATOSDINAMICOS | Not included | Not Started | Not included | |
| Filtrar Tablas Dinámicas | Not included | Not Started | Not included | |
| Escalas de Tiempo | Not included | Not Started | Not included | |
| Diseño de Tabla Dinámica | Not included | Not Started | Not included | |
| Agrupar Valores | Not included | Not Started | Not included | |
| Actualizar una Tabla Dinámica | Not included | Not Started | Not included | |
| Formato a Tablas Dinámicas | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Gráficos Dinámicos | Limited Free Learning | |||
| Opciones de Gráficos Dinámicos | Not included | Not Started | Not included | |
| Estilos de Gráficos Dinámicos | Not included | Not Started | Not included | |
| Explorar Datos a Profundidad | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Errores de Fórmula | Limited Free Learning | |||
| Errores de Fórmula | Not included | Not Started | Not included | |
| La Ventana Inspección | Not included | Not Started | Not included | |
| Evaluar Fórmulas | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Formato Avanzado | Limited Free Learning | |||
| Personalizar el Formato Condicional | Not included | Not Started | Not included | |
| Formato Condicional con Fórmulas | Not included | Not Started | Not included | |
| Administrar Formato Condicional | Not included | Not Started | Not included | |
| Monedas y Formatos Internacionales | Not included | Not Started | Not included | |
| Opciones de Cuerpo y Encabezado | Not included | Not Started | Not included | |
| Formatos de Color | Not included | Not Started | Not included | |
| Temas Personalizados | Not included | Not Started | Not included | |
| Controles de Formulario | Not included | Not Started | Not included | |
| Guardar Plantillas de Formulario | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Fórmulas Avanzadas | Limited Free Learning | |||
| Función SI | Not included | Not Started | Not included | |
| Funciones SUMAR.SI, PROMEDIO.SI, y CONTAR.SI | Not included | Not Started | Not included | |
| Funciones Y, O, y NO | Not included | Not Started | Not included | |
| Funciones Anidadas | Not included | Not Started | Not included | |
| BUSCARV | Not included | Not Started | Not included | |
| BUSCARH | Not included | Not Started | Not included | |
| ÍNDICE y COINCIDIR | Not included | Not Started | Not included | |
| DERECHA, IZQUIERDA, y EXTRAE | Not included | Not Started | Not included | |
| MAYUSC, MINUSC, y NOMPROPIO | Not included | Not Started | Not included | |
| Opciones de Cálculo de Fórmulas | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Analizar Datos | Limited Free Learning | |||
| Buscar Objetivo | Not included | Not Started | Not included | |
| Administrador de Escenarios | Not included | Not Started | Not included | |
| Consolidar Datos | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Macros | Limited Free Learning | |||
| Habilitar Macros | Not included | Not Started | Not included | |
| Crear Macros | Not included | Not Started | Not included | |
| Modificar Macros | Not included | Not Started | Not included | |
| Copiar Macros | Not included | Not Started | Not included | |