Course Summary:
This workshop is based on Unit Standards 13941 and 116940 and is intended for managers of small businesses and junior managers of business units in larger organisations. The term business unit in this unit standard implies a small business, cost center, section or department. Junior managers include, but are not limited to team leaders, supervisors, first line managers and section heads.
Target Audience:
The workshop could be useful for any employee who is involved in situations where effective basic business budgeting skills are required.
Recommended Prerequisites:
None
Course Objectives:
After completing this workshop, the qualifying learner is able to:
Business Budgeting:
Explain the concept of budgeting in a business unit
Analyse the budget needs of a business unit
Present and justifying a proposed budget for a business unit
Monitor and control actual expenses and revenue against projected expenses and revenue
MS Excel:
Prepare and produce a spreadsheet to provide a solution to a given problem
Adjust settings to customise the view and preferences of the spreadsheet application
Work with multiple worksheets
Apply formulae to worksheets to provide alternative solutions to a problem
Apply simple built-in functions
Apply formatting to a spreadsheet
Use special effects to improve the presentation of the spreadsheet
Print a spreadsheet
Evaluate a spreadsheet
Key Topics:
Understanding budgeting requirements
Data and information sources
Working with MS Excel
Verifying the output produced for clarity and accuracy
Last modified: 28-Dec-2012
Training
