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
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.
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
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)
Sales & Expense Data Entry
Created and organized a structured sales and expense spreadsheet in Microsoft Excel. Entered customer records, dates, categories, amounts, payment status, and notes, then formatted the data into a clear and easy-to-read table.
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.
