
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
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 |
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 |
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 |
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 |
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 |
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 |
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 |