BUSINESS SPREADSHEET: analysis and strategies through excel software*

BUSINESS ANALYSIS in spreadsheet / Excel

A mandatory course for all executives, managers and entrepreneurs

Learn two in one course:  Learn business and excel at the same time.

First day:   How to analyse a company to find the strenths and weaknesses

Second day: Design and simulate a set of fresh business models and thereafter to estimate the results

(optional second day)

COURSE OBJECTIVE)

To demonstrate how simple it is to analyse business performance through excel or other spreadsheet softwares.

Prepared templates and models shall be shown to enable repeated process to be done in split seconds.

With spreadsheet you could design suitable business models with which you could simulate yourself with all the variables to see the impact of your changes.

Thereafter you could choose the right strategies and models for your business.

We shall introduce you basic excel programs as we conduct the excersises.

Who should attend

• Both financial and non-financial professional 
• Mandatory course for all executives, managers and entrepreneurs
• Those who want to enhance their effectiveness and contribution in their current role.

The training approach

1. Data analysis
2. Vertical d horizontal analysis
3. Ratio analysis
4. Prepared excel templates and models to save teaching time.
5. Simulation on the models to see the impact on results

CASES DISCUSSED IN EXCEL 

1. Product costs and pricing strategies
2. fixed and variable costs
3. Cost volume profit analysis that estimate the economic size of business.
4. Working capital and trading strategies
5. Fixed Assets and financial leverage
6. Sources and costs of financing and the need to balance
7. Cash Flow Projections
8. IRR and NPV
9. Return on Equity
10. ROE simulation
11. Shop Profitability

Skills taught

1. Store data securely
2. Analyse data
3. design business models
4. Use model for sensivity analysis
5. submiting reports on excel.
6. applying template dan model in excel

FAQs

Are there ID or minimum age requirements to enter the event?

No prerequisite.  Basic knowledge of excel is sufficient.

What are my transportation/parking options for getting to and from the event?

MRT Asia Jaya

What can I bring into the event?

Note book or laptop with excel software

How can I contact the organizer with any questions?

Arriffin 012-2786282

What's the refund policy?

7 days prior to event

Do I have to bring my printed ticket to the event?

Preferably