Excel: Data cleaning and analysis techniques

Learn Excel functions to do data cleaning, data manipulation and analysis using the TEXT functions

4.48 (3424 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
8,798
students
1 hour
content
Mar 2024
last update
$59.99
regular price

What you will learn

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

Description

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.

Content

Start Here

Introduction: what will we learn in this course?
Download the excel template for this course
Illustration 1: Introduction to the illustration
Illustration 1: Understanding the LEN, FIND, MID and CONCATENATE functions
Illustration 2: Understanding the TRIM and FIND function
Illustration 2: Understanding the LEFT and MID function
Illustration 3: Introduction
Illustration 3: Understanding the SEARCH function
Illustration 3: Understanding the IFERROR function
Illustration 3: Understanding the IF function
Recap of what we learnt in this course
Practice Assignment : DIFFICULTY LEVEL - MEDIUM
SOLUTION TO PRACTICE ASSIGNMENT
Please provide us your valuable feedback

Screenshots

Excel: Data cleaning and analysis techniques - Screenshot_01Excel: Data cleaning and analysis techniques - Screenshot_02Excel: Data cleaning and analysis techniques - Screenshot_03Excel: Data cleaning and analysis techniques - Screenshot_04

Reviews

Stevens
November 12, 2023
Thank you so much for this engaging course guys. I learned a lot on text functions and also why some of the functions I was using were not effective. For anyone who wants to do this course, I encourage you to do that today.
Jared
October 2, 2023
Course content was easy to use and flowed very well. It made learning the functions taught in the lessons quick!
Velmurugan
October 1, 2023
Yes, The Course definitely met and exceeded my expectations as I am working on Data analysis projects and these functions of Excel explained clearly helps clean up the data well for further analysis, Will definitely implement many functions that I now learned in my future projects, Thank you Team!
Lelethu
August 17, 2023
This was a really good course which gave a step-by-step on how to use your TEXT functions to enable you to carry out data analysis in an effective manner.
Adesh
July 24, 2023
The tutor was engaging, he was giving on point notes, I liked the course and I get to learn many useful things, I reccomend this course.
Yiğit
July 3, 2023
değildi çok hızlı ilerliyor ayrıca excel dil değiştirmeden bahsetse iyi olurdu. onun dışında excel versiyonlarına göre değişen formüllerden de bahsetmemiş kendim arayıp bulmak zorunda kaldım...
Gregory
June 19, 2023
I thought this was a good class and that I learned a lot, but some functions for the practice assignment were never addressed and I feel as though they were a little too advanced for this course. I would mention in the beginning that you should already know how to use VLOOKUP and cross reference using multiple sheets. Otherwise a fantastic course!
Christopher
June 13, 2023
The course has been good so far. My only complaint is the instructor can be hard to understand at times. His accent is very thick and sometimes when he is talking about certain commands in excel, his Bs, Cs, and Vs, all sound exactly the same.
Hailey
June 8, 2023
The excel function he just taught me was very cool. I now know how to merge formulas with each other!
Angel
June 6, 2023
The practice assignment involved using a function not covered in this module which could trick many into not being able to solve the problem without using the solution.
Ricki
February 20, 2023
This taught me a lot of functions I knew were possible but had no one to train me on. This is great for when I get a document that is not formatted correctly
Darshan
January 6, 2023
A list of formulas not covered in this module but helpful in data cleaning and analysis would have been great to see or be shared in this module. Thanks!
Chandler
December 21, 2022
I got to touch up the LEFT/MID/RIGHT functions and see what high level CONCATENATE functions look like. The practice assignment was challenging, but I now know what to improve on. Thank you!
Andy
December 19, 2022
i liked how the steps were broken down individually. made it much easier to understand the functions as a whole
Lauren
December 17, 2022
Professor seemed very knowledgeable and the steps were easy to follow. Did a very good job explaining the whats and whys!

Charts

Price

Excel: Data cleaning and analysis techniques - Price chart

Rating

Excel: Data cleaning and analysis techniques - Ratings chart

Enrollment distribution

Excel: Data cleaning and analysis techniques - Distribution chart
1210834
udemy ID
5/10/2017
course created date
11/8/2020
course indexed date
Bot
course submited by