DATA ANALYTICS WITH EXCEL 1:(Find & Replace)
image source: https://play-lh.googleusercontent.com/37EzETO6gZyKmCg2kBIFX1e9gkubxZrVa5fHJ6yOaa7VvEShHjKv2RdtwnZt9Sk258s
Data Cleaning and preparation is one of the most important steps in Data Analysis. This involves the several techniques applied to ensure that the Dataset is in the best shape and form before any analysis is done.The find and replace function is very key in the cleaning process as it can be used to handle missing data, correct wrongly inputted values and much more. It is used for locating a particular value and replacing that value with the most appropriate one for your Analysis.
I tried to demonstrate how this function can be used in the video below but for some reason, the find and replace dialog box was not captured in this video. ( I really can’t tell why, if you know the reason or how I can solve it, kindly let me know in the comment section. ) While I hope for an explanation, I will explain how Find and Replace can be used below👇
How To Apply:1. Depending on whether you want to apply this function to a particular column or an entire sheet, select the specific column (for a specific column) or any cell on the sheet (for the entire sheet)
2. Click Ctrl + F. This opens up a dialog Box
3. Select ‘Replace’
4. In the ‘Find With’ bar, enter the value you want to replace and in the ‘Replace With bar’ enter the value you want to replace with.
5. Then select ‘Replace All’
6. Take a cup of juice😃😃
#dataanalytics #dataanalysis #data #excel