Pzgajxusbclxegma1duw

Financial Modelling in the Public Sector

Learn the good practices that will transform your spreadsheets into financial models

  Enrol in Course

Spreadsheet software has transformed the work done by accountants in many ways including making it possible to build elaborate financial models for evaluating real world situations. There tends to be a lack of standards for financial modelling in public sector organisations so each accountant would approach creating a financial model in their own (self-taught, probably) way. The most significant problems with this sort of approach are:

  • the high risk of undetected errors being built into models
  • if/when the creator of a model leaves or is promoted, a new model will be built from scratch because no-one knows how to update the original model.

This course will introduce you to a set of straightforward principles you can use in any financial models you build. Whether you work in Excel, Google Sheets, Numbers or an Open Office spreadsheet application, by completing this course you will:

  • understand the importance of following financial modelling standards
  • be able to build high quality financial models that are easier to use, easier to review and easier to update
  • Make fewer mistakes
  • Produce work that stands out from the crowd.

And, if you're a manager of a finance team you can use this knowledge to set financial modelling standards for your team.


"His experience working [in the] public sector as an accountant and auditor gives an insight into managing public money. He's creative! His Powerpoint presentation is fantastic!"

- MPA student, University of Nottingham

Your Instructor


Gary Bandy
Gary Bandy

Gary Bandy is a Chartered Public Finance Accountant with over 30 years' experience of public financial management. His career has included roles in accounting, audit and senior management. He has been an independent consultant since 2005 and in that time he has developed into a very good teacher, in-person and online. He is the convenor of a postgraduate public sector financial management course at the University of Nottingham.

His first book, Financial Management and Accounting in the Public Sector, was described as “an innovative and wonderful addition to the literature of public sector management.” His new book, International Public Financial Management: Essentials of Public Sector Accounting was published by Routledge/CIPFA at the end of 2018.


"This course was very learner friendly while providing the scope needed to tackle fundamental issues in public finance. It should be required reading not only for public managers but for the politicians as well."

- S.K., Open University online course student

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
I would never want you to be unhappy! If you are dissatisfied with your purchase, contact me within 30 days and I will give you a full refund.
Do I need to be an advanced user of Excel or other spreadsheet application?
You need to have some knowledge and experience of spreadsheet software but you do not have to be an advanced user. The course is more about the principles of building models than compiling complex formulas. If you can use functions like IF and LOOKUP you will be OK.
Do I need to be working in the public sector?
No. The course is marketed to people working in the finance teams of public sector organisations because that is my background and speciality. Actually, the principles would apply just as much to financial models in the private sector or charities.
Can I pay the fee in instalments?
Sorry, that option is not available for this course.

Get started now!