Effective Data Analysis Using Excel

Course Overview

Effective Data Analysis Using Excel

This course will equip learners with data analysis skills using Excel by applying the various formulae and functions available in Excel as well as using Power Pivot to connect to different and multiple data sources for statistical analysis.

Course Title

Effective Data Analysis Using Excel

Course Objectives

At Course Completion

• Apply principles of data modelling and visualization to create data models to identify and predict trends and patterns.
• Use data science techniques to perform data analysis on data sets.
• Apply data protection and legal guidelines to support the creation of business insight reports
• Apply DAX language to summarize data to provide business insights from data source.
• Apply statistical techniques and formulas to produce analytical dashboards and insight reports.
• Join multiple tables using unions to extract data analysis aligned to the domain context.
• Create clean required dataset with functions and formulas to visualize data.

Pre-requisites

• Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.
• Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3.
• Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3.
• Learners to have minimum GCE ‘O’ level or ITE certificate education
• Learner should have at least 1 year’s working experience in any industry.
• Be able to operate a computer.