Spreadsheet Modelling for the Public Sector

  • 5/5
  • 2 days in person
  • 4 half days online

This course is designed to help analysts tasked with the preparation of business-critical models working in the public sector. Delegates will learn a range of spreadsheet modelling tools and techniques to assure those making the decisions based on these models can rely on them.

Course Overview

What to Expect

This course was developed in consultation with key government departments, expanding on the principles outlined in the HMT Aqua book (2015). It provides your team with a grounding in analytical quality assurance and quality control.It grounds them in the concepts and techniques of best spreadsheet modelling practices that comply with the leading modelling methodologies, including how to :

  • Develop and use consistent range names;
  • Use switches, masks and flags to simplify logic;
  • Implement corkscrew structures;
  • Explore alternative solutions to circular references;
  • Build different types of checks (financial, structural and risk factors);

We have successfully delivered this training to Government Departments including the Department for Transport, The Ministry of Defence, Ofgem and Defra.

Suitable for

Who is this course suitable for?

  • Civil servants
  • Public Sector Analysts
Learning Outcomes

What are the learning outcomes?

  • Knowledge of best practice model development and design
  • Ability to write good code: corkscrews, masks, switches and counters
  • Skills and confidence required to inspect and review formulas
  • Ability to run robust sensitivity and scenario analysis techniques
  • Knowledge of how to record and write macros
Pop-up course

Upcoming courses

We occasionally run pop-up courses that individuals can enrol on.

Price per person: £1200

To register your details to be notified of the next availability please fill out the Register Your Interest form below.

Not sure which course is right for you?

Book a call with our Head of Learning today to discuss your team's needs.

Book now


Please get in touch with either of our regional offices.

Chris Aldred

+44 207 562 0433

[javascript protected email address]
Jun Tao

+44 207 562 0428

[javascript protected email address]
Michael Jarman

+1 647 243 8016

[javascript protected email address]
Philip Allen
Head of Training [javascript protected email address]

Operis Europe

View Google Map
+44 207 562 0400
[javascript protected email address]

Operis North America

View Google Map
+1 647 846 7382
[javascript protected email address]


Discuss your requirements with us

Chris Aldred

+44 207 562 0433

[javascript protected email address]
This field is for validation purposes and should be left unchanged.