Spreadsheet Modelling for the Public Sector

Rated 4.3

Public sector modelling concerns public spending and, as such, is subject to a level of scrutiny not often seen in the private sector. Analysts tasked with the preparation of business critical models need a range of spreadsheet modelling tools and techniques to provide assurance to those making the decisions based on these models.

This course has been developed in consultation with a number of 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, introducing them to the concepts and techniques of best spreadsheet modelling practice that comply with the leading modelling methodologies.

We have successfully delivered to government departments including the Department for Transport, the Ministry of Defence, Ofgem, Ofcom, and Defra.


This is one of the best training I have ever taken. The course is a key part of our offer[read more...]

Svitlana Voronkova Senior Analyst, Office for Research and Economics at Ofgem

You’ll learn:

  1. what good practice model development and design looks like;
  2. the skills and confidence required to inspect and review formulas;
  3. how to write good code: corkscrews, masks, switches and counters;
  4. how to run robust sensitivity and scenario analysis techniques; and
  5. how to record and write macros

Ideal course for

  • Public sector analysts who need to be compliant with a number of common modelling methodologies and standards, including Operis, FAST, SMART & ICAEW
  • Analysts in the civil service who want to get their modelling skills up to speed

Looking to run this course for your team?

Our team of expert trainers and L&D professionals can personalise this course to your specific business needs. If you’re not comfortably with face to face training right now, not a problem. We can blend and deliver our content in so many ways. On demand, live learning, webinars, coaching… have it your way.

Still have questions? Request a call back

Why not speak to one of our learning advisers? Please call, email or make a quick enquiry using this short form:

T: +44 207 562 0400

E: Knowledge@operis.com


Please get in touch with either of our regional offices.

Erwan Fournis
Global Head of Financial Advisory

+44 207 562 0444

[javascript protected email address]
Carmen Wade
Financial Advisory, Head of North America

+1 647 243 3840

[javascript protected email address]
Jun Tao
Global Head of Model Audit & Financial Modelling

+44 207 562 0428

[javascript protected email address]
Mark Southall
Associate Director - Model Audit & Financial Modelling

+1 647 846 7384

[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

Erwan Fournis
Global Head of Financial Advisory

+44 207 562 0444

[javascript protected email address]
Chris Aldred

+44 207 562 0433

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