Excel Tutorial: Excel de manipulación de datos: Master Class | Skillfeed
Skillfeed will be shutdown on September 30. Please view additional details here.

Excel de manipulación de datos: Master Class

  • Students: 14
  • Calificación:
    (2 calificaciones)
 

Videos Duración
Capítulo 1: Antes de comenzar con la manipulación de datos
View-play Welcome 2 min
View-play Learning Process 3 min
Capítulo 2: Importación de datos en Excel
View-play Import Data In Excel Problem Definition 5 min
View-play How To Import Data Into Excel - Solution Lecture 9 min
Capítulo 3: Cómo separar datos Con Texto a Columnas
View-play Separating Data Problem Definition 2 min
View-play Using Text-To-Columns 6 min
Capítulo 4: Al añadir la función de datos Con BUSCARV
View-play Need For VLOOKUP Problem Definition 2 min
View-play VLOOKUP Function Tutorial 9 min
View-play Adding Data With VLOOKUP Function 7 min
Capítulo 5: Cómo extraer datos de un celular
View-play Separating Names - Problem Definition 3 min
View-play Separating Names - Solution Lecture 13 min
Capítulo 6: Cómo limpiar un conjunto de datos de Excel
View-play Cleaning Data In Excel - Problem Definition 2 min
View-play Cleaning Data In Excel - Solution Lecture 7 min
View-play Fill Blank Cells With Values Above - Problem Definition 2 min
View-play Fill Blank Cells With Values Above - Solution Lecture 7 min
Capítulo 7: Concatenar datos en Excel
View-play Concatenate - Problem Definition 2 min
View-play Concatenate - Solution Lecture 6 min
View-play Concatenating Inconsistent Data Sets 4 min
View-play-active Lost Leading Zeros - Problem Definition 2 min
View-play Lost Leading Zeros - Solution Lecture 8 min
Capítulo 8: Cómo analizar datos con fórmulas
View-play Parsing Text With Formulas - Problem Definition 2 min
View-play Parsing Text With Formulas - Solution Lecture 18 min
Capítulo 9: Solución de problemas con las fechas
View-play Parsing And Fixing Dates - Problem Definition 2 min
View-play Parsing And Fixing Dates - Solution Lecture 13 min
Capítulo 10: Palabras de clausura
View-play Closing Remarks 1 min
Descripción

What are the best ways to manipulate data in Excel? How can I change case in Excel? How to use Text-To-Columns? Can I separate data in Excel? How can I combine data in Excel? Answers to these questions are inside! After this course you will not only be able to do all that, but also will know how to import data in Excel the right way, and prepare data for analysis. You will be proficient with such Excel functions, for example VLOOKUP, IF, LEFT, RIGHT, MID, DATE. This course will save you time!

Total de lecciones: 25
Duración: 2 hr 2 min
Tema: Negocios
Idioma: English
Software: Excel
Nivel: Intermedio
Palabras clave:
Publicado: 09/29/14
Archivos de proyecto:
Acerca del Instructor
Large_p1090179__2_

Independent corporate trainer, coach, and consultant with over 10 years of experience. He assists individuals, groups and organizations in increasing their effectiveness through executive coaching, consultations and workshops. He supports his clients in acquiring new skills, facilitating change, increasing productivity and improving quality. He has successfully conducted workshops on such topics as: Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. He is skilled at both general business skills. He has also been conducting software training to people from all walks of life and every skill level. In his work, Mr. Ovchinnikov uses a blend of accelerated learning techniques and the latest cognitive training methods. He teaches his clients how to effectively use software, build teams, manage and resolve conflict, introduce change, communicate effectively, train others, manage time and stress, make presentations, assert themselves and create winning customer service. His coaching and workshops help his customers bring to the next level their skills of leadership, communication, creativity, supervision, strategic thinking, project management and decision-making.