I will clean, formate and organize your sales data in excel
Excel Data Analyst, Data Cleaning, Organizing, Dashboards and Reporting
About this Gig
Sales data full of duplicates, blanks and mixed formats? Ill clean it and turn it into clear numbers in Excel.
WHAT YOU GET
Duplicates removed, dates and text standardized
Missing values filled where your other columns make it certain, flagged where they dont
Summary tables: sales by item, weekday, month, payment method or location
Cross-tab tables comparing two categories (Premium)
KPI cards and a one-page dashboard (Premium)
A short list of key findings (Premium)
HOW IT WORKS
Send your file and tell me what you want to know
I confirm whats possible before you order
You get regular updates and plain-language results, no jargon
RECENT WORK
Full dashboard from a 10,000-transaction café sales dataset (public data): cleaning, 7 charts, KPI cards
FILES
Excel, CSV or a Google Sheets link
Analysis type:
Quantitative Analysis
•
Descriptive Analysis
•
Other
Expertise:
Business Insights
•
Trends
•
Math
Technology:
Excel
Programming language:
Other
My Portfolio
FAQ
What file formats do you accept?
Excel (.xlsx), CSV, or a Google Sheets link. I deliver an Excel file.
What if some of my data is missing?
I fill a missing value only when your other columns make it certain, for example price from quantity and total. Anything I can’t recover is flagged or left blank, never guessed, and I list it in my delivery note.
Do you do forecasting or predictions?
No. I cover what happened and where: totals, breakdowns, trends and patterns in your existing data. I don’t build forecasts or statistical models.

