CFBA Certified Forecasting and Budgeting Analyst™ - Using Advanced Excel and the R Language for Statistical Computing and Graphics

Register Now

Course Overview

This course has been designed as advanced level course and it assumes that delegates have attended basic to intermediate level courses or by qualifications and/or experience they are qualified to attend the course.
At the start of this course, delegates will be required to set out their major objectives for attending the course by identifying for the rest of the group the modelling needs and challenges that face them. The outputs of this session will be used as the focal point of the following sessions. This approach adds an element of flexibility to the course which means that the trainer may include additional materials/topics from then on in order to meet delegates’ needs.
Moreover, as an advanced level course, delegates will appreciate that the technical content of the program, for example, the forecasting sessions will be beyond the level of the work they have probably done before. Consequently, a mixture of developmental AND practical examples will be used here. It will be ideal of delegates are prepared to share they own forecasting and budgeting needs/examples to assist with this part of the course. As with all other parts of this course, the materials for the forecasting and budgeting sessions are fully developed and included here.
By way of an innovative development, this course also includes sessions on the R Language for Statistical Computing and Graphics. R is a true programming language and in this course you will be given a variety of inputs to help you to identify how it can help you with both your visualisation and statistical needs. Microsoft Excel is fine as far as it goes but it cannot compete with more dedicated statistical and visualization software in the way that R programming language does. The pre reading materials that you will be given prior to attending this course will include packages and examples that you can refer to before the course so that you will at least be familiar with some of the content in advance.
Delegates will appreciate both the power and the simplicity of the R language in carrying out statistical analysis, creating often stunning visualisations and generating ready to read reports in Word, HTML and other formats. Often, one line of code is all that is required to create analyses and visualisations.

By the end of this course, you will be able to:

• Review and work on your own company’s objectives, sources of data for forecasting and budgeting

• Review and work on your own company’s objectives, sources of data for forecasting and budgeting

• Analyze financial statements in depth

• Create financial forecasts and their analysis using Advanced Microsoft Excel and R Programming Language

• Plan for management performance and link the analysis outcomes to evaluate operational results

• Build budget templates and schedules

• Augment existing budgeting capabilities by incorporating scenario analysis

Who should attend?

• Financial Directors and Managers

• Financial Analysts

• Financial controllers

• Portfolio Managers

• Chief Financial Officers

• Corporate Finance Officers

• Bank Landing/Loan Officers

• Internal Auditor and Internal Controllers

• Risk Managers/Analysts

• Credit managers

• Financial and Management accountants

• Financial Project Administrators

• Project finance professionals

• Financial planners

PLUS anyone who is responsible for / involved in Financial Forecasting, Budgeting, Financial Modeling or anticipates being involved in a Financial/Forecasting/Budgeting multi-disciplined approach using Microsoft Excel, Power BI and R for Statistical Computing and Graphics in the future.

Expert Trainer

Duncan Williamson

Duncan has worked internationally as an Accounting and Finance professional, lecturer and trainer globally for many years. Duncan began his international work in 1988 when he started a five year posting to the University of Malawi where he was an Associate Professor of Accounting. Duncan has lived and worked in Central and South Asia, the Middle East, Mexico, the Caucasus and the Far East, including Thailand, where he now lives, Singapore, Malaysia and Vietnam. Duncan has been training in the area of Financial Modeling, Forecasting and Budgeting,IFRS and financial reporting for over a decade following assignments in the Causcasus and Central Asia in which he worked in USAID projects that were given the remit of setting up IFRS based accounting regimes in Armenia, first of all, then the former Soviet Union. This work included setting up a curriculum for the certification of professional accountants and developing training materials for that purpose. Duncan has trained a large number of CFO's, Financial Controllers and Planer,Auditors, Accountants and more in the area of Financial Modeling, IFRS, Financial Forecasting and Budgeting in the Middle East, Thailand and for Oil and Gas based delegates from Saudi Arabia, UAE, Kuwait, Oman, Lybia, Egypt, Ghana, Nigeria. Duncan's published work include a book on bookkeeping and accounting (The Bookkeeping and Accounting Coach published by Hodder and Stoughton in April 2014) a text book on cost and management accounting, a major book on Excel 2007 spreadsheeting together with an Excel workbook.

The GAFM was founded in 1996 by the original founders of the Graduate Leadership Society. The Founders of our Standards Board are CEOs, Executives, Professors, and industry experts from around the globe. We desire to raise education standards and ethics in the business and management industries. The Standards Policy Board awards specialized board certifications, designations, and charters in the fields of: finance, accounting, management, and consulting fields to qualified professionals who have completed internationally recognized or accredited exams & education, government recognized degrees and documented management credentials and experience. Since 1996, the Academy has been promoting accredited graduate standards for certification in business, management, law, and finance. Since the inception with the founding of the Graduate Institute of Leadership in 1996, the Academy has been focused on quality assurance with accredited education, exams, assessment, education, ethics, and continuing education. Further, applicants must also have the necessary experience in practice, research or publications in their respective areas of expertise.
Please fill in the form below to activate the download links.