Post in 3 months 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:2 months ago
Interviewing:0
Hired:0

Explore similar jobs on Working Trust

Posted 10 days agoMedium
Proposals:0 to 2

Data Analyst for Business Insights

The client is looking for a data analyst who can help the business make better decisions through data. The freelancer will work with internal teams to understand business requirements, process and analyze datasets, identify patterns and trends, and communicate findings in a clear and practical way. The main focus is not just preparing spreadsheets. The client wants someone who can translate raw data into useful business insights. The work includes: - Understanding business requirements. - Reviewing and cleaning business data. - Identifying trends and patterns. - Checking data quality and accuracy. - Building dashboards. - Preparing clear business reports. - Presenting findings to internal teams. - Providing recommendations to improve operations.

UB

UK Business Insights & Data Analysis Client

Verified client

United Kingdom

$30.00 fixed price

Mandatory skills listed:Data Analysis+19 Skills

$ 450 spent

Payment Verified

Posted 30 days agoMedium
Proposals:0 to 2

A Website for Local Company Handling Water Supply

The client wants a website for a local water supply company in Riyadh, Saudi Arabia. The website should present the company's services, allow customers to contact the business, and support card payments. The client has provided two reference websites: - Fresh Water Supplier - Water Tanker Supply in Riyadh The references should help establish the desired design, layout, and water-supply service features. The client has not specified whether the website needs online ordering, delivery scheduling, customer accounts, or an administrative dashboard.

WC

WorkingTrust Client

Riyadh, Saudi Arabia

$200.00 fixed price

Required skills: Web DesignWeb Development+11 Skills

$ 450 spent

Payment Unverified