Objectives of Data Interpretation & Analysis Training
- The objectives are to equip the participants with a sound grounding of Using Excel for day to day analysis of data.
- Many advanced concepts and features of Excel are highlighted to the students.
- Learn how to conduct surveys, collect data, and get to know the best practices in data collection, analysis and decision making.
- The key feature is the number of exercises and real life examples used in the 2 day workshop.
This course is intended for managers, data analysts and support staff from Sales, Service, Finance, Marketing, R&D and IT Departments, who are assisting the management in the presentation of charts, graphs, comparing past performance, doing forecasting, budgeting, trend analysis and decision making based on past and present data.
Certification:
Certificate of attendance would be given to participants.
Materials:
Notes in folders will be provided.
Class Size:
6-12 participants
Data Interpretation & Analysis Training
Quality & Decision Support Systems - Modelling and its relationship to management
- Types of problems, planning a study
Identifying Problems and Understanding Data - Surveys and their design aspects
- Discussions & Lab Exercises
Tables & Charts - Types of Charts, Tables
- Building Simple Models
- Pivot Tables and Advanced Excel Techniques
Descriptive Summary Measures - Correlation and Regression
- Correlation Analysis
- Correlation versus causation
- Summary Measures
Single Regression & Correlation - Stepwise Modelling
- Multiple and non-linear regression analysis
- Application of regression in Business
- Lab exercise
| Troubleshooting - Problem Simulation
- Application to Business / Management
- Lab exercise
Applications of Advanced Excel Techniques - What-if analysis
- Goal Seek
- Solver
- Application to Business / Management
- Lab exercise
Continuous Improvement - Total Quality Management
- Kaizen
- Six Sigma
- Holistic Approach to Continuous Improvement.
General Discussion on Applications in the real world |
Call (65) 6296-2995 or (65) 9066-9991 to enquire about the Data Interpretation & Analysis training course, or email to training@intellisoft.com.sg
You can Register Online for the Data Interpretation and Analysis using Excel Training.
SDF Funding is available to Singapore Companies (For company sponsored candidates). Call 6296-2995 for Details.
Course Dates: In-house customised Corporate Training for Data Interpretation and Data Analysis using Excel is available for a group of 8 or more participants.
We have conducted this training in Singapore, Malaysia, India, Egypt to name a few countries.
Contact us if you have a team of 8 or more data analysts interested in improving their data interpretation skills.
