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
Back to feedPost
Data Cleaning
Title: Data Cleaning & Formatting in Excel
Description: Cleaned and organized 5000+rows of raw data.
Removed duplicates and formatted for reporting Fast turnaround.
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
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
Excel Data Cleaning: Cleaned and formatted Excel data by removing duplicates and standardizing information.
Excel Dashboard
Title: Sales dashboard with Formulas & Charts
Description: Created a professional monthly sales dashboard in Excel using pivot tables, charts and automated formulas. Helped business track sales performance and make data-driven decisions. Delivered with 100% accuracy within 24 hours.
This is a banking credit dashboard I built from scratch to turn messy loan application records into clear, actionable visuals. The main goal was to analyze what factors actually cause a loan to get approved or rejected.
Here is how I worked on this project manually:
Data Formatting: I cleaned and sorted the raw dataset in Excel, fixing missing rows and organizing the numbers for a flawless setup.
KPI Calculation: I calculated core credit metrics, such as total loan amounts, average annual income, average CIBIL scores (599.9), and the final approval percentage (62%).
Insightful Charts: I created custom visuals to show important comparisons, like loan approval rates based on education levels and a breakdown of residential vs commercial assets.
I designed this entire dashboard on a dark background to make the charts stand out and look clean. Anyone can click the filters on the side to update the whole screen instantly.
Tools used: Advanced Excel (Pivot Tables, Slicers, Data Visualization, Data Analysis)
