|
|
|
![]() |
|
MANAGERIAL BUSINESS & DECISIONS
MODELING
(Using Microsoft® Excel) |
| |
|
iNTRODUCTION
: |
|
“ For decades businesses
has been using those MBA-taught methods to make
decisions. This course
revolutionalized the teaching of those proven
data-analysis & business modeling techniques
by integrating the use of MS Excel as a business
tool for analysis, interpretation and presentation
to make sound business decisions - - simple
and fast ! ”
|
|
|
| |
|
Making sound business 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 reduce those boring and tedious tasks
(like calculating, graphing and searching of statistical
tables) into just a few clicks of a button on the
computer keyboard. 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
MBA-important 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 completion of this course. These working templates
can save participants hundreds of hours in creating
charts and building tables. With this valuable tool,
participants can transfer all that is taught into
their workplace immediately.
|
|
|
|
|
|
|
|
At the end of the course, participants
will..
-
Better understand
real business decision-making techniques by analyzing
data using MBA-proven methods in the areas of Business
Statistics, Quality Improvements, Operation Management,
Sales & Marketing, and Finance.
-
Better utilize
MS Excel to quickly and easily compute data, present
charts/tables, describe information and interpret
results.
-
Learn to solve
real work business problems in a fast pace and painless
manner.
-
Be able to
test and make better business and personal decisions
for bottom-line results.
-
Learn new
techniques in building business scenarios fast
|
|
|
|
|
|
course
contents: |
|
Introduction:
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
Business Operations Decisions
Analyze data and using
decision modeling techniques to quickly:
-
Calculate how long
it would take to recoup a project’s startup
costs
-
Determine which
product mix will yield the greatest profits
-
Create customer
service queues with short wait times.
-
Estimate the probabilities
of equipment failure
-
Model business uncertainties
-
Use Solver to schedule
your workforce
Making
Sales & Marketing Decisions
Analyze data and using
decision modeling techniques to quickly:
-
Create best, worst,
and most-likely scenarios for sales
-
Estimate a product’s
demand curve.
-
Interpret the effects
of price and advertising on sales
-
Manage inventory
and order quantities with precision
Making Quality Improvements
Decisions
Analyze data and using decision
modeling techniques to quickly:
-
Understand
basic statistics
-
Summarize
data with Descriptive Statistics
-
Summarize
data with Histogram
-
Summarize
data with Pareto diagram. Separating the “vital
fews” from “trivial many”.
-
Summarize
data with Scatter diagram
-
Understand
the fundamental of Hypothesis testing: Z-tests,
t-tests
-
Perform
Analysis of Variance : 1-way ANOVA, 2-way
ANOVA
Making Personal Financial
Decisions
Analyze data and using decision modeling techniques
to quickly:
-
Plan personal
finances, such as computing loan terms or saving
for retirement
-
Create Sensitivity
Analysis with Data Tables
**SPECIAL NOTE ** :
1). In order to achieve
the accelerated learning objectives of this course,
it is necessary that participants 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 computers preloaded with MS Excel 2000 (and above)
licensed software available for participants to work.
|
|
|
|
|
|
who
should attend: |
|
|
|
|
|
|
|
administrative
details : |
|
| Duration |
: 3 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. | |
| |
