Data cleaning in Excel

Data cleaning in Excel, available at $34.99, has an average rating of 3.85, with 25 lectures, based on 28 reviews, and has 109 subscribers.

You will learn about Excel: Data cleaning and analysis techniques Learn Excel functions to do data cleaning, data manipulation and analysis using the TEXT functions Learn Advanced Excel tricks on Data Cleaning Analytic – Go To, Date Correction, Replace using Wildcards, Text to Columns Learn Beginner to Advanced tricks on Go To Special, Sanitizing, Find & Replace, Text to Column and Text Formulas Complete overview of Microsoft Excel interface Data manipulation in Excel Data analysis in Excel Data cleaning in Excel Data Analysis and Data cleansing in Microsoft Excel This course is ideal for individuals who are Anyone who wants to learn Microsoft Excel or Anyone who wants to learn Data Analysis in Excel or Anyone who wants to learn how to clean the data It is particularly useful for Anyone who wants to learn Microsoft Excel or Anyone who wants to learn Data Analysis in Excel or Anyone who wants to learn how to clean the data.

Enroll now: Data cleaning in Excel

Summary

Title: Data cleaning in Excel

Price: $34.99

Average Rating: 3.85

Number of Lectures: 25

Number of Published Lectures: 17

Number of Curriculum Items: 25

Number of Published Curriculum Objects: 17

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Excel: Data cleaning and analysis techniques
Learn Excel functions to do data cleaning, data manipulation and analysis using the TEXT functions
Learn Advanced Excel tricks on Data Cleaning Analytic – Go To, Date Correction, Replace using Wildcards, Text to Columns
Learn Beginner to Advanced tricks on Go To Special, Sanitizing, Find & Replace, Text to Column and Text Formulas
Complete overview of Microsoft Excel interface
Data manipulation in Excel
Data analysis in Excel
Data cleaning in Excel
Data Analysis and Data cleansing in Microsoft Excel

Who Should Attend

Anyone who wants to learn Microsoft Excel
Anyone who wants to learn Data Analysis in Excel
Anyone who wants to learn how to clean the data

Target Audiences

Anyone who wants to learn Microsoft Excel
Anyone who wants to learn Data Analysis in Excel
Anyone who wants to learn how to clean the data

Welcome to very simple yet powerful Excel: Data cleaning and analysis using Power Query functions.

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

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.

Learn Advanced Excel tricks on Data CleaningAnalytic – Go To, Date Correction, Replace using Wildcards, Text to Columns.

We get data from various sources like ERP, SAP and in different formats. In order to make it useful to analyse, we have to clean this and put them in a structured format. It’s a pure time-consuming activity. In order tosave time and effort on cleaning and put the structure in place, We need few important data cleaning techniques as mentioned below which are part of this course. Check the list of Topics being covered in this course on Data Cleaning in Excel:

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Power of Knowledge

Lecture 3: what is Data

Chapter 2: Power Query in Microsoft Excel

Lecture 1: Introduction to Power Query

Lecture 2: Understand Power Query Options in detail

Lecture 3: Power Query Operations Part II

Lecture 4: Power Query Operations Part III

Lecture 5: What is Data Quality

Lecture 6: Data Transformation with Power Query

Lecture 7: Data Type Transformation

Lecture 8: Custom Column Creation Transformation

Lecture 9: How to Apply If condition

Lecture 10: Fill Below Series with Power Query

Lecture 11: how to handle Delimiter's

Lecture 12: How to apply Append Query

Chapter 3: Final Assignment

Lecture 1: Hands on Assignments

Chapter 4: Descriptive Analysis in Microsoft Excel

Lecture 1: How to perform Descriptive Analysis in Ms Excel

Instructors

Asim Noaman Lodhi
Certified Google Partner, Digital Marketer, QA Consultant

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 4 votes
4 stars: 2 votes
5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu