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

And never miss another deadline.
4.7 (18 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.
146 students enrolled
$65
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

DO YOU HATE WASTING TIME IN EXCEL? 

Ever missed deadlines because of spreadsheets?

This user-friendly and easy-to-follow course is… 

YOUR SOLUTION TO THIS PROBLEM

When you enroll, I’ll show you exactly how to slash huge amounts of time that most people routinely waste.

Imagine, how it will feel when you finally… 

STOP SQUANDERING YOUR VALUABLE EXCEL TIME

and focus on what’s important instead?

Just like thousands of my students before, you may wonder if its a good idea for you to take this course?

Well…

  • If you hate wasting time as much as I do, you definitely want to take this course.
  • You want to enroll in it, If you’ve ever missed deadlines because of Excel.
  • If you work with gigantic data sets, I passionately recommend that you take this course - you are gonna love what you are just about to learn.
  • This course is for you also if you enjoy being more productive and get things done faster. 
  • And if you want to supercharge your most essential Excel skills - by all means, grab this course.
  • Because, this course is designed to instantly bump you up to the higher bracket than most people - skill wise.
  • So you can finally begin using Excel as a tool to reach your goals and get what you want, rather than as a time-wasting, productivity-killing machine. 

As a result of what you are about to learn, you’ll skyrocket your results immediately.

A great tool helps you… 

GET THINGS DONE FAST

You don’t want to fall in love with Excel, you don’t sleep with it, you want to use it as a means to an end - if you like

In fact, you want to 

ACHIEVE RESULTS. 

That’s exactly why you want to squeeze every drop of productivity out of it.

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 full 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.

In this course, I’ll reveal to you the hottest tips and short cuts that I discovered over the years that helped me significantly improve my skills and save insane amounts of time when working with data in Excel. 

In this course i’ll teach you my favorite techniques 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.

Who 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
00:49

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Helping you learn fast, so you can do your job well.

Hi, I am Igor Ovchinnikov.

Welcome to my profile page. This is where you normally get to learn about me and read something like this:

“Igor Ovchinnikov is a corporate trainer with over 10 years of experience. He lives in San Francisco and provides excellent training-delivery services to clients all over the Bay Area. He has delivered training for 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. 

Mr. Ovchinnikov holds an MBA from the Ohio State University.”

Well, frankly, I always have some serious cognitive dissonance whenever I have to write about myself in the third person like this. It’s a bit silly - don’t you agree? So, enough of this out-of-body talk!

First of all, you probably don’t care about me that much. Second, you are probably more interested in why you should buy my courses and what’s in them for you? You may be more interested in how my teaching is different compared to the other great instructors out there?

I have to confess, it is something I've been wondering about too. You know, when someone asks you what you are good at, it’s tough to answer that. Especially, because when you are really good at something, you don’t really perceive it as a big deal. Don’t you agree? Think of something you do really well. Now, do you really work hard on it, or does it come kind of naturally?

So, to answer this question to myself, I recently decided to ask my students. Most of the ones I polled are employees of just one organization where I teach - Stanford University, so the research sample may not be fully scientific. Anyway, I asked a few dozens of my students what they liked best about my teaching style. It was really surprising, that most of them told me that their favorite part was how clear things became after I explained it to them. One of them said literally: “You are a great explainer. It was so confusing before, and now I finally understand it!” 

I think, here’s what I can promise you when you enroll in my courses. I promise you clear explanations, so that things will be no longer confusing.

So, here’s my value proposition to you:

When you enroll in my courses and go through the material, you should expect clear explanations that will help you learn and build your skills fast, so you can succeed at your job. 

If that is the experience that you are interested in, simply enroll in my courses below.

Ready to start learning?
Take This Course