Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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?
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
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: First Things First|
A little bit of an introduction.
Navigating Udemy Course InterfacePreview
While you are getting settled: some tips, so you get the maximum benefit from the course.
|Section 2: Import Data Into Excel|
Here we look at some issues when we import data into Excel. Simple things, but really important.
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|
Here we see a common scenario that many people encounter. We will solve the problem in the next lecture.
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|
Here we define the problem of insufficient data in our list. We will solve this problem in the next lectures.
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.
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|
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.
Here we solve this common problem creatively.
|Section 6: Cleaning Your Data Set|
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.
In this lecture you will learn how to clean your data in Excel and prepare it for successful use quickly and effortlessly.
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.
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|
In this lecture we learn about the necessity to combine things into a single cell.
Concatenation Lecture 1
In this lecture we continue learning different things about concatenation.
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.
Here you will learn how amazingly easy it is to solve the problem of "lost leading zeros".
|Section 8: Parsing Text With Formulas|
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.
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|
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.
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|
|Section 11: Practical Real-World Problem Solving|
Text-to-columns - Invisible Character
|Section 12: See you soon|
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
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.