MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Data Manipulation In Excel: Save 90% Of Your Time At Work!

Course Summary

Learn data manipulation in Microsoft Excel. Get tips and tricks and the best practices to prepare data for analysis.

  • +

    Course Syllabus

    • First Things First
      • Welcome!
      • Learning Tips
    • Import Data Into Excel
      • Issues When Importing Data
      • Importing Data From A CSV File - The Right Way
    • How To Separate Data In Excel
      • Problem: Invoice Code - Things Are Together That Should Be Separate
      • Parsing Invoice Code Using Text-To-Columns
    • Appending Data With VLOOKUP
      • Goal: Add Names To The List
      • Review Of VLOOKUP Function
      • Add Names Using VLOOKUP Lecture
    • Extracting Data From A Cell
      • Goal: Separate Full Names Into Separate Colunns
      • Separate Names - Lecture
    • Cleaning Your Data Set
      • Goal: Cleaning Data
      • Cleaning Data - Lecture
      • Goal: Fill Blank Cells With Values Above
      • Filling Blank Cells With The Values Above - Solution
    • Putting Things Together
      • Goal - Combine Data Into A Single Cell
      • Concatenation Lecture 1
      • Concatenation Lecture 2
      • Goal - Add Leading Zeros
      • Adding Leading Zeros - Solution Lecture
    • Parsing Text With Formulas
      • Goal - Parse Text With Formulas
      • Parsing Text With Formulas - Lecture
    • Fixing Dates In Excel
      • Goal - Parse And Fix Dates
      • Parsing Dates - Lecture
    • See you soon
      • Closing Remarks

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top