Excel Tutorial: Excel Data Manipulation: Master Class | Skillfeed
Skillfeed will be shutdown on September 30. Please view additional details here.

Excel Data Manipulation: Master Class

  • Students: 14
  • Bewertung:
    (2 Bewertungen)
 

Videos Dauer
Kapitel 1: Bevor wir mit Data Manipulation
View-play Welcome 2 Min.
View-play Learning Process 3 Min.
Kapitel 2: Importieren von Daten in Excel
View-play Import Data In Excel Problem Definition 5 Min.
View-play How To Import Data Into Excel - Solution Lecture 9 Min.
Kapitel 3: Wie man Daten Trennen Mit Text-To-Spalten
View-play Separating Data Problem Definition 2 Min.
View-play Using Text-To-Columns 6 Min.
Kapitel 4: Das Anhängen von Daten mit SVERWEIS-Funktion
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.
Kapitel 5: Wie man Daten von einem Zellextrakt
View-play Separating Names - Problem Definition 3 Min.
View-play Separating Names - Solution Lecture 13 Min.
Kapitel 6: Wie man eine Excel Data Set reinigen
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.
Kapitel 7: Verknüpfen von Daten in 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 Lost Leading Zeros - Problem Definition 2 Min.
View-play Lost Leading Zeros - Solution Lecture 8 Min.
Kapitel 8: Wie man Daten analysieren Mit Formeln
View-play-active Parsing Text With Formulas - Problem Definition 2 Min.
View-play Parsing Text With Formulas - Solution Lecture 18 Min.
Kapitel 9: Beseitigen von Problemen mit Daten
View-play Parsing And Fixing Dates - Problem Definition 2 Min.
View-play Parsing And Fixing Dates - Solution Lecture 13 Min.
Kapitel 10: Closing Remarks
View-play Closing Remarks 1 Min.
Übersicht

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!

Lerneinheiten gesamt: 25
Dauer: 2 Std. 2 Min.
Thema: Unternehmen
Sprache: Englisch
Software: Excel
Stufe: Mittelstufe
Schlagwörter:
Freigegeben: 09/29/14
Projektdateien:
Über den Kursleiter
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.