India · Mumbai · VBA & automation
Mumbai automation is nearly always about compressing month-end. Two analysts spending the first eight working days collating submissions is the normal starting point, and almost none of that time is analysis.
Abhishek
Abhishek Singh
Akhilesh
Prahalad
ShaktiA remote team of Excel and spreadsheet specialists. You work directly with the person building your file, from the first question to the final handover. More about us.
A typical job here
Usually 14–25 hours at our standard rate. You get that estimate in writing first, and we stop and ask before going past it.
| Automate MIS pack assembly from departmental submissions | 14–25 hours |
|---|
Why Mumbai specifically
Clients for this are typically in Bandra Kurla Complex, Lower Parel, Andheri East and Navi Mumbai, across banking and NBFCs, capital markets, insurance, media and advertising, logistics around JNPT, and the corporate head offices clustered in BKC. MIS packs, regulatory reporting and month-end that currently eats a week.
For the wider picture of what we see in this market — the recurring problems, the source systems, how the time difference plays out — the Mumbai guide covers it properly rather than repeating it on every service page.
14–25 hours is typical here. You get a number in writing before we start.
Unlocked files, documentation, recorded handover.
Full guide
This page covers one service. The city guide covers the whole picture, including the problems we see most in this market.
Excel experts in MumbaiScope
Two of the things this covers most often for Mumbai clients. The vba & automation page sets out the full scope and method.
A new macro written to a brief, for a process that currently happens by hand. We watch the process first — what people actually do differs from the documented procedure, and the difference is normally where the bugs live.
Repeatable transformation of the exports you get rather than the ones you wish you got. Often Power Query is the better tool here and we will say so, because a macro you cannot edit is worse than a query you can.
Not if. Source file missing, column renamed, someone has the file open. Each case gets a defined behaviour, and the default is always to stop cleanly rather than half-finish.
Any step that needs judgement stays manual. Automating a decision is how automation projects quietly produce wrong answers for months before anyone notices.
Need to check a feature before hiring? Read Microsoft’s official Excel help and learning for formulas, PivotTables, importing data and troubleshooting.
Questions
Answers for this service in this market, including the ones that might cost us the job.
Ask us something elseThe assembly, yes — usually from eight days to three. What it cannot compress is waiting for departments to submit, which is why we build a status board alongside: the chasing becomes visible rather than personal.
Yes, and it is a large part of what we do. The usual job is a macro that still runs but nobody understands, written by somebody who has left. We document it, repair what is broken, and hand it back in a state where your own team can change it.
We build the workbook mechanics — validation, reconciliation, the checks that stop a submission going out wrong. The regulatory interpretation must come from your compliance team; we do not advise on what the regulation requires, only on making the file that produces the answer reliable.
Related
Most projects touch more than one of these. We scope them together rather than selling them separately.
Same service elsewhere
Start with the problem
Send the workbook or describe the problem. An hours estimate back within a day, at no cost and no obligation.
Post your projectA short introduction
A short introduction to our Excel and spreadsheet work.
The short introductory video shows spreadsheet tables and dashboards, a person working on a laptop, and a message inviting viewers to post their project.