Skip to content
DN
← All files
File 02/06 · SUNU DigiTech

A change management tool in Excel/VBA

Turning an organisational issue into an operational steering mechanism.

Organisation
SUNU DigiTech
Video
Excel/VBA change management tool filmed while in use: a project's assessment grid

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

  • Excel/VBA change management tool filmed while in use: a project's assessment gridVideo

    SUNU DigiTech · 2025

    The assessment grid is filled in, then the tool generates the change management action plan from the reference library.

  • Excel evaluation grid with eleven criteria and boxes ticked from 1 to 5 for a projectScreenshot

    SUNU 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.

  • Excel table cross-referencing the evaluation criteria with change management actions, marked with a crossScreenshot

    SUNU DigiTech · 2025

    Criteria cross-referenced with standard actions: sponsor notification, visuals, videos, training sessions, webinars, guides and tutorials.

  • Excel list of the change management actions to carry out, totalling 32Screenshot

    SUNU 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.