A change management tool in Excel/VBA
Turning an organisational issue into an operational steering mechanism.
- Organisation
- SUNU DigiTech
01
Objective
Standardise practices, make it easier to formalise change plans and improve the tracking of actions.
02
Solutions implemented
- A request form for capturing needs.
- A change framework centralising standard actions.
- A sheet for generating and tracking change actions.
- An automation that selects the relevant actions from the framework.
03
Deliverables
- Change management tool in Excel/VBA
Exhibits
Proof of work
VideoSUNU DigiTech · 2025
The assessment grid is filled in, then the tool generates the change management action plan from the reference library.
ScreenshotSUNU DigiTech · 2025
Eleven criteria scored from 1 to 5: exposure of deliverables, number of users, digital sensitivity, operational and business value, innovation, budget and sponsor engagement.
ScreenshotSUNU DigiTech · 2025
Criteria cross-referenced with standard actions: sponsor notification, visuals, videos, training sessions, webinars, guides and tutorials.
ScreenshotSUNU DigiTech · 2025
Based on the grid, the tool selects the relevant actions from the framework: 32 change management actions to carry out in this example.
