PMP Exam Prep Tips

Receive PMP Exam Preparation Tips & Project Management Articles

Master Trainer Vinai's
articles are published in books,
magazines & newspapers

Our article in The Straits Times

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:


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

 

Intellisoft Training Calendar   
View the Latest Advanced Excel Training Schedule to reserve a seat.

Other Courses

Find out most popular courses
available at Intellisoft Systems

Course Enquiry
Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Number of Participants*

 

Our Clients

Large MNCs, Local Companies & SMEs have selected Intellisoft Systems as their Training Provider.

Some of our clients are M1, Bayer, 3M, DSO National Labs, OLAM International, National Healthcare Group, HP, NUS, ITE,  LTA, MOH and many more.

Home » IT Courses » Data Interpretation & Analysis

Data Interpretation & Analysis


Course Duration: 2 Days - Full Time Course on Analyzing Data (Singapore)

SDF Funding now Available for SME companies. Call 6296-2995 for Details.

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

Benefits of Data Interpretation & Analysis
  • The benefits are 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.

Day 1: Introduction

Quality & Decision Support Systems
* Modelling and its relationship to management
* Types of problems, planning a study
* Framing a hypothesis

Identifying Problems and Understanding Data
* Data Handling
* Sampling design
* Surveys and their design aspects
* Discussions & Lab Exercises

Tables & Charts
* Types of Charts, Tables
* Patterns & Behaviour
* Building Simple Models
* Pivot Tables and Advanced Excel Techniques

Descriptive Summary Measures
* Correlation and Regression
* Correlation Analysis
* Correlation versus causation
* Summary Measures

Probability & Distributions
* Statistical Analysis, Process & Control
* Application to Business / Management

Single Regression & Correlation
* Stepwise Modelling
* Multiple and non-linear regression analysis
* Application of regression in Business
* Lab exercise

Day 2: Statistical Inferences

* Time Series Analysis
* Filters
* Forecasting, prediction, estimation
* Cross correlogram
* Practical Application in Business / Management
* Lab exercise

Troubleshooting
* Problem Simulation
* Sensitivity analysis
* 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
 

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

Certification:
Certificate of attendance would be given to participants.

Materials:
Notes in folders will be provided.

Class Size:
5-10 participants

Course Dates: In-house customised Corporate Training is available for a group of 4 or more participants. Contact us if you have a team of 4 or more data analysts interested in improving their data interpretation skills.

Call (65) 6296-2995 or (65) 9066-9991 to enquire about the Data Interpretation & Analysis training course, or email to training@intellisoft.com.sg

Home | Contact Us | Join Us