Simple Business Process Modelling Using Spreadsheets

Because business process modelling techniques and tools exist in numerous variants, I’d like to share a very simple and practical process modelling approach. The software which is used is a simple spreadsheet software, and the process modelling technique is based on the Business Process Modelling Notation (BPMN).

  • Roles / departments are modelled as so-called swim lanes.
  • Within a swim lane, the role’s activities are positioned.
  • Activities are connected with arrows.
  • Furthermore, IT tools which support certain activities may also be depicted.

An Excel-based example can be downloaded here. Process elements can be easily arranged in the grid holding the ALT key while dragging the elements. This grid-based layout makes the model beautifully arranged.

Simple and practical process modelling

Leave a Reply