The Complete Course on Data Cleaning in MS Excel
- Description
- Curriculum
- FAQ
- Reviews
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 interpretation
Once the data is cleaned and prepared, further analytics can be done easily
Data 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 analysis
The course covers basic functions to understand the working of MS Excel and then 15+ functions to prepare the data
Learn all functions, and features of MS Excel 2019+ to clean the data and make meaningful interpretations
Text Functions
Text to Column Function
Line Break
Convert Numbers saved as text
Remove Duplicates
Remove Extra spaces
Delete Blank Rows and Columns
We wish the best of luck to all our dear learners
-
4Workbook and WorksheetVideo lesson
-
5Navigation 1Video lesson
-
6Navigation 2Video lesson
-
7Selecting the Cells 1Video lesson
-
8Selecting the Cells 2Video lesson
-
9Selecting the Cells 3Video lesson
-
10Selecting the Cells 4Video lesson
-
11Paste Special 1Video lesson
-
12Paste Special 2Video lesson
-
13Paste Special 3Video lesson
-
14Paste Special 4Video lesson
-
15Formatting 1Video lesson
-
16Formatting 2Video lesson
-
17Filter the DataVideo lesson
External Links May Contain Affiliate Links read more