How to fix inconsistencies

1. Go to Data > Fix Inconsistencies
   
2. In the side panel that appears, select the column from which you wish to fix inconsistencies.
   
3. This tool will list the capitalization errors, typos and inconsistent spellings. For example, Tyler Smith, tylersmith, TylerSmith.
   
4. Click Replace and Group to replace two or more iterations of the same word into one.
   

 

1. Go to Data > Fill Missing Values 
   
2. In the side panel that appears, select the column from which you wish to fill missing values.
   
3. Once the empty cells are listed, select one of the three options provided to fill the cells with a value of your choice.
   
4. You can either choose to fill all the missing values with a specific value, or fill it with the content in the previous cell or fill the cells with the most occurred value in the column.
   

 

How to find and remove duplicates from your data set

1. Go to Data > Find Duplicates
   
2. In the side panel that appears, select the column from which you wish to find duplicates.
   
3. Once the duplicate records are listed, choose one of the three options provided to perform in the data set.
   
4. You can choose to delete, highlight, move or copy the duplicates.
   

 

How to find uniques and frequencies

1. Go to Data > Other Tools  > Uniques.
   
2. Select the range for which you wish to find uniques.
   
3. Once the uniques and duplicates are listed, you can move, delete, copy or apply style to the duplicate data.
   

1. Go to Data > Other Tools  > Frequencies.
   
2. Select the range for which you wish to find frequencies.
   
3. The frequency of each value will appear in the side pane.