Data Manipulation in Excel: save up to 90% of Your Time!
4.7 (21 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.
192 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Manipulation in Excel: save up to 90% of Your Time! to your Wishlist.

Add to Wishlist

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

And never miss another deadline.
4.7 (21 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.
192 students enrolled
Created by Igor Ovchinnikov
Last updated 9/2016
English
Learn Fest Sale
Current price: $10 Original price: $65 Discount: 85% off
14 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Basic foundation knowledge of Excel.
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!

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 29 Lectures Collapse All 29 Lectures 02:29:30
+
First Things First
3 Lectures 10:38

A little bit of an introduction.

Preview 01:51


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

Preview 02:50
+
Import Data Into Excel
2 Lectures 12:59

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

Preview 04:05

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

Preview 08:54
+
How To Separate Data In Excel
2 Lectures 06:47

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

Preview 01:34

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

Parsing Invoice Code Using Text-To-Columns
05:13
+
Appending Data With VLOOKUP
3 Lectures 16:03

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

Preview 01:33

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.

Review Of VLOOKUP Function
08:03

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

Add Names Using VLOOKUP Lecture
06:27
+
Extracting Data From A Cell
2 Lectures 14:25

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.

Preview 02:02

Here we solve this common problem creatively.

Separate Names - Lecture
12:23
+
Cleaning Your Data Set
4 Lectures 15:39

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.

Preview 01:27

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

Cleaning Data - Lecture
06:37

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.

Preview 01:31

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

Filling Blank Cells With The Values Above - Solution
06:04
+
Putting Things Together
5 Lectures 18:12

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

Preview 01:08

Concatenation Lecture 1
05:00

In this lecture we continue learning different things about concatenation.

Concatenation Lecture 2
03:16

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.

Preview 01:28

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

Adding Leading Zeros - Solution Lecture
07:20
+
Parsing Text With Formulas
2 Lectures 18:21

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.

Preview 01:09

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

Parsing Text With Formulas - Lecture
17:12
+
Fixing Dates In Excel
2 Lectures 13:59

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.

Preview 01:34

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

Parsing Dates - Lecture
12:25
+
Filtering Data
1 Lecture 16:22
Advanced Filter
16:22
2 More Sections
About the Instructor
Igor Ovchinnikov
4.5 Average rating
318 Reviews
5,289 Students
10 Courses
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.