The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
I Clean the following problems:
Duplicate records
Extra spaces
Incorrect capitalization
Nigerian phone numbers in different formats
Missing phone numbers
Missing quantities
Numbers stored as text, such as 5,000
Sales amounts with ₦ symbols and commas
Dates in different formats
Inconsistent payment methods
Check whether Total Sales = Quantity × Unit Price
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
I Clean the following problems:
Duplicate records
Extra spaces
Incorrect capitalization
Nigerian phone numbers in different formats
Missing phone numbers
Missing quantities
Numbers stored as text, such as 5,000
Sales amounts with ₦ symbols and commas
Dates in different formats
Inconsistent payment methods
Check whether Total Sales = Quantity × Unit
A sample Excel data entry project showcasing accurate data entry, formatting, sorting, filtering, and spreadsheet organization.
I have practiced important Excel data-cleaning skills:
Removing duplicates,
Removing extra spaces with TRIM,
Changing uppercase/lowercase with LOWER, UPPER, and PROPER,
Standardizing country and payment names,
Cleaning phone numbers,
Cleaning email addresses,
Handling missing values,
Standardizing dates
Checking Quantity × Unit Price = Total Sales.
