Course Objective:

To equip participants with certain vital skills and tools for preparing budgets effectively and efficiently in Excel

Course Outline:
Building the Master Budget Sheet with ease by working with Range names and ..avoid tedious linking processes

Designing and building the Subsidiary budget sheets or templates in a group ..quickly and easily

Preventing unauthorized changes in the Subsidiary budget sheets or templates
..Incorporating instructions in the design of the Subsidiary budget sheets or ..templates

Incorporating Lower limits for Income figures and Upper limits for Expense figures

Allowing heads of departments to enter their budget figures in their assigned ..ranges with a password

Hiding underlying formulations and protecting your worksheets

Assembling figures into the Master budget using Macros

Carrying out effective budget reviews using the Scenario Manager

Managing your Database and troubleshooting