DATA CLEANING

Data cleaning is the process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset.

Shortcuts for Data Cleaning

1- Ctrl + Spacebar = select current column

2- Ctrl+shift+down=select only work column text

3- Ctrl+shift+ =Insert new column

4- Ctrl - = delete new column

5- Alt+H+P=Percentage

6- Substitute(N3,",",".")

7- Ctrl+Minus(Show row,column panel)

8- Alt+H+O+A To autofit rows

8- Data+Filter+Blank Rowa+Ctrl+-

9- Ctrl+G+Special+Blanks+=select top cell+Ctrl+Enter

10- Select Column+Ctrl+G+Blanks+Type NA+Ctrl+Enter

11- Select Column+Ctrl+H+Find what(Ctrl+J)+Replace with(press space bar)+Replace All

12- =IFERROR(H6/G6,"")

13- */

14- .*

DATA MINING

Data mining is the process of extracting useful insights and patterns from large datasets.

ABOUT CSV (COMMA-SEPARATED VALUES) FILES

A CSV is a comma-separated values file, which allows data to be saved in a tabular format.

A CSV file is a list of data separated by commas. For instance, it may look like the following: Name, email, phone number, address. Example,example@example.com,555-555-5555, Example Address.

👉Data Cleaning & CSV Files Assignments

Fiverr is the world's largest marketplace for digital services

Fiverr, the world's largest marketplace for digital services offers both buyers and sellers a digitally streamlined transactional platform. The unique term for a service offered by a seller on Fiverr is called a 'Gig. ' When creating Gigs, sellers can choose their starting price point.

👉Fiverr Account Creation Video Tutorial

EXAMPLES OF CLEANING DATA ON FIVERR

FIVERR GIG (Excel Data Cleaning)

GIGS Examples:

How many gigs are allowed on Fiverr?

You might be wondering how many gigs you can create on Fiverr if you are a freelancer trying to advertise your skills. The good thing is that Fiverr lets you establish many jobs to provide them with various services. You may create up to seven gigs when you join as a freelancer on Fiverr.

7 Gigs for sellers without a Level status. 15 Gigs for Level 1 sellers. 20 Gigs for Level 2 sellers. 30 Gigs for Top Rated Sellers.

FIVERR - AI Artists Gigs - Example

FIVERR - NFT Art & Illustration Gig - Example

FIVERR - Pattern Design Gig - Example

FIVERR - Data Entry Gigs - Example

Click Here: Excel Data Cleaning and Formatting

Gig Title: I will tidy up, organize, format, combine, separate, and sort Excel or CSV data for you.

Tags & Key Words:

Data Cleaning

Excel Organization

CSV Formatting

Data Sorting

Spreadsheet Management

About GIG:

Get your data in top shape with my gig! I'll clean, organize, and format Excel or CSV files for you, making your information neat and easy to use.

I can help you with:

Making Excel data clean and neat
Sorting, organizing, and cleaning data
Entering, analyzing, and managing data
Collecting and sorting information
Using Google Spreadsheets
Detecting errors
Separating or combining names and addresses
Formatting CSV files for uploading
Changing data from rows to columns and vice versa
Fixing 'Date' formatting issues
Rearranging Excel data as you need.

What's included in this service?

1. Excel Data Enhancement

2. Comprehensive Data Management

3. Data Entry and Analysis

4. Efficient Sorting and Collection

5. Customized Excel Solutions

Don't stress about data tasks; I'm here to make it simple for you. Let's work together to make your data work for you. Contact me today to get started!

Top of Form

Looking forward to working with you!

Sincerely,
Farzana Hussain

Compare packages

Package	PKR 3,475 BASIC	PKR 5,458 STANDARD	PKR 9,897 PREMIUM
	Do Excel data cleaning, organizing, merging, and formatting ( 500 rows ) in multiple sheets	Do Excel data cleaning, organizing, merging, and formatting ( 1500 rows ) in multiple sheets	Do Excel data cleaning, organizing, merging, and formatting ( 3000 rows ) in multiple sheets
Items Cleaned	100	1,500	3,000
Revisions	Unlimited	Unlimited	Unlimited
Delivery Time	1 day	2 day	5 days