WorkingTrust
Post in 1 month ago

Data Analyst Needed for Excel Data Cleaning & Reporting

Summary

I have an Excel file with around 5,000 rows of sales data, including dates, customer names, products, quantities, prices and sales regions.

The data needs to be cleaned and organized before I can use it for reporting. There are some duplicate records, missing values, inconsistent date formats and numbers that are currently stored as text.

I need someone who can clean the file, organize the data properly and create a simple summary report.

The original data should remain untouched in a separate worksheet. The cleaned data and reporting should be placed in new worksheets.

  1. Good experience with Excel
  2. Experience with data cleaning
  3. Experience working with large Excel datasets
  4. Remove duplicate records
  5. Handle missing values where possible
  6. Fix inconsistent date formats
  7. Standardize text and number formats
  8. Convert numbers stored as text
  9. Create total sales and profit columns
  10. Organize the cleaned data into Excel tables
  11. Use formulas and PivotTables where appropriate
  12. Create a simple sales summary
  13. Create basic charts
  14. Good attention to detail
$450.00
Medium
Remote Job
Ongoing project

Skills and Expertise

No skills added for this project yet.

Activity on this job

Proposals:0 to 2
Last viewed by client:4 days ago
Interviewing:0
Hired:0

Explore similar jobs on Working Trust

Posted 4 days agoSmall
Proposals:0 to 2

Data Analyst Needed for Social Media Content Performance Analysis

Analyze a small social media content dataset to determine which types of content perform well and why. The goal is to convert the data into clear, easy-to-understand business insights. The freelancer will clean and analyze the dataset, identify performance patterns, create visualizations/dashboard, and provide actionable recommendations.

WC

WorkingTrust Client

United States

$50.00 fixed price

Data Analysis25 days flexible13 connects

$ 450 spent

Payment Unverified

Posted 5 days agoMedium
Proposals:0 to 2

Data Extraction and Analysis Specialist

Extract and analyze data from a large dataset, clean and organize the data, identify trends, and perform basic statistical analysis. Present the findings clearly in a concise report with actionable insights. This is a part-time project with potential for ongoing collaboration

WC

WorkingTrust Client

United States

$5,000.00 fixed price

Data Analysis3 months flexible1250 connects

$ 210 spent

Payment Unverified