A REVOLUTIONARY APPROACH TO EXCEL BUDGETING
The Great Escape from Spreadsheet Hell

In a survey done for corporate budgeting, it was found that 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.

Most of these companies, however, experienced, Spreadsheet Hell, a term used to describe the following problems encountered as they developed and managed their budgeting template and model:

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.

If you are being afflicted by this Spreadsheet Hell, attend this course whereby you will be trained on how to use our revolutionary solution to escape from Spreadsheet Hell!

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

Watch this 8 minutes video and see a live demo on our coporate budgeting solution! I guarantee your time will be well spent.

COURSE DURATION

4 days (2 days per week)

WHO SHOULD ATTEND

This course is specially tailored for budget managers who are currently using or intend to use excel as the primary budgeting and forecasting tool.

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 16 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 Master 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.