Excel Data Cleaning & Formatting — Practice Portfolio. This sample demonstrates data entry, data ...Excel Data Cleaning & Formatting — Practice Portfolio. This sample demonstrates data entry, data ...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Excel Data Cleaning & Formatting — Practice Portfolio. This sample demonstrates data entry, data cleaning, spreadsheet formatting, table organization, and structured data presentation using fictional data.
Excel Data Entry & Cleaning — Sample Portfolio. A practice project showcasing data entry, data cleaning, formatting, table organization, and basic spreadsheet calculations using fictional data.
Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.
What I did:
Structured the raw data into a proper table (consistent headers, currency formatting)
Built a PivotTable summarizing Sum of Sales by Last Name and Country
Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded
Checked every formula for errors before delivery
Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.
If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.
Data Entry & Organization — Practice Portfolio. This sample demonstrates accurate data entry, structured table organization, categorization, quantity tracking, and clear spreadsheet presentation using fictional data.