Learn how to create an efficient and dynamic budgeting model by building interconnectivity between sheets, adding flexible formulations, and creating a customised template for budgeting using Excel VBA, Power Query, and Power BI.
Description
In this recorded webinar, you will learn how to create a flexible budget in Excel for your organisation's incoming and outgoing cash. The course will teach you how to use a bottom-up approach for incoming revenue and staff wages. You will also learn how to build interconnectivity between sheets, add flexible formulations, and create a customised template for budgeting using Excel VBA, power query, and Power BI. The webinar covers all the common budget inputs and outputs for any business, allowing you to create an efficient and dynamic budgeting model.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Review underlying assumptions in the model
- How to build up revenue and expenses
- Generate the cost of staff allocated to each office based on criteria
- Allocate administrative costs to the head office, state office and/or regional office
- Add flexibility to model based on the whole or part of the business selected
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step-by-step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: May 2023
Learning objectives
- Create a robust tool to generate sales and expense data which is scalable
- Produce a clear report layout so your message can be relayed simply and is easily absorbed
