Advanced Certificate in Spreadsheet Analytics (ACSA)

Analytics & Tech
Innovation & Business Improvement

Basic
SkillsFuture
Short Courses

This programme is conducted on-campus.

Next course starts on

To be advised

Fee

SGD10,464* (as low as SGD1,219.20 after maximum funding) Learn More

Duration

3 days
Weeknights (7pm - 10:30pm)
Saturday (9am - 6pm)

Level

Basic

Who Should Attend

Business Managers
Business Owners
Data Center Executives
E-Commerce Executives
Finance Executives
Marketing Executives
Professionals

PREREQUISITES

Participants with at least a diploma qualification and should have basic computer literacy.
Software Requirement Specification
1. Microsoft Windows 10 or 11 (MacOS not supported)
2. Microsoft Office
  
  2.1 Windows Version ONLY
  - Microsoft 365 (previously known as Office365) SAAS versions
  - Microsoft Office 2019 or newer versions (Home & Student, Home & Business, Standard, Professional and Professional Plus)
  - Microsoft Office 2016 and older versions not supported
  2.2 Mac versions NOT supported
Hardware Requirements: 4GB RAM and above, 1GB hard disk space (For Power BI Desktop installation)

Overview

Spreadsheets are ubiquitous in organisations. As the data in organisations continues to grow, relying on spreadsheet-based tools for complex analytics becomes time-consuming, cumbersome, and prone to expensive errors. This six-module programme will equip learners with the business analytics with a solution that offers repeatability, transparency and automation.

Learning Objectives

Automate mundane data tasks to save time and increase your capacity for deeper analysis
Instantly validate the health, quality, and statistical distribution of your data as you work
Create compelling dashboards + reports for communicating results to stakeholders

Topic/Structure

To achieve the Advanced Certificate in Spreadsheet Analytics (ACSA), participants will need to complete the following modules offered by SMU Academy:

Foundations of Business Analytics and Artificial Intelligence (AI): Concepts and Frameworks
Data Querying and Wrangling: Power Query and ChatGPT Integration
Creating and Using Databases with Power Pivot & ChatGPT
Advanced Techniques in Business Analytics using Data Analysis Expressions (DAX) & ChatGPT
Creating and Using Business Dashboard Visualisations for Decision Support using Power BI and Artificial Intelligence (AI) Co-Pilots
Task Automation with Macros, VBA and AI Co-Pilots

Assessment

As part of the requirement for SkillsFuture Singapore, there will be an assessment conducted at the end of every module. The mode of assessment, which is up to the trainer’s direction, may be an online test and assignment.

Participants are required to attain a minimum of 75% attendance and pass the associated assessment for each of the 6 modules within 3 years in order to be awarded the digital Advanced Certificate in Spreadsheet Analytics issued by Singapore Management University.

Calculate Programme Fee

Fee Table

COMPANY-SPONSORED

PARTICIPANT PROFILE

SELF-SPONSORED

SME

NON-SME

Singapore Citizen < 40 years old

Permanent Resident

LTVP+

$3,139.20

(After SSG Funding 70%)

$1,219.20

(After SSG Funding 70%
+ ETSS Funding 20%)

$3,139.20

(After SSG Funding 70%)

Singapore Citizen ≥ 40 years old

$1,219.20

(After SSG Funding 70%
+ MCES Funding 20%)

$1,219.20

(After SSG Funding 70%
+ ETSS Funding 20%)

$1,219.20

(After SSG Funding 70%
+ MCES Funding 20%)

International Participant

$10,464

(No Funding)

$10,464

(No Funding)

$10,464

(No Funding)

All prices include 9% GST

Please note that the programme fees are subject to change without prior notice.

Post Secondary Education Account (PSEA)
PSEA can be utilised for subsidised programmes eligible for SkillsFuture Credit support. Click here to find out more.

Self Sponsored

SkillsFuture Credit: Singapore Citizens aged 25 and above may use their SkillsFuture Credits to pay for the course fees. The credits may be used on top of existing course fee funding.

This is only applicable to self-sponsored participants. Application to utilise SkillsFuture Credits can be submitted when making payment for the course via the SMU Academy TMS Portal, and can only be made within 60 days of course start date.

Please click here for more information on the SkillsFuture Credit. For help in submitting an SFC claim, you may wish to refer to our step-by-step guide on claiming SkillsFuture Credits (Individual).
Workfare Skills Support Scheme: From 1 July 2023, the Workfare Skills Support (WSS) scheme has been enhanced. Please click here for more details.

Company Sponsored

Enhanced Training Support for SMEs (ETSS)

Organisation must be registered or incorporated in Singapore
Employment size of not more than 200 or with annual sales turnover of not more than $100 million
Trainees must be hired in accordance with the Employment Act and fully sponsored by their employers for the course
Trainees must be Singapore Citizens or Singapore Permanent Residents
Trainees must not be a full-time national serviceman
Trainees will be able to enjoy ETSS funding only if the company's SME's status has been approved. To verify your SME's status, please click here.

Please click here for more information on ETSS.

Absentee Payroll

Companies who sponsor their employees for the course may apply for Absentee Payroll here. For more information, please refer to:

AP Guide (Non-SME Companies)
Declaration Guide (SME Companies)

Intake Information

MODULES	Next Intake (Weeknights & Saturdays)
Foundations of Business Analytics and Artificial Intelligence (AI): Concepts and Frameworks	12, 13 & 14 Sep 2024 [Registration Closed]
Data Querying and Wrangling: Power Query and ChatGPT Integration	19, 20 & 21 Sep 2024 [Registration Closed]
Creating and Using Databases with Power Pivot & ChatGPT	26, 27 & 28 Sep 2024 [Registration Closed]
Advanced Techniques in Business Analytics using Data Analysis Expressions (DAX) & ChatGPT	10, 11 & 12 Oct 2024 [Registration Closed]
Creating and Using Business Dashboard Visualisations for Decision Support using Power BI and Artificial Intelligence (AI) Co-Pilots	17, 18 & 19 Oct 2024 [Registration Closed]
Task Automation with Macros, VBA and AI Co-Pilots	24, 25 & 26 Oct 2024 [Registration Closed]