Register Now for this Training
8, 9 Jul 2013
12, 13 Sep 2013
14, 15 Nov 2013



Current Promotions

PMP Exam Free Preview Session

May 28, 2013 - Tuesday @6:15pm and

June 11, 2013 - Tuesday @ 6:15 pm

 

 

 
 
 
 

Data Interpretation & Analysis


Course Duration: 2 Full Days Training on Analyzing Data Using Excel 2007/Excel 2010.

This course teaches the basic skills & techniques of gathering, presenting & interpreting data for decision making, analysing performance & continuous improvement of processes.

Classroom based lecture with hands-on training using Microsoft Excel, used as a statistical analysis tool.

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call (65) 6296-2995 for Details.


Course Objectives
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.
Target Audience

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

Course Outline

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

 

How to Register

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.

Intellisoft System Facebook Link Intellisoft System Linkedin Link Intellisoft System Youtube Link Intellisoft System Twitter Link Intellisoft System Blog Link

Course Enquiry

Select Your Course *
Course Date*
Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*  
Pass Type
No. of Participants*
Our Clients
Mindef Singapore Ministry of Manpower Nanyang Polytechnic National Heart Center Singapore National University Hospital NUS PSB Academy Richemont Standard Chartered Bank Singapore Polytechnic Singapore Land Authority StatsChipPac ST Electronics The RITZ Carlton At Sunrice AXA BNY Mellon Guthre HDB Johnson Control JTC Marina Bay Sands National Park Paypal Semdcorp Vodaphone Xilinx

 

Excel Training Testimonials

I learnt many new tips and techniques to cut down my time in using Excel - Manager, Diethelm Travel

 

Thanks for the excellent training material and step-by-step instructions. The trainer was very knowledgeable about Excel and answered all my questions patiently. - Sentosa Leisure Group.

The greatest strength of this workshop is the handson approach, and a bubbly trainer, which makes the training session much more enjoyable - Changi Airport Group.

Able to apply VLookup, Macros and Pivot Tables easily - M1

Improved my job productivity by 75% - ITE

Exercises and examples to help us understand the functions of Excel, and the pace is good - not too fast and not too slow - Vestas

 



Register Now for this Training
8, 9 Jul 2013
12, 13 Sep 2013
14, 15 Nov 2013