Mining Data for Insights @ Work

Knowledge is power, and the analysis of data yields much useful information. This course will give participants a strong foundation in manipulating accumulated data to gain useful insights. Participants will acquire the necessary skills and knowledge to conduct basic data analysis and present data more effectively.

Harness the power of data and gain perspectives you never thought available!

Laptops will be provided for the duration of the course.

Learning Objectives

By the end of the course, participants will be able to:

  • prepare and analyse data from spreadsheets

  • identify appropriate mathematical processes necessary to achieve a result in a spreadsheet

  • create mathematical formulas in a spreadsheet

  • describe relative and absolute cell referencing

  • devise formulas utilising relative and absolute cell references in formulas

  • explain mathematical and statistical functions and apply them in cell formulas

  • explain the use of tables for managing and analysing a group of related data

  • manage data through the use of tables

  • determine appropriate use of pivot tables to group and ungroup data

  • create a pivot table in Excel

  • classify explanatory and exploratory data visualisation

  • describe the various types of charts that can be used to present data visually

  • choose appropriate chart styles to represent data

  • use preview to view reports online

Who should attend?

Managers, professionals, executives and support staff involved in data collection, preparation and presentation for analysis and decision making.

Entry Requirement

Suitable for all levels of experience 

Certification

Participants will be awarded the Certificate of Attendance by Republic Polytechnic upon meeting 80% of attendance requirement. 

Course Date

21 - 22 March 2019
4 - 5 April 2019
13 - 14 June 2019
12 - 13 Sept 2019
3 - 4 Oct 2019

Course Duration

2 days

Course Venue

Republic Polytechnic

Full Course Fee (Others) Workfare Training Scheme (WTS)
Singapore Citizens aged 40 & above SME-employed Singapore Citizens & SPR Singapore Citizens aged below 40 OR Singapore PR
$545.70
$36.21
$54.57
$61.71
$163.71

*SkillsFuture Credit approved
Related Courses
Hot Links

Last updated on 16 Jul 2019

Need more help?

If you are still unsure about which course to pursue, please contact our Academy for Continuing Education.  

Fees quoted are inclusive of GST. Republic Polytechnic reserves the right to make changes to the course fees and application closing dates without prior notice. The commencement of each course is subject to a sufficient number of participants. All information is accurate at time of publishing.