Post in 3 months ago

Data Analyst Needed for Excel Data Cleaning & Sales Reporting

Summary

We are looking for a data analyst who can clean and organize an Excel sales dataset containing around 5,000 rows.

The data includes sales dates, customer names, products, quantities, prices, and sales regions. Before the file can be used for reporting, it needs to be cleaned and properly organized.

The main goal is to turn the existing data into a clean, reliable and easy-to-use Excel file while keeping the original data untouched.

The cleaned workbook should also include a simple summary showing overall sales performance, regional sales, top products and monthly results.

  1. Strong Excel experience
  2. Experience with data cleaning and organization
  3. Ability to work with large Excel datasets
  4. Remove duplicate records
  5. Handle missing and inconsistent values
  6. Standardize date formats
  7. Standardize text and number formats
  8. Convert numbers stored as text into proper numeric values
  9. Create calculated columns for total sales and profit
  10. Create and organize Excel tables
  11. Experience with Excel formulas
  12. Experience with PivotTables
  13. Ability to create simple and useful reports
  14. Basic chart creation
  15. Good attention to detail
  16. Ability to maintain the original data separately
  17. Ability to deliver a clean and easy-to-use workbook
$140.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