Data Manipulation In Excel: Save Up To 90% Of Your Time!

Posted By: ELK1nG

Data Manipulation In Excel: Save Up To 90% Of Your Time!
Last updated 9/2016
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.25 GB | Duration: 2h 30m

And never miss another deadline.

What you'll 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.
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!

Overview

Section 1: First Things First

Lecture 1 Welcome!

Lecture 2 Navigating Udemy Course Interface

Lecture 3 Learning Tips

Section 2: Import Data Into Excel

Lecture 4 Issues When Importing Data

Lecture 5 Importing Data From A CSV File - The Right Way

Section 3: How To Separate Data In Excel

Lecture 6 Problem: Invoice Code - Things Are Together That Should Be Separate

Lecture 7 Parsing Invoice Code Using Text-To-Columns

Section 4: Appending Data With VLOOKUP

Lecture 8 Goal: Add Names To The List

Lecture 9 Review Of VLOOKUP Function

Lecture 10 Add Names Using VLOOKUP Lecture

Section 5: Extracting Data From A Cell

Lecture 11 Goal: Separate Full Names Into Separate Columns

Lecture 12 Separate Names - Lecture

Section 6: Cleaning Your Data Set

Lecture 13 Goal: Cleaning Data

Lecture 14 Cleaning Data - Lecture

Lecture 15 Goal: Fill Blank Cells With Values Above

Lecture 16 Filling Blank Cells With The Values Above - Solution

Section 7: Putting Things Together

Lecture 17 Goal - Combine Data Into A Single Cell

Lecture 18 Concatenation Lecture 1

Lecture 19 Concatenation Lecture 2

Lecture 20 Goal - Add Leading Zeros

Lecture 21 Adding Leading Zeros - Solution Lecture

Section 8: Parsing Text With Formulas

Lecture 22 Goal - Parse Text With Formulas

Lecture 23 Parsing Text With Formulas - Lecture

Section 9: Fixing Dates In Excel

Lecture 24 Goal - Parse And Fix Dates

Lecture 25 Parsing Dates - Lecture

Section 10: Filtering Data

Lecture 26 Advanced Filter

Section 11: Practical Real-World Problem Solving

Lecture 27 Text-to-columns - Invisible Character

Section 12: See you soon

Lecture 28 Closing Remarks

Lecture 29 Bonus Lecture: Special Offers

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.