       |
Mastering Data Analysis with MS EXCEL Course
| Previous ‹‹ | » Next |
| 1. | TITLE OF TRAINING PROGRAMME |
|
Mastering Data Analysis with MS EXCEL Course |
|
| 2. | PROGRAMME REVIEW |
|
MS Excel is an important tool for data analysis. Many users had the impression that without using the VBA, the data analysis cannot be worked. The statement above shall be proven inaccurate, as the data analysis job could still be done effectively and efficiently. It is important to possess the best skills in data collection before commencing data analysis jobs. Irrespective of MS Excel version, the task of data collection could be performed by applying the same methodology. Being unable to master the VBA and all the functions in MS Excel is not a barrier in data collection. Base on the trainer’s experience, by mastering 35% of the MS Excel, about 90% of daily MS Excel jobs can be worked out. Another 10% shall be supported by using specified software, such as; ERP/MRP, statistical software. |
|
| 3. | TARGET GROUP |
|
Engineer, clerk, quality management staffs who are involved in the data collecting and analysis. |
|
| 4. | CONTENTS |
|
1. Introduction to MS Excel 2. Three Sheets Concept 3. How Does Excel Perform Like A System 4. Common mistake in data worksheet 5. Summary Report Preparation Pivot Table 6. Design Of Data Sheet 7. Example For Design A Excel System Table 8. Interpret The Data By Chart |
|
| 5. | LEARNING OUTCOME |
|
At the end of this training participants will be able to understand the following:- o Three sheet concept o Design a standard data sheet o Design a standard reference table o Data analysis by using pivot table o Data analysis by using function |
|
| 6. | CERTIFCATION (for programmes with certification) |
|
Certification from Training Provider |
|
| 7. | DURATION |
|
1 day [8 hours] |