
A little bit of an introduction.
Explore the Eudemus course interface to access profiles, support, notifications, sharing, discussions, announcements, and downloadable lecture materials, while optimizing high-definition video playback and note-taking for every lecture.
While you are getting settled: some tips, so you get the maximum benefit from the course.
Please download and unzip the exercise files.
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.
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.
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.
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.
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.
In this lecture we learn about the necessity to combine things into a single cell.
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".
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.
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.
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…
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!