4.3 out of 5
4.3
16 reviews on Udemy

Excel: Data cleaning and analysis using TEXT functions

Learn [ excel functions to do data cleaning, data manipulation and analysis using the TEXT functions
Instructor:
Ashish Agarwal
167 students enrolled
English [Auto-generated]
Complete overview of Microsoft Excel interface
Data analysis in Excel
Data manipulation in Excel
Data cleaning in Excel
Application of TEXT functions in data analysis

Welcome to very simple yet powerful Excel: Data cleaning and analysis using TEXT functions course

We are glad to meet you. If only we could shake hands! 


Are you wondering how is this course going to be useful to you? 

Hey, did you watch the promo video? If not, please do. 

If you are looking to learn basic TEXT functions in Excel, this course will prepare you for the job.

Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today’s world.

So your job will also possibly require you to do analysis on large heaps of data.

Our course does exactly that – we make you job ready for your prospective project / daily work.


What makes our course different from others?

Our course content is unique – you learn exactly what you are required to do in your daily work.

You get 1 hours of crisp synthesized practical real life illustrations of all concepts.

You will be carrying out the real life illustrations along with the instructor.

Same set up as the instructor. All illustration spreadsheets are shared.

It’s almost like as if somebody is guiding you in person to carry out the various analysis.

You are going to love our instructor’s teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course.

Our support team responds to any course queries within 24 hours of your request. 

And of course, the price is competitive. 

What will you learn in this course?

Data cleaning and analysis in $Excel using TEXT functions

You can watch the FREE course previews in the CURRICULUM section.

Read through the entire CURRICULUM section if you can.

All modules with details of lectures are provided.

What  next?

Well, we sincerely hope to see you inside the course.

We wish you well and good luck.

Still confused? Don’t hesitate to reach out.

Start Here

1
Introduction: what will we learn in this course?
2
Download the excel template for this course
3
Illustration 1: Introduction to the illustration
4
Illustration 1: Understanding the LEN, FIND, MID and CONCATENATE functions
5
Illustration 2: Understanding the TRIM and FIND function
6
Illustration 2: Understanding the LEFT and MID function
7
Illustration 3: Introduction
8
Illustration 3: Understanding the SEARCH function
9
Illustration 3: Understanding the IFERROR function
10
Illustration 3: Understanding the IF function
11
Recap of what we learnt in this course
12
Practice Assignment : DIFFICULTY LEVEL - MEDIUM
13
SOLUTION TO PRACTICE ASSIGNMENT
14
Please provide us your valuable feedback
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
16 Ratings

Detailed Rating

Stars 5
6
Stars 4
6
Stars 3
3
Stars 2
1
Stars 1
0
0e54b32a883ac49f0f9efa2dfe1941d0
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion