CBA - Certified Budget Analyst - Advanced Budgeting & Financial Forecasting using Advanced Excel
Details
This 5-days intensive event is targeting those responsible for the preparation of budgets, plans and forecasts and those who are using them as well. The course will start with some exceptionally important advanced Excel tips that will be utilized during the course. All of these tips coming together will orchestrate professional models that are dynamic and interactive. Very advanced tools like Monte Carlo simulation using Crystal Ball in Excel and PowerPivot (that is introduced recently in Excel) will be an inherent part of the program. When it comes to planning for the future in any organization, the biggest problem is how to account for uncertainty. Strictly (in financial terms), uncertainty is where there is more than one possible outcome to a course of action; the form of each possible outcome is known, but the probability of getting any one outcome is not known. It is a challenge to quantify uncertainty because it is on not an observable variable rather one that is deduced from others. However given a complete range of possible outcomes, one can make decisions that reduce this uncertainty. Monte Carlo simulation gives the power to solve a problem by directly simulating the underlying process and then calculating the possible results of the process with varying degrees of probability.
You will learn how to develop Power Pivots that can handle data of up to 200 million rows of data on a standard desktop or laptop computers knowing that normal pivot tables in Excel usually choke after about 30,000 rows of data or so. In addition, there are numerous other features in PowerPivot that will enrich the analysis of your data. For example, a powerpivot can read data from different ranges which is something a normal pivot table cannot accomplish. A professional case study will examine the interactions within a powerpivot example that will be a guide of something that can be implemented upon the completion of the course. The course is very hands on and practical in nature. That is what the trainer has been renowned for in different countries around the world. Please bring your laptop with Excel 2010 or higher. PowerPivots don’t work on Excel 2007.
Outline
»» Spreadsheet skills for planning and budgeting
»» Advanced Excel tips
»» Formatting
»» Documentation
»» Separating growth and cost factors
»» Optimization layout
»» Arithmetic cross checks
»» Charts
»» Data input forms
Forecasting:
»» Approaches to forecasting
»» Collecting and examining the data
»» Data collection
»» Using statistical measures
»» Selecting and evaluating forecasting techniques
»» Accuracy and reliability
»» Smoothing techniques
»» Adaptive filtering
»» Exponential smoothing
»» Regression analysis
»» Standard error
»» Multiple regression
»» Time series analysis
»» Multiplicative time series analysis
»» A time series analysis model
»» A model for analysing expected values
»» Trends and seasonalities
»» Expected Values
»» Developing a financial plan
»» What if analysis
Budgeting:
»» Approaches to business planning in Excel models
»» Scope of budgeting
»» Different approaches to budgeting
»» Spreadsheets for budgets
»» Preparing the budget template
»» Preparing the actual template
»» Preparing the variance report template
»» Preparing the year to date report template
Consolidating data:
»» Using the Excel Consolidate Command
Forecasting Using Monte Carlo Simulation:
»» Introduction of Crystal Ball of Oracle
»» Building a Crystal Ball Model
»» Simulation modelling process
»» Defining crystal Ball assumptions and forecasts
»» Running Crystal Ball
»» Tornado charts and sensitivity analysis
PowerPivot
»» Creating pivot tables from different data sources
»» Creating linked tables
»» Linking data into Excel from other Excel sources like Oracle
»» Relationship detection
»» Creating KPI (Key Performance Indicators)
»» Introduction to database management systems
Built upon the strong experience in the manufacturing sector, which its founders developed in Sweden during the 90’s global expansion, LEORON evolved into the dominant training institute that offers a comprehensive set of training and development solutions.
All across the EMEA region, we’ve gained a reputation by transferring knowledge in all strategic corporate functions, including corporate finance, HR, SCM, operations, and engineering. Today, we are globally recognized as one of the leading providers of US-certified programs. We offer certifications from the most notable American institutes, such as ASQ, APICS, IACCM, IIA, PMI, IABFM and much more.
LEORON’s mission is to help our worldwide clients boost their competitiveness by improving the competency levels of their employees through top quality training and development solutions delivered by unrivaled global experts and facilitated by the best training managers in the industry.
Whether our clients are facing difficulties re-organizing their brand, equipping their workforce with an extra set of skills or aiming to assess competencies within an existing structure, our development planning is a great solution. Through powerful content, gamification, and applied learning, we’ve established a great way of building professional skills and competencies, be it with public, in-house, or online courses. ...