Data Manipulation in Excel: save up to 90% of Your Time!

Learn data manipulation in Microsoft Excel. Get tips and tricks and the best practices to prepare data for analysis.
4.6 (12 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
118 students enrolled
$30
Take This Course
  • Lectures 29
  • Contents Video: 2.5 hours
    Other: 1 min
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

Course Description

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? What to do when imported dates are not dates? I lost leading zeros in Excel! Answers to these questions are inside! When you enroll in this course and complete it, you will not only be able to do all that, but also will know how to import data in Excel the right way, how to prepare data for analysis, how to clean data in Excel. You will be proficient with useful Excel functions, for example VLOOKUP, IF, LEFT, RIGHT, MID, DATE.

In this Excel course, that provides carefully hand-picked most useful video-training material, you will quickly learn the best practices to work with lists of data in Excel. We will start by looking at the best practices in importing data and discuss the common mistakes that one can make when doing it. Next, you will learn to transform data in Excel in a quick, easy, and creative way. You will benefit by making yourself comfortable using Excel as a data manipulation tool. You will fix data, modify data, upend data, concatenate data and clean it using build-in Excel functionality. You will learn to use creatively various Excel functions, such as: VLOOKUP, IF, LEFT, RIGHT, MID, DATE and some others. You will become comfortable “massaging” your data in very useful and beneficial ways.

The Excel course is using a problem-solving approach. It is divided into several sections. Each section deals with a specific common problem that people encounter in Excel all the time. First, we define the problem and then work through a proven solution to fix it. When you work through the solutions offered by the course, you will quickly be improving your problem-solving skills and start coming up with solutions of your own. And that is the ideal learning, isn’t it? You just have fun working through common problems, and your expertise just happens on its own.

This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:

"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;

"Excel Conditional Formatting Master Class" where you can learn how to improve your spreadsheets using conditional formatting in Excel;

"Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering pivot tables data crunching skills;

"Microsoft Excel Charts Master Class" that builds your skills in creating your skills in Excel charts and graphs.

What are the requirements?

  • Basic foundation knowledge of Excel.

What am I going to get from this course?

  • Learn to manipulate data in Excel
  • Save time when doing Excel data manipulation
  • Learn how to use formulas to transform data in Excel
  • Learn how to solve real-life Excel problems
  • Discover tips on how to quickly prepare Excel data for analysis

What is the target audience?

  • Everyone looking for proven ways.
  • Everyone who has covered the basics.
  • Everyone who needs to work with lists of data in Excel.
  • Everyone who needs to solve problems creatively.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: First Things First
01:51

A little bit of an introduction.

Navigating Udemy Course Interface
Preview
05:57
02:50

While you are getting settled: some tips, so you get the maximum benefit from the course.

Section 2: Import Data Into Excel
04:05

Here we look at some issues when we import data into Excel. Simple things, but really important.

08:54

In this lecture we go through the right way of importing data into Excel, to prevent problem in the future.

Section 3: How To Separate Data In Excel
01:34

Here we see a common scenario that many people encounter. We will solve the problem in the next lecture.

05:13

Here we use Text-To-Columns -- the venerable old and very useful feature of Excel. Old, in this case is good.

Section 4: Appending Data With VLOOKUP
01:33

Here we define the problem of insufficient data in our list. We will solve this problem in the next lectures.

08:03

The solution to the problem that we defined in the previous lecture is in the VLOOKUP function. Here we review how it works and will become comfortable solving the problem at hand.

06:27

In this lecture you will solve the problem by using the VLOOKUP function and will become even more comfortable with this important Excel functionality.

Section 5: Extracting Data From A Cell
02:02

What if Text-To-Columns is not fully working for us? What if the data is not consistently separated? We define this problem in this video segment.

12:23

Here we solve this common problem creatively.

Section 6: Cleaning Your Data Set
01:27

Many people often encounter the problem that their data needs to be "cleaned" and manipulated before being used. We define this problem in this lecture.

06:37

In this lecture you will learn how to clean your data in Excel and prepare it for successful use quickly and effortlessly.

01:31

Here we will take a look at a very common situation that puzzled Excel users for quite awhile. We often receive data in outline format, and would prefer to have it in a transactional, or in a database format. You will recognized this problem as soon as you are done with this video. The solution is coming in the next segment.

06:04

Here you will learn the specific steps to solving the problem of outline formatted data and to filling blank cells.

Section 7: Putting Things Together
01:08

In this lecture we learn about the necessity to combine things into a single cell.

Concatenation Lecture 1
05:00
03:16

In this lecture we continue learning different things about concatenation.

01:28

Ah, leading zeros! Who has never lost them? Only someone who never used Excel. We look at the problem in this segment and will solve it in the next one.

07:20

Here you will learn how amazingly easy it is to solve the problem of "lost leading zeros".

Section 8: Parsing Text With Formulas
01:09

What can we do when Text-To-Columns is not an option at all? We need to get creative. Let's define the problem first before solving it in the next lecture.

17:12

Here we will look at ways to parse data using formulas. Very important skill to have for any serious Excel user.

Section 9: Fixing Dates In Excel
01:34

Excel can be weird. Sometimes dates are not dates. We saw that problem when importing data. How do we work with dates that are not recognized as dates by Excel? Here we look at a way. The solution comes in the next lecture.

12:25

Solve the problem of messed up dates. This lecture will dramatically reinforce some skills that you have already acquired in the previous lectures.

Section 10: Filtering Data
Advanced Filter
16:22
Section 11: Practical Real-World Problem Solving
Text-to-columns - Invisible Character
04:43
Section 12: See you soon
00:38

In order to know if you really progressed in anything, it is necessary to briefly look back before turning again to the future.

Bonus Lecture: Special Offers
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Learn It Your Way!

I love creating on-line courses. It has been my favorite pastime since 2013. I love the independent nature of this activity. There is so much to learn!

Independence is what I value most. I am an independent instructor – a free-lance instructor. My on-line courses are not the only thing that I do. I also teach in a classroom setting. My corporate clients hire me to conduct training for their employees. It is my main job: classroom and face-to-face training – as a free-lance of course. I have been in the training business for over 10 years.

I live in San Francisco and, naturally, most of my clients come from the Silicon Valley and from the Bay Area but not only from here. My corporate clients often ask me to travel to conduct training for them.

I have done training for many organizations for over 10 years. Among the more prominent are: Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others. There are too many to list all of them here.

I am also a faculty of the American Management Association and conduct many of their training seminars – both public and private, or on-site. When I am not creating my on-line courses, I teach for one of these, or other fine companies.

I teach a broad range of topics. Such as Software, Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. I do hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

Ready to start learning?
Take This Course