|
|
|
![]() |
|
MANAGERIAL DECISIONS & BUSINESS
MODELING
(Made Easy with Microsoft® Excel) |
| |
|
iNTRODUCTION
: |
|
“ For decades businesses
has been using those MBA-taught methods to make
sound decisions. This course
revolutionalized the teaching of those proven
data-analysis & business quantitative modeling
techniques by integrating the use of MS Excel
as a business tool for analysis, interpretation
and presentation of sound business decisions
- - in simple and fast-pace manner! ”
|
|
|
| |
|
Making sound business quantitative decisions in a
timely manner, with available data, using proven business
tools/techniques and correct interpretations are the
key skills for today’s Business Managers and
Entrepreneurs. Faced with large amounts of information
available today, most Business Managers use modern
tools (such as Microsoft® Excel spreadsheet program)
to help them summarize, report, and analyze data in
order to make accurate and better decisions. They
also need to build analytical business models to help
their company increase profits, reduce costs, or just
to manage their operations more efficiently.
This training program covers those important MBA
subjects and teaches the participants to use
the correct data analysis tools
and proven business modeling
techniques that could save them tens of hours
each week besides providing them with new improved
approaches for analyzing important business problems
and opportunities. The training approach is hands-on,
practical, teach-by-examples with
the focused emphasis on “real-world”
business scenarios and examples. This program
incorporate the use of modern business tools (such
as MS Excel) to simplify the task of analysis (e.g.
calculating, graphing and searching of statistical
tables). In doing so, it allows participants to spend
more time focusing on more value-added tasks such
as interpreting the business
results, optimizing opportunities
and creating various business
scenarios for those crucial business
presentations. The participants wouldn’t
just learn about MS Excel formula but learn those
important business subjects in
a fairly painless fashion! This training program
is a must for modern managers and executives who need
to acquire these essential business skills to survive
and compete in today’s competitive environment.
 .
NOTE: Value-add MS
Excel working templates will be given to participants
after the completion of this course. These working
templates can save participants hundreds of hours
in creating charts and building business scenarios
for management reports so that participants can immediately
transfer what they have learned in the training back
into their workplace.
|
|
|
|
|
|
|
|
At the end of the course, participants
will..
-
Better understand
real business quantitative decision-making using
proven techniques in the areas of Finance, Operation
Management, Sales & Marketing, Business Statistics,
and Quality Management.
-
Utilize MS
Excel to analyze data accurately, present charts/tables,
describe information and interpret results in a
fast-pace manner.
-
Learn to solve
real work business problems in an efficient and
painless manner.
-
Be able to
test and make better business and personal decisions
for bottom-line results.
-
Learn new
techniques to better describe and manage business
performances.
-
Be able to
build business scenarios fast
|
|
|
|
|
|
course
contents: |
|
Introduction:
Role of Management Science in today's
business.
Taking advantage of MS Excel analysis
& charting power:
-
MS Excel Add-in,
functions, charts, etc.
-
Get new perspectives
on data with pivot tables.
-
Easy charting
and tabling techniques for better decision making.
-
Easy graphing
for business presentations
Making
Financial Decisions
Analyze data and using
decision modeling techniques to quickly:
-
Calculate PV, FV,
PMT values
-
Determine a project's
NPV, IRR
-
Calculate how long
it would take to recoup a project’s startup
costs
-
Working Capital
& Capital Budgeting management
-
Model business uncertainties
Making
Business Operations Decisions
Analyze data and using
decision modeling techniques to quickly:
-
Determine which
product mix will yield the greatest profits
-
Determine optimal
workforce scheduling to minimize cost.
-
Make "Buy or
Sell" decisions
-
Solve Transportation
and Distribution problems
-
Determine Inventory
policy
Making
Sales & Marketing Decisions
Analyze data and using
decision modeling techniques to quickly:
-
Optimize Sales results
-
Create best, worst,
and most-likely scenarios for sales
-
Estimate a product’s
demand curve.
-
Interpret the effects
of price and advertising on sales
Making Quality Improvements
Decisions
Analyze data and using decision
modeling techniques to quickly:
-
Perform
business statistics anlaysis
-
Summarize
data with Descriptive Statistics
-
Prioritizing
action plans with Pareto diagram; separating
the "Vital Fews" from the "Trivial
Many"
-
Analyzing
data with Histogram to gauge acceptance &
reject percentage.
-
Summarize
data with Scatter diagram
-
Perform
fundamental Hypothesis testing: Z-tests, t-tests,1-way
ANOVA, 2-way ANOVA
- Using X-mR control chart to gauge & control
operational performance.
**SPECIAL NOTE ** :
1). Pre-requisite: Participants
must have some basic Microsoft ® Excel spreadsheet
skills such as using formula, work with cell references,
edit graphs, etc.
If the participant
would like to have prior
training on Microsoft® Excel basics
before attending this course, please click
here to find out more.
2). Class setup must include
making available Personal Computers preloaded with MS
Excel 2000 (and above) licensed software for participants
to hands-on. Participants are encouraged to bring along
their own laptop computers.
|
|
|
|
|
|
who
should attend: |
|
|
|
|
|
|
|
administrative
details : |
|
| Duration |
: 2 days |
| Time |
: 9.00am - 5.00pm |
| Venue |
: In-house or public program |
| Language medium |
: English |
|
|
| |
|
| |
|
Trainer
: |
|
|
|
| |
|
| |
|
| |
|
|
|
| |
|
Click
on the above banner to find out more about other Accelerated
Learning Courses |
|
| |
|
|
|
|
|
|
|
|
|
|
Back
to Top  |
|
|
|
|
 |
|
|
| |
|
|
|
|
|
Train for Personal Effectiveness
and Organizational Growth
© 2006 MyTrainingProvider.com, All Rights Reserved. | |
| |
