DYNAMIC REAL-TIME FORECASTING WITH EXCEL
A breakthrough in budget consolidation

When the word budgeting is mentioned, the first thing that comes to a budget manager's mind are

1. Fear of broken links when changing the cell locations of values in a worksheet.
2. Cumbersome to manage a group of workbooks that are inter-dependent on each other.
3. Laborious copying and pasting of data to and from a worksheet.
4. Unable to perform detailed analysis with the information stored in the worksheets and workbook.
5. No confidence that the information is accurately reflected in the workbooks.
6. Time taken to update workbooks becomes longer each time.
7. Too many cross links between workbooks.
8. Too many cross links between worksheets within each workbook.
9. How data in different worksheets are linked together is forgotten.

While there are many software in the market that claim to be able to get rid of these problems in place of Excel, 78% of all companies still use Excel as their primary budgeting and planning tool. And this is not limited to small and medium sized companies. 68% of large companies still use Excel as their primary budgeting and planning tool. The verdict is clear. Budgeting software does not offer the flexibility and control Excel provides. And it is least expensive to scale up and minimum training is required by new users.

Using our expertise in Excel, we developed a solution that will help you

1. accurately consolidate your budgets without Inter-workbook links,
2. Provide almost real-time update to budget changes,
3. Provide detailed analysis of expenses by departments and business units.

If you wish to know how this can be achieved without macros and new software, sign up for this course now!

COURSE OBJECTIVES

You will learn how to develop a business model using excel which can

1. Create a Data Hub without links;
2. Analyze the budget in different dimensions such as distribution channels, product groups, divisions, countries, using the Data Hub;
3. Create powerful and professional looking reports and charts that are automatically updated with new budget items added into the Data Hub.

COURSE OUTLINE

1. Align the headers and sub-headers with the data inputs





2. Transform the data inputs into a Data Cluster





3. Analyze the business units' numbers using the Data Cluster





4. Combine all the Data Clusters into a Data Hub.





5. Analyze budget at business unit level





6. Prepare dashboard, summary reports and charts using the Data Hub

COURSE DURATION

2 days

WHO SHOULD ATTEND

This course is specially tailored for Sales Directors, Chief Financial Officers, finance managers, sales managers and executives in sales planning, business planning, corporate planning, accountants, financial analysts who are involved in sales forecasting.

The participants are expected to know VLOOKUP, IF formula, absolute and relative referencing, and pivot table. Participants are highly encouraged to attend our foundation course "Hidden Secrets to Excel Data Analysis" first before attending this course.

Participants must be familiar with the Microsoft Excel and possess advanced Excel skills. They must know advanced worksheet formulas in Excel and how to create a pivot table.

CLASS SIZE

This course is conducted with a class of no more than 20 participants.

DETAILS ON THE COURSE

Computers and Course materials will be provided by EverydayExcel.

OUR TRAINERS

everydayExcel trainers are all experts in spreadsheets and databases. They are specially hand-picked by the Chief Trainer, Jason Khoo, based on their experiences in training and the business knowledge they possess. Jason has worked in local listed companies and foreign MNCs managing the companies' budgeting process and developed business models for forecasting. He was also a financial counsel for a Fortune 500 company's business unit which generated a total revenue of more than S$100 million per annum.

everydayExcel has helped many companies save thousands of dollars by providing simple and yet powerful business solutions through the use of Microsoft® Excel. Examples of such solutions include budget planning and forecasting, customer segmentation program, personalized email broadcast to targeted customers, and sales lead generation program (mini CRM), etc.