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
Built a fully customized Excel + VBA quotation system for a manufacturing company.
The solution includes:
• Product costing engine
• Dynamic garment structures
• Automated PDF proposals
• Internal production orders
• User roles and access control
• Historical database
A practical example of how Excel can become a complete business application.
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
Related posts
I built a research tool for VC analysts:
Diligence — AI Due Diligence Tool for VC Analysts
👀
Nice work!
🚀 Built a Fully Automated Transaction Entry Tracker-Finance System in Excel (VBA + UserForm)
Excited to share a project I recently completed using Microsoft Excel automation.
🔹 UserForm-based transaction entry
🔹 Income & Expense tracking with dependent categories
🔹 Automatic Entry ID, Date, Month & Year capture
🔹 Expense logic enforced (negative values)
🔹 Clean, user-friendly UI with color-coded actions
🔹 One-click save with data validation
🔹 Structured backend for dashboards & reports
This solution transforms Excel from a simple spreadsheet into a finance tracking system...
The project was designed with:
Data accuracy
User experience
Scalability for dashboards & reporting
Training & real-world usability in mind.
#ExcelAutomation #VBA #UserForm #FinanceTracking
#ExcelProjects #DataManagement #LearningByDoing #microsoft
The dependent category logic combined with automatic negative value enforcement for expenses is exactly the kind of guardrail that prevents data entry errors before they reach the dashboard — most trackers skip this and end up with messy backends that break reporting. The...
Ever stared at a spreadsheet and thought... there's got to be a better way?
That's where I come in. I'm a Power BI specialist who transforms raw financial data into interactive dashboards.
This company had 6 months of unorganized data. No idea which divisions were profitable. Four million dollars stuck in unpaid invoices.
I cleaned the data, built an interactive dashboard, created advanced metrics using DAX, and delivered a full strategic analysis.
Result? They found 1.3 million dollars in working capital they didn't know they had.
That's the power of business intelligence. If you need financial dashboards, data integration, or strategic analysis... I'm your person.
The unpaid invoice problem is one of the most common and most expensive data blind spots in mid-sized businesses — the money exists but nobody can see it clearly enough to act on it. Finding $1.3M in working capital from 6 months of unstructured data is a result that speaks...
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
portfolioreview
The best portfolios tell a story, not just show a grid. Share yours for feedback.
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?