Admissions Now Open for our Agentic AI Accelerator Program Register Now
Basics of Excel Analytics
This course is designed for learners who wish to use Microsoft Excel effectively. You will learn how use the various formulas and functions, create charts and tables to manage, transform and analyse data.
Upcoming Batches
Course Overview
Designed for professionals to master data analytics, automated reporting, and dynamic visual modeling using Microsoft Excel - turning complex financial datasets into actionable business insights.
IBF Aligned Framework: Standardized under official IBF Skills Framework guidelines for data analytics, financial modeling, and operational intelligence in financial services.
Multi-Sector Application: Tailored for Retail Banking, Corporate Operations, Finance, Accounting, Audit & Compliance, and Business Intelligence.
Practical Analytics Workflows: Build dynamic spreadsheets, perform complex multi-criteria lookups, and automate data cleansing using hands-on workplace scenarios.
Efficiency & Error Reduction: Eliminate repetitive manual calculations, minimize data-entry errors, accelerate reporting turnaround, and streamline decision-making.
Skills You'll Gain
Entry Requirements
- Workplace Literacy (Advanced Level) Level 4-5
Prerequisites & Knowledge
- Basic English literacy
- Basic knowledge of Computer Literacy
Join the Basics of Excel Analytics Program
Secure Your Future as a Data-Driven Finance Specialist
Apply NowIs This Program Right for You?
Business & Data Analysts
Analysts and associates looking to build a rock-solid analytics foundation, clean messy raw datasets efficiently, master logical formulas, and transform disorganized spreadsheets into high-impact executive insights.
Operations, Sales & Marketing Leads
Professionals needing to track team KPIs, evaluate campaign performance, streamline inventory and sales pipelines, and leverage dynamic Pivot Tables to optimize day-to-day workflow efficiency.
Corporate Finance, Strategy & Planning
Strategic professionals focused on building structured budget models, automating recurring reporting workflows, performing variance analysis, and using advanced lookup functions to support decision-making.
Project Managers & Team Leaders
Team leaders tasked with tracking project milestones, managing resource allocation, creating clear executive dashboards, and presenting data-backed progress updates to stakeholders.
What You Will Learn
A comprehensive curriculum designed to take you from foundational spreadsheet literacy to performing advanced data analytics and creating actionable insights across modern business and finance operations.
- In this module the learners will recap the main parts of the Excel Interface and learn the basic shortcuts required to navigate around Excel easily.
- In this module the learners will learn about the basic formulae and functions used in Microsoft Excel.
- In this module the learners will learn about various data transformation functions and will be able to apply the relevant function based on their use case with their own data.
- In this module the learners will learn the various lookup functions like VLOOKUP and HLOOKUP. The learners will also learn IFERROR to handle errors.
- In this module the learners will get a hands-on experience working on pivot table and the various components of pivot tables. The learners will also learn how to create charts which can further be used to create dashboards.
- In this module the learners will learn about features in Excel that can enhance data reports and analyse data to gather business insights.
Course Fees & Subsidies
Eligible Singaporeans and PRs can enjoy up to 70% IBF-STS funding support. *Participants must meet minimum attendance and assessment requirements.
| User Group | Course price before subsidy | After IBF Subsidy |
|---|---|---|
|
Singaporeans aged 40 and above
70% Funding Support
|
$708.50
($650 + 9% GST)
|
$253.50
save $455.00 (70%)
|
|
Singaporeans under 40 & PRs of all ages
50% Funding Support
|
$708.50
($650 + 9% GST)
|
$383.50
save $325.00 (50%)
|
|
Foreign nationals & Non-PRs
No Subsidies
|
$708.50
($650 + 9% GST)
|
$708.50
|
| Company-Sponsored Employees (FI / SFA FinTech) | Full Course Fee | Net Fee Payable |
|---|---|---|
|
Singaporeans aged 40 and above
MAS-regulated Financial Institutions or SFA-certified FinTechs
70% IBF-STS Subsidy
|
$708.50
($650 + 9% GST)
|
$253.50
save $455.00 (70%)
|
|
Singaporeans under 40 & PRs of all ages
MAS-regulated Financial Institutions or SFA-certified FinTechs
50% IBF-STS Subsidy
|
$708.50
($650 + 9% GST)
|
$383.50
save $325.00 (50%)
|
|
Non-FI / Non-SFA FinTech Companies
Corporates outside MAS-regulated financial sector
No Subsidies
|
$708.50
($650 + 9% GST)
|
$708.50
|
Ready to Upskill & Boost Your Career?
Join our Industry-Certified Programs and gain practical, hands-on skills that top employers demand today.
Get In Touch With Us!
Fill in your details below to receive program brochures & funding details.