Advanced Excel Data Modeling
Budget: $2 – $8 USD
I’m starting a fresh Excel build and need someone who can take it from blank worksheet to fully-functioning analytical tool. The work revolves around three pillars: robust data analysis, time-saving macros, and solid financial modeling.
Here’s what I have in mind:
• Data analysis – clean raw imports, set up dynamic pivot reporting, and surface insights with formulas and Power Query where it makes sense.
• Creating macros – write well-commented VBA that automates repetitive steps and protects against user error.
• Financial modeling – structure cash-flow, scenario, and sensitivity tabs that link seamlessly to an assumptions sheet.
Because no legacy files exist, you’ll design the workbook architecture from scratch, agreeing on sheet layout and naming conventions before diving into code. I’ll supply sample datasets and the business rules; you return an unlocked master file plus a short walkthrough video (screen-cap is fine) so I can maintain it going forward.
If this sounds like your comfort zone, let’s discuss timeline and get started.
Here’s what I have in mind:
• Data analysis – clean raw imports, set up dynamic pivot reporting, and surface insights with formulas and Power Query where it makes sense.
• Creating macros – write well-commented VBA that automates repetitive steps and protects against user error.
• Financial modeling – structure cash-flow, scenario, and sensitivity tabs that link seamlessly to an assumptions sheet.
Because no legacy files exist, you’ll design the workbook architecture from scratch, agreeing on sheet layout and naming conventions before diving into code. I’ll supply sample datasets and the business rules; you return an unlocked master file plus a short walkthrough video (screen-cap is fine) so I can maintain it going forward.
If this sounds like your comfort zone, let’s discuss timeline and get started.