UEN No.: 198802365N
course details
Duration and Time
Training Time
9am-6pm
Course Duration
8 HRS
Course Information
Course Reference Number
Funding Validity Period
Mode of Training
Classroom
COURSE OVERVIEW
This course equips participants with the skills to use Excel tools effectively for creating spreadsheet solutions and performing statistical analysis. It is ideal for individuals who need to manage and analyse data using Microsoft Excel.
Participants will learn to effectively manage and analyse data using PivotTables and PivotCharts in Microsoft Excel. They will gain skills in creating, modifying, and summarising data in PivotTables, using custom calculations and formulas, grouping data, and comparing values. Additionally, they will learn to create and enhance PivotCharts, and efficiently print both PivotTables and PivotCharts.
This course is intended for participants who need to master the various commands available in Microsoft Excel’s PivotTable and PivotChart in order to summarise, analyse and create reports.
• Learners must be able to read, write, speak and listen to English at secondary school level
• Learner should have working knowledge of Microsoft Excel
Download the PDF below for a summary of the course outline.
COURSE FEES
Company Sponsored
Funding Type | Full Fee | 9% GST (on full course fee) | Funding Amount | Nett Fee Payable (incl. GST) |
---|---|---|---|---|
Small Medium Enterprises (SMEs) | $300.00 | $27.00 | $210.00 (70% off course fee) | $117.00 |
Non Small Medium Enterprises | $300.00 | $27.00 | $150.00 (50% off course fee) | $177.00 |
Singaporean Employees aged 40 years and above | $300.00 | $27.00 | $210.00 (70% off course fee) | $117.00 |
Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee
$4.50 per training hour capped at $100,000 per enterprise per calendar year
Self-Sponsored
Funding Type | Full Fee | 9% GST (on full course fee) | Funding Amount | Nett Fee Payable (incl. GST) |
---|---|---|---|---|
Singapore Citizens (40 years and above) | $300.00 | $27.00 | $210.00 (70% off course fee) | $117.00 |
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) | $300.00 | $27.00 | $150.00 (50% off course fee) | $177.00 |
Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee
Related Courses
Have an enquiry? Feel free to connect via any of the channels below.
Leave a message
Chat on WhatsApp at
+65 8767 0614
Give us a call at
+65 6737 5761
Offering an extensive range of courses conducted by our pool of accredited trainers, we take pride in providing training solutions to meet your learning and professional objectives.