Excel Trick To Earn Rs 1334 in One Hour!

Introduction

Have you ever thought about earning money by working just one hour using a simple Excel trick? Well, today I'm going to show you how you can achieve that, and the figure of ₹1334 comes from a real job you can take up for data cleaning.

Understanding the Job Opportunity

Let's explore a recent job post on a freelancing platform where a client is looking for help with Excel data cleaning. The client has outlined the requirements which include:

Employee ID
Employee Name
Designation (Remote or In-office)
Expected Salary

The basic plan for the data cleaning job pays ₹1334 for cleaning 1500 items from a spreadsheet. The post is readily available, and various freelancers list their gigs under categories like Excel Data Cleaning. The client’s needs entail organizing disjointed data into a clear format.

Performing Data Cleaning with Excel

The original dataset you encounter may look confusing. It often contains multiple pieces of information in a single cell, like in the case of "300 Nikhil Gupta Remote". Here, the data includes:

Employee ID: 300
Employee Name: Nikhil Gupta
Designation: Remote

Let's see how to effectively split this confusing data into separate columns.

Step 1: Extracting Employee IDs

First, input the employee ID (e.g., 300) in a new column where you want the IDs to appear.
Then go to the ‘Data’ tab and select ‘Flash Fill’ after you type the first ID.
Excel will automatically fill in the IDs for all employees based on the pattern it recognizes.

This method will help you efficiently clean up to 600 rows of data in under a minute!

Step 2: Extracting Employee Names

Similar to the previous step, enter the first name (e.g., Nikhil Gupta) in a new column.
Use Flash Fill again, but ensure to train Excel by using only one name initially.
Once validated, Flash Fill will correctly fill in the names for all rows.

Step 3: Designation Clarity

Copy and paste the designations (Remote/In-office) into the corresponding column.
Then, just like before, use Flash Fill to separate the designations into a distinct column.

Step 4: Extracting Salary

Copy the salary from the data cell and use Flash Fill to replicate it across the relevant column.
Always check for accuracy after you finish to ensure the extracted data is correct.

Finalizing the Clean Data

Once you have all data organized into the respective columns, it's time to prepare the final version for sharing with the client. Create a new sheet, copy the cleaned data over, and format it for better visibility.

Additionally, to enhance your listings and attract more clients, consider designing attractive graphics using free tools like Canva, which can help you stand out among freelancers.

Finding Jobs

To find such Excel cleaning jobs, platforms like Fiverr can be excellent resources. Don’t hesitate to start at a base rate; you can increase this as you build a portfolio and more clients appreciate your work.

Conclusion

By leveraging simple Excel tricks like Flash Fill, you can efficiently clean data and complete tasks in less than an hour—allowing you to earn around ₹1334 with ease!

Keyword

Excel, Trick, Earn, Rs 1334, One Hour, Data Cleaning, Flash Fill, Freelancing Job, Employee ID, Designation, Salary, Canva.

FAQ

1. How much can I earn with this Excel trick?
You can earn around ₹1334 for cleaning up to 1500 items in a spreadsheet.

2. What is Flash Fill in Excel?
Flash Fill is a feature in Excel that automatically fills in values based on patterns you establish.

3. Where can I find freelance data cleaning jobs?
Platforms like Fiverr, Freelancer, and Upwork are great places to start looking for freelance jobs.

4. How do I prepare my profile to attract clients?
Design an appealing profile and listing using tools like Canva for graphics, and be sure to showcase your skills effectively.

5. Is prior experience in Excel required?
While basic knowledge of Excel is beneficial, the tricks can be learned relatively quickly, making this job accessible for beginners.