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

• Consolidating subsidiary budgets sheets with ease

• Carrying out effective budget reviews using the Scenario Manager