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

Learn data manipulation in Microsoft Excel so you can do your work fast.
4.6 (13 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.
130 students enrolled
$19
$65
71% off
Take This Course
  • Lectures 29
  • Length 2.5 hours
  • 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

I am SO EXCITED to be bringing you this Excel training course! 

Do you spend a lot of time inside Excel at work? Does it feel like it’s too much time?

IMAGINE how it will feel to save up to 90% of the time you spend in Excel. What if you were able to use Excel as a tool to REACH A GOAL and GET WHAT YOU WANT, rather than a time-wasting computer game that you have to play all day. In this course, you’ll focus on using EXCEL AS A TOOL. A good tool helps you with your work. You don’t fall in love with a tool, you don’t sleep with it, you want to use it as a means to an end - not the end itself. You want to ACHIEVE RESULTS - right?

Let me tell you my story.

I worked for one of the big consulting firms when I started using Excel years ago, (in 1995 to be precise) and it quickly sucked in all of my free time. I was staring at spreadsheets all day long, even on weekends. It was PAINFUL. At some point I realized that there should be a better way. I knew that Excel was a POWERFUL TOOL, but I was not using its power to my ADVANTAGE. That’s when I started to collect various TIPS on how to DO THINGS FAST IN EXCEL. It helped me save an incredible amount of time. Now I’d like to offer you my techniques in this concise, STRAIGHT-TO-THE-POINT training package.

When you TAKE THIS COURSE, you’ll learn some of my my tips that I discovered over the years that helped me SIGNIFICANTLY IMPROVE my skills and save an INCREDIBLE amount of time when working with data in Excel. In this course I’ll teach you my favorite best practices how to manipulate and TRANSFORM data in Excel so you can do your work more EFFICIENTLY and achieve results FAST. 

My goal for you is that once you TAKE AND COMPLETE THIS COURSE, you’ll feel that finally you are using Excel as a tool that really helps you DO YOU JOB WELL. You’ll feel that you are in control of Excel and not the other way around. It’s a GREAT FEELING, let me tell you.

So, I invite you to JOIN THE COURSE NOW. Why not? After all, there is no risk with the 30-day money-back guarantee. 

Just click on the “TAKE THIS COURSE” button and I’ll SEE YOU INSIDE!

What are the requirements?

  • Basic foundation knowledge of Excel.

What am I going to get from this course?

  • Learn to save time when working with data in Excel.
  • Learn to manipulate and transform data in Excel fast.
  • Develop your creativity in using Excel formulas to fix and manipulate data.
  • Learn how to solve real-life data problems using Excel.
  • Discover tips and tricks on how to quickly prepare 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!

Hi, I am Igor Ovchinnikov.

I am here to teach you. My focus is to help you improve your skills, so you can do you job well. You probably want to learn fast and get results quickly? You might even remember a time when you really enjoyed learning something? Well, when you buy my courses, that’s exactly what you get. I do my best to serve you with easy learning experience, fast results, and even some fun.

Now, a bit about me. I live in San Francisco and do corporate training. I am the go-to guy when companies need training for their employees. 

I’ve done it for many organizations such as 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. If my training was good for them, perhaps it will be good for you.

I hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

As for my on-line courses here, you can see all of them below on this page. Just click on the ones you are interested and enroll.

Ready to start learning?
Take This Course