Fundamental Data Analysis using Excel 2016

Course Dates:

Sep to Oct 2019

Run 25 : 16 to 17 September 2019 (Mon and Tue)

Confirmed

Registration : Open until 14 Sep 2019

Run 26 : 18  to 19 September 2019 (Wed and Thur)

Confirmed - FULL

Registration : Closed

Run 27 : 23 to 24 September 2019 (Mon and Tue)

Confirmed - FULL

Registration : Closed

Run 28 : 25  to 26 September 2019 (Wed and Thur)

Confirmed - FULL

Registration: Closed

Run 29 : 01  to 02 October 2019 (Tue and Wed) -

Confirmed - 3 Vacancies left

Registration :  OPne until 23 Sep 2019

 

Dec 2019

Run 30 : 12 to 13 December 2019 (Thurs and Fri) - Confirmed - FULL

Registration : Closed

Run 31: 16 to 17 December 2019 (Mon and Tue) - Confirmed

Registration Opening date : From 01 Aug 2019 to 01 Dec 2019

Run 32 : 18 to 19 December 2019 (Wed and Thurs) - confirmed

Registration Opening date : From 01 Aug 2019 to 01 Dec 2019

 

Duration:
16 hours / 2 days

Time:
9am to 6pm

Mode of Training:
Classroom

Venue:
Singapore Polytechnic


Course Introduction
Have you ever wondered how you could generate relevant information and gain insights from your data using Excel 2016? Become an Excel power user and increase your job efficiency by equipping yourself with emerging data analysis skills.

This fundamental data analysis course is designed to equip you with relevant Excel skills for the purpose of analyzing data in business applications.

You will learn how to import data from various sources, merge data and organize them for visual presentation, and analyze the data to gain insights to support decision making.


Course Objectives

By the end of the course, you will have:

An understanding of how to apply most commonly used statistical and lookup functions.
The ability to gather data and organize the data for analysis in business.
Knowledge in chart generation and interpretation.
The ability to build dashboards using PivotTables and PivotCharts.
Skills in using Excel What-If Analysis and Data Analysis tools for generating different scenarios of business environment and aiding decision making.


Course Outline

Collecting and Managing Business DataGetting external data from various sources.
Preparing data using text manipulation.
Using statistical functions and formulae.
Extracting data with lookup functions.
Formatting and conditional formatting.
Tapping into real data from the Internet for business analysis
Constructing ChartsPlotting different types of charts. Customizing charts for presentations. Using Sparklines.
Building Dashboard using PivotTables and PivotChartsUnderstanding and use of Excel tables.
Creating PivotTables to analyze worksheet data.
Creating dashboards using PivotCharts for visual presentation.
Adding Slicers and Timelines for interactive display.
Introducing multi-table PivotTables and data model.
Decision making using What-If AnalysisBuilding Data Tables. Building charts from Data Tables. Using Scenario Manager for reporting different scenarios. Exploring Data Analysis tools.
Hands-On PracticePracticing a list of tasks that help hone data analysis skills in generating required information.

Suitable for

Public Service Officer, Managers, Administrative Officers, Executives and general public


Minimum Entry Requirements / Assumed Skills and Knowledge

Basic computer skills. Prior knowledge of Microsoft Excel, although advantageous, is not necessary.


Award / Certification / Accreditation

Certificate of Performance (electronic Certificate will be issued)

Course Fees payable:

Singapore Citizens aged below 40 and Singapore PRsSingapore CitizensOthers
Non-SME sponsored1Sponsored by SME2Aged 40 and above3Aged 35 and above, and earn ≤ $2,000 per month
$118.77
(incl. GST)
$44.77
(incl. GST)
$44.77
(incl. GST)
$26.27
(incl. GST)
$395.90
(incl. GST)

Singaporeans aged 25 years and above may use **SkillsFuture Credit balance to offset respective course fees.
1 Under the Enhanced Training Support for Small & Medium Enterprises (SMEs) Scheme. For more information, click here
2 Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here.
3 Under the Workfare Training Support (WTS) scheme. For more information on the scheme, click here.

Funding Incentives

Please click here for more information on funding incentives.


 

Register Here
Eligible for SkillsFuture Credit

Terms and Conditions

Registration may be closed once seats are filled up  


Application Procedure

1. All applications must be made via Online Registration at www.pace.sp.edu.sg
Course fees can be paid by the following payment modes:

a) Credit Cards, Internet Banking, NETS (Not Applicable for company sponsored)
For e-payment using Visa/Master cards and Internet Banking, please click on the ‘Make e-Payment’ button on the acknowledgement page to proceed.

b) For NETS payment, you can pay at:
Singapore Polytechnic
PACE Academy

c) Cheques
Please make cheques payable to “Singapore Polytechnic”. Do cross the cheque and write the Registration Reference ID, Applicant Name and NRIC/FIN number at the back of the cheque. When you have completed required details, you may mail the cheque here.

Please note that an administrative charge of $15 will be imposed for any returned cheques from the bank or financial institution.

2. All successful applicants will be notified with a letter of confirmation via email.

Chat with us