Mining Data for Insights @ Work (Using Excel)

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 


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

Course Date

12 - 13 March 2020

11 - 12 June 2020

If you are not available for the dates above, we would like to hear from you by clicking here

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

*SkillsFuture Credit approved
Related Courses
Hot Links

Last updated on 13 Feb 2020

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.