Excel In Data Analysis
Training Provider: IMPACT MANAGEMENT SEMINARS PTE LTD
Course Reference: TGS-2022016584
S$250
Original: S$500
Save S$250
About This Course
Course to equip participants with the skills and knowledge to:
- Identify raw data for the stated purpose
- Validate data to ensure that it is suitable for analysis
- Use data cleaning techniques across data sets
- Engage stakeholders to determine format for presenting the data information.
What You'll Learn
Identify raw data for the stated purpose
- determine data requirements for the stated purpose
- understand types of data
- identify sources of data
- consider impact of organisational constraints
Validate data to ensure that it is suitable for analysis
- identify types of data that are stored in data systems
- create spreadsheets to verify data
- use of Excel tools: data tables, pivot tables, match, and concatenate
Use data cleaning techniques
- types of data cleaning techniques
- identify patterns, trends, correlations, and variations
- determine sample sizes for appropriateness
Engage stakeholders for presentation of data
- engage stakeholders
- understand limitations of data analysis
- determine format for presenting data
- determine data requirements for the stated purpose
- understand types of data
- identify sources of data
- consider impact of organisational constraints
Validate data to ensure that it is suitable for analysis
- identify types of data that are stored in data systems
- create spreadsheets to verify data
- use of Excel tools: data tables, pivot tables, match, and concatenate
Use data cleaning techniques
- types of data cleaning techniques
- identify patterns, trends, correlations, and variations
- determine sample sizes for appropriateness
Engage stakeholders for presentation of data
- engage stakeholders
- understand limitations of data analysis
- determine format for presenting data
Entry Requirements
able to speak, read, and write at a English proficiency level of ES WPLN L3 or equivalent
attitudes that include: a sense of responsibility, able to support and add value to business operation, being passionate in performing work activities
minimum education level: GCE 'N' Level
IT skills: basic knowledge of MS Excel
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from IMPACT MANAGEMENT SEMINARS PTE LTD
Course to equip participants with the skills and knowledge to: * recognise the importance of 'think-...
Program to equip participants with the skills and knowledge to generate viable service innovation id...
- Recognise the importance of 'Thinking Out of the Box' when performing work tasks
- Differentiate ...