Implementing Hassle Free Budgeting with Excel

With the ever changing business environment, it is becoming increasingly difficult to keep track of the development in the different business areas. Every functional head has his/her own feel and perception of the market based on his/her own experience and encounter on ground. It is so critical for functional heads to keep abreast of the latest business development so that they can confidently steer the company towards a specific goal with an optimal amount of resources.

Budgeting is an excellent way of finding out the optimism of the market as the business function heads put down their estimates for the new year. Although the number may not materialize as the business environment changes, the budgeted numbers serve as a valuable benchmark for the company to navigate itself through good times and bad times.

Course Outline
1. How to align the headers and sub-headers with the data input using existing formulas in Excel.
2. Transform the data input into a Data Cluster
3. Analyze the business units numbers using the data cluster and pivot table, a powerful analytic tool in Excel
4. Combine the Data Clusters into a Data Hub so that company’s budget can be presented in minutes without spending more money on new programs and hardware
5. Analyze the budget at all levels. Participants will learn how to use the report to drill down to the most level easily.
6. Prepare Dashboard, summary reports and charts using the Data Hub, the only single source of data for all.

(1) 15 to 16 January 2009 ► Register for this run
(2) 16 to 17 April 2009 ► Register for this run
Time: 9.00am - 5.00pm
Venue: NTU@one-north campus, Executive Centre
Fee: Standard: SGD$1,000.00 NTU Alumni: SGD$800.00 Group (3 & above): SGD$900.00


Click here for more NTU Course information