SEGRO Courses

Home | Excel | Power BI | Copilot | Visualising Data

Spreadsheet Modelling Best Practices Course

Duration

This is a one day course.

Knowledge Pre-requisites

Attendees are familiar and comfortable using Excel. This course assumes that people have attended the Excel Foundation Course and possibly the Excel Intermediate Course

Learning Outcomes

Build spreadsheet models using best practice so that:

• we solve the right problem.
• we get it right first time.
• the model is robust, easy to understand, flexible and maintainable.

The course focuses on usability, repeatability, scalability, communication and presentation of results. The labs are in Excel, but this is not an Excel course per-se.

Agenda

• Introduction to the course
• Scope Phase
• Specification Phase
• Design & Build Phase (including Golden Rules)
• Test Phase
• Conclusions. Next Steps
• Close