02 · UniCredit · Internal tool
A tailored Excel and VBA tracker for anonymous task coordination, flexible KPI collection, and practical team reporting.
Confidential project - details shown are intentionally non-sensitive.
The idea
We needed something easier than a large project-management system and more structured than several separate spreadsheets. It had to be anonymous, simple to learn, and available to authorised colleagues from their own workstations.
The important part was flexibility. Tasks and KPIs change, so a useful internal tool has to accept new requirements without being rebuilt every time.
What I built
I wrote the tool in Excel and VBA because that environment was already available to the team. It brings task entry, status tracking, KPI collection, and management reporting into one workflow, while keeping the interface familiar for people who use Excel every day.
The structure is deliberately modular: new task types and measures can be added as the team’s needs develop instead of being forced into a fixed template.
Result
The tracker makes recurring reporting more consistent and gives the team a shared view without turning routine work into administration. It is not complicated software, and that is part of why it works.
Like the signature project, the current version includes internal code and data that cannot be published. I am separating those parts so I can show a realistic public demonstration safely.