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

his 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.IIt 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: £2400

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

CONTACT US

Please get in touch with either of our regional offices.

https://www.operis.com/wp-content/uploads/2021/01/Erwan-Fournis-500x500.png
Erwan Fournis
Global Head of Financial Advisory

+44 207 562 0444

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/05/Carmen-Wade-500x500.jpg
Carmen Wade
Financial Advisory, Head of North America

+1 647 243 3840

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/03/Jun-Tao-500x500.png
Jun Tao
Global Head of Model Audit & Financial Modelling

+44 207 562 0428

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/04/Michael-Jarman-1.jpg
Michael Jarman
Head of Modelling

+1 647 243 8016

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/05/Philip-Allen-500x500.jpg
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]

CONTACT US

Discuss your requirements with us

https://www.operis.com/wp-content/uploads/2021/01/Erwan-Fournis-500x500.png
Erwan Fournis
Global Head of Financial Advisory

+44 207 562 0444

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/03/Chirs-Aldred-500x500.png
Chris Aldred
Director

+44 207 562 0433

[javascript protected email address]
Name(Required)
Consent(Required)
This field is for validation purposes and should be left unchanged.