The Complete Course On Data Cleaning In Ms Excel

Learn all functions and features of MS Excel 2019+ to clean the data and make meaningful interpretations

What you'll learn
Fundamentals of MS Excel
Learn Shortcuts commonly used in MS Excel
20 plus data cleaning techniques to make a meaningful interpretation of the work
Converting Messy data into Ready Data for Analysis
Learn WHY HOW and WHEN you need to clean the data
Requirements
You will need a Laptop/PC with any version of Excel installed in it
Basic understanding of Excel operations like opening, closing and saving a file
Description
Excel is one of the most in-demand skills at all levels and having complete knowledge of this tool will help you to grow and earn.Data is the new oil. Data that is downloaded from software, and survey forms have errors in terms of formatting, duplications, numbers saved as text, numbers saved as negative, etc., There is a need to clean all these data errors to prepare the data for a meaningful and insightful interpretationOnce the data is cleaned and prepared, further analytics can be done easilyData handling is the most sought-after skill in today's digital world. Whether you are a student, young professional, businessman, or freelancer, everyone needs to understand the data and make the most of the same. This basic course will help you to understand the basic functions to clean the data and prepare for the further analysisThe course covers basic functions to understand the working of MS Excel and then 15+ functions to prepare the dataLearn all functions, and features of MS Excel 2019+ to clean the data and make meaningful interpretationsText FunctionsText to Column FunctionLine BreakConvert Numbers saved as textRemove DuplicatesRemove Extra spacesDelete Blank Rows and ColumnsWe wish the best of luck to all our dear learners

Overview

Section 1: Welcome to the Course

Lecture 1 About the Course Instructor

Lecture 2 Time is Money

Lecture 3 Life Long Learning

Section 2: Fundamentals of MS Excel

Lecture 4 Workbook and Worksheet

Lecture 5 Navigation 1

Lecture 6 Navigation 2

Lecture 7 Selecting the Cells 1

Lecture 8 Selecting the Cells 2

Lecture 9 Selecting the Cells 3

Lecture 10 Selecting the Cells 4

Lecture 11 Paste Special 1

Lecture 12 Paste Special 2

Lecture 13 Paste Special 3

Lecture 14 Paste Special 4

Lecture 15 Formatting 1

Lecture 16 Formatting 2

Lecture 17 Filter the Data

Section 3: Mastering Data Cleaning in MS Excel

Lecture 18 Delete Blank Rows and Column in Data

Lecture 19 Remove the Duplicate Entries in Data

Lecture 20 Magical Function of MS Excel - Flash Fill

Lecture 21 Join the Text

Lecture 22 Convert Negative Numbers to Positive Numbers 1

Lecture 23 Convert Negative Numbers to Positive Numbers 2

Lecture 24 Convert Numbers Saved as Text to Numbers

Lecture 25 Add Line Break in the Text String 1

Lecture 26 Add Line Break in the Text String 2

Lecture 27 Fill the Range

Lecture 28 Create Custom List

Lecture 29 Find and Replace

Lecture 30 Converting Text into Lower Case

Lecture 31 Converting Text into Upper Case

Lecture 32 Converting Text into Proper or Sentence Case

Lecture 33 Remove Extra Space in the String

Lecture 34 Count the Characters in the String

Lecture 35 Convert Text to Column 1

Lecture 36 Convert Text to Column 2

Lecture 37 Convert Text to Column 3

Lecture 38 Clear Formatting

Students who are undergoing Summer Internship Projects and have to clean the survey data to make their reports stand out.,Researchers who want to clean the survey data,Anyone looking to pursue a career in data analysis or business intelligence