Overview
Excel is the main application used to create budgets for small to medium organizations. Even large organizations use it as part of their budget process.
You can create flexible budgeting models in Excel by combining its many built-in features with its various functions.
These techniques could also be applied to forecasting and financial modelling.
Why you should Attend
Don’t waste time creating or updating your business budget. Use these techniques to speed up and simplify the budget process
Areas Covered in the Session
- choose monthly allocation methods on a line by line basis
- select different inflation rates to apply on a line by line basis
- choose between percentage-based allocations or per unit allocations
- turn inflation rates off and on at the click of a Check Box
- use drop down lists for selecting options
- create a flexible validation system
- includes a custom function example
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.