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.