SEGRO Courses

Home | Excel | Power BI | Copilot | Visualising Data

Design Phase | Spreadsheet Modelling Best Practices (SMBP) Course

The design phase covers how the logic should be implemented in Excel. The benefits include:

• the model functions as intended,
• the calculations are easy to understand, maintain and extend,
• the model’s appearance is professional,
• the model’s user interface is supportive and helpful and
• the model’s layout in Excel does not prevent certain functions being used

The problems that may arise if we don’t do the design phase include:

• it is hard to use and to navigate around the model,
• it is hard to change or extend the model,
• it is hard to test the model and so … ,
• the model is likely to have errors, and
• the model lacks credibility.

Spreadsheet Design - Golden Rules

Here are 10 golden rules for spreadsheet design

Coffee Cart - Design & Build Exercise - Instructions

Follow the instructions for the design and build phase of the coffee cart case study.