Excel VBA Data Analysis App
Budget: $250 – $750 USD
I’m building a single-file Excel solution driven almost entirely by VBA. Its job is to pull raw data, clean it, and let me run three kinds of studies on demand: statistical, financial and broader business analysis.
The workbook must feel like a real application—think custom ribbon buttons or a userform menu that guides me from data import through to finished charts and pivot-style reports. All processing, calculations and visuals should sit inside VBA (Power Query is fine if it lightens the codebase, but no third-party add-ins, please).
What I need from you
• A modular, well-commented codebase that loads in Office 365 / 2019 with no security pop-ups.
• Fast refresh: the full analysis should complete in under 20 seconds on roughly 50 000 rows.
• Deliverables: finished workbook, unlocked source code and a short user guide (PDF or DOCX) so I can maintain it later.
When you reply, focus on your track record—projects where you handled large, VBA-driven data models or similar analytics dashboards. A couple of screenshots or a short screen-grab is enough to show the scale; I’m mainly interested in your experience.
Target schedule is tight: a runnable prototype in the first week, refinements the next. Let’s talk through the details and get started.
The workbook must feel like a real application—think custom ribbon buttons or a userform menu that guides me from data import through to finished charts and pivot-style reports. All processing, calculations and visuals should sit inside VBA (Power Query is fine if it lightens the codebase, but no third-party add-ins, please).
What I need from you
• A modular, well-commented codebase that loads in Office 365 / 2019 with no security pop-ups.
• Fast refresh: the full analysis should complete in under 20 seconds on roughly 50 000 rows.
• Deliverables: finished workbook, unlocked source code and a short user guide (PDF or DOCX) so I can maintain it later.
When you reply, focus on your track record—projects where you handled large, VBA-driven data models or similar analytics dashboards. A couple of screenshots or a short screen-grab is enough to show the scale; I’m mainly interested in your experience.
Target schedule is tight: a runnable prototype in the first week, refinements the next. Let’s talk through the details and get started.