| |
|
![]() |
|
DATA ANALYSIS & BUSINESS
DECISION-MAKING
(Made Easy with Microsoft® Excel) |
| |
|
iNTRODUCTION
: |
|
“ For decades businesses
have been using those MBA-taught methods to
make sound decisions. This course revolutionized 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 is the
key success factor 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 in business functional areas such as Finance, Operations, Quality Control, Sales/Marketing and Distribution. It will get you up to speed to use the correct data analysis tools and proven business modeling
techniques that could save you tens of hours
each week besides providing you 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. You will learn those important business subjects in
a fairly painless fashion! This training program
is a must for all 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 be able to:
- Practice hands-on real business data analysis and quantitative decision-making using proven techniques in the areas of:
- Statistics, Using Pivot Tables
- Finance, Operation Management, Sales/Marketing & Quality Control
- Utilize MS Excel to compile data, tabulate & interpret results, and present tables/charts in a fast track manner.
- Analyze data quickly using proven methods and construct business models.
- Solve real work business problems in a fast pace manner.
- Test and make better business and personal decisions for bottom-line results.
|
|
|
|
|
|
|
|
|
|
The following methods will be utilized to enhance the participant's learning: |
|
-
Hands-on real business data analysis
-
Case studies, Computer simulation and data analysis exercises
-
Small Group discussions
-
Business scenarios building
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
course
contents: |
|
Introduction to Data Analysis using MS Excel:
- Introduction to Management Science & Business Operational Decision Analysis.
- Importance & benefits of utilizing data for business decision making.
- Benefits of using MS Excel for data analysis
- Easy charting and tabling techniques for better decision making
Transforming Data Into Information
-
Preparing data for analysis
-
Get new perspectives on data with pivot tables
-
Easy charting and tabling techniques for better decision making.
Analyze & Solve Real Business Problems in the following areas:
- Analyzing basic PV, FV, PMT, NPV, IRR for project evaluations.
- Plan personal finances, such as computing loan terms or saving for retirement
- Using Pivot Tables to slice data according to top customers, best selling products and/or by profits/cost/sales.
- Calculate how long it would take to recoup a project’s startup costs
- Determine which product mix will yield the greatest profits
- Minimize cost of sales
- Optimal workforce scheduling
- Making “Buy or Build” business decisions
- Solve transportation and distribution issues.
- Create best, worst, and most-likely scenarios for sales
- Optimizing sales results.
- Summarizing data with Descriptive Statistics
- Analyzing data distribution against specification windows with Histogram
- Prioritizing vital areas to solve problems with Pareto diagram.
- Analyzing correlation with Scatter diagram
- Interpret the effects of price and advertising on sales
- Using Simple Regressions and Multiple Regressions
- Using control charts to determine level of service or operational process and quality control.
-
Real business data analysis exercises, scenarios &
case studies
-
Group discusions and practice business modeling
-
Hands-on using MS Excel templates, formula and statistical computations
**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 2007 (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
© 2014 MyTrainingProvider.com, All Rights Reserved. |
|
|
|