Financial Modelling in the Public Sector

Learn the good practices that will reduce errors and improve the usability of your spreadsheets in under an hour.

Spreadsheet software has transformed the work done by accountants in many ways and makes it possible to build complicated financial models for evaluating real world situations. There tends to be a lack of standards for spreadsheeting in public sector organisations. Each accountant creates spreadsheets and financial models in their own (self-taught, probably) way. That is OK until a spreadsheet has to be used by someone else. Or even more difficult, the spreadsheet has to be updated by someone else. Often they will find it easier just to build a new spreadsheet using their self-taught methods: an avoidable waste of time and effort.

This course will introduce you to a set of straightforward principles you can use in any spreadsheets and 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 good practice 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 by building checks into your spreadsheets
  • Produce work that you're proud to share with others.

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

The standard version of this course includes a PDF summary of the tips and the opportunity to have a FREE 15-minute call with me to answer any questions you have as a result of the course.

Who will benefit?

Accountants: improve your spreadsheet skills to improve the quality of your work and save time

Finance team managers: understand the importance of using consistent financial modelling standards so that you can lead your team in adopting them.

Aspiring finance professionals: prepare for your career in public sector organisations by learning financial modelling best practice.

"Overall it's very well presented. The videos and screen clips provide the learner with some good examples, which can be easily followed."

- Finance Manager, Rotherham Council

"This is very useful for my public sector accounting and auditing work to ensure effectiveness and productivity."

- KL, Chief Internal Auditor, District Secretariat, Sri Lanka


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 latest book, International Public Financial Management: Essentials of Public Sector Accounting was published by Routledge/CIPFA at the end of 2018.

"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

"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!