Excel Tutorial: Excel 2013 Superhero Curso | Skillfeed
Skillfeed will be shutdown on September 30. Please view additional details here.

Excel 2013 Superhero Curso

  • Students: 10
  • Calificación:
    (0 calificaciones)
 

Videos Duración
Capítulo 1: Trabajando con Windows
View-play Freezing Panes 5 min
View-play Splitting Panes 5 min
View-play Displaying Multiple Workbooks on One screen 4 min
Capítulo 2: Clasificación y filtrado
View-play Sorting Lists 9 min
View-play Filtering Lists 12 min
View-play Sorting and Filtering by Cell Colour 5 min
Capítulo 3: Introducción a las Fórmulas
View-play Introduction to Writing Formulas 10 min
View-play Calculating Percentages 5 min
View-play Writing Functions 12 min
View-play The COUNTBLANK and COUNTA Functions 5 min
View-play COUNTIF and the Function Wizard 9 min
View-play Absolute Cell References in your Formulas 6 min
View-play Using Defined Names 8 min
Capítulo 4: Funciones Lógicas
View-play The IF Function 13 min
View-play Nesting Functions to Test Multiple Conditions 12 min
Capítulo 5: Funciones de búsqueda
View-play La función BUSCARV 14 min
View-play VLOOKUP for the Closest Match 7 min
View-play The HLOOKUP Function 6 min
View-play VLOOKUP with Nested MATCH Function 8 min
View-play Using the INDEX and MATCH Functions 11 min
View-play Handling the #N/A Error Message 9 min
Capítulo 6: Formato condicional
View-play Applying Conditional Formatting 10 min
View-play Using Icon Sets 6 min
View-play Managing Conditional Formatting Rules 6 min
View-play Formatting the Entire Row 7 min
Capítulo 7: Proteger y compartir un archivo
View-play Encrypting a File 3 min
View-play Applying Workbook Protection 5 min
View-play Protecting a Worksheet 10 min
View-play Sharing a Workbook 6 min
Capítulo 8: Entrada de datos Validando
View-play Validar el Texto Longitud 3 min
View-play La validación de las entradas Fecha 3 min
View-play Validar mediante una lista desplegable 5 min
View-play Crea tus propios mensajes de entrada y de error 6 min
View-play Crear Dependientes Listas Colocar abajo 7 min
Capítulo 9: Análisis de Datos
View-play Insertar filas Subtotal 8 min
View-play SUMIF Function 6 min
View-play SUMIFS and COUNTIFS 6 min
View-play SUBTOTAL Function 7 min
Capítulo 10: Trabajando con los Gráficos
View-play Gráficos recomendadas 6 min
View-play Create a Column Chart 10 min
View-play Create a Pie Chart 11 min
View-play Create a Combo Chart 8 min
View-play Chart Filters 4 min
View-play Create an Interactive Chart 15 min
View-play Utilizando Sparklines 6 min
Capítulo 11: Formateo de un rango como una tabla
View-play Format a Range as a Table 12 min
View-play Using Structured References in a Formula 4 min
View-play Convertir una mesa del fondo a un rango normal 3 min
Capítulo 12: Trabajar con tablas dinámicas
View-play Create a PivotTable 12 min
View-play Formatting Values and Changing the Values Function 5 min
View-play Clasificación tabla dinámica Campos 4 min
View-play Grouping PivotTable Fields 7 min
View-play Show Values as Percentage, Difference and Rank 6 min
View-play Filtering PivotTable Data 4 min
View-play Refreshing a PivotTable 6 min
View-play Create a PivotChart 4 min
View-play Using Slicers 8 min
View-play-active The New Timeline Slicer 4 min
Capítulo 13: Importación de datos en Excel
View-play From a Text File 7 min
View-play From a Website 10 min
View-play Desde una base de datos Access 5 min
Capítulo 14: Limpieza y preparación de datos
View-play Separating Text into Multiple Columns 6 min
View-play The CONCATENATE Function 5 min
View-play Extracting Text from a Cell 13 min
View-play MID and FIND Functions 8 min
View-play The VALUE Function 4 min
View-play El impresionante herramienta Relleno flash 9 min
Capítulo 15: Macros
View-play ¿Qué es una macro? 7 min
View-play Grabar una macro 8 min
View-play Assign a Macro to a Toolbar Button 6 min
View-play Customising the Ribbon 6 min
View-play Using Relative References in Macros 10 min
View-play Saving a Macro Enabled File 3 min
View-play Adding a Button to a Worksheet 4 min
View-play Editing Macro Code 12 min
Capítulo 16: Usando el modelo de datos interna
View-play Adding Tables to the Data Model 5 min
View-play Relating Tables in the Data Model 4 min
View-play Using the Data Model in a PivotTable 4 min
Descripción

Become an Excel superhero. Learn the skills to be able to handle any Excel problem. This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful dynamic and visually appealing spreadsheets. This course includes lessons on some of the new features in Excel 2013 including the IFNA function, the Timeline Slicer, Flash Fill and the internal data model. Use the files provided for practice.

Total de lecciones: 78
Duración: 8 hr 33 min
Tema: Negocios
Idioma: English
Software: Excel 2013
Nivel: Intermedio
Palabras clave:
Publicado: 12/03/14
Archivos de proyecto:
Acerca del Instructor
Large_me

Alan Murray is a Microsoft Office trainer and consultant. He has been training and consulting for the past 15 years for businesses around the world. He is the founder of Computergaga and regularly writes on the Computergaga blog to share tips and tutorials. Alan uses a fun and relaxed style of training that 'gets to the point', and uses real world practical examples uncovered from his experience of training and developing software for businesses.