Course Type: WSQ

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Target Audience

Pre-Requisites

Register For Power BI Training Course in Singapore

Some of the companies that experienced our trainings

Excel VBA Macro Software Design – TEMP

WSQ Excel VBA SkillsFuture Course at Intellisoft Singapore

Avail 70% WSQ, UTAP , SFEC, SkillsFuture*

Excel VBA Macros programming language allows users to do amazing stuff with Excel. They enjoy working at higher speeds and get tedious Microsoft Excel tasks done in mere seconds, completing intricate calculations accurately.

VBA is a flexible language, and its English-like syntax makes learning easy. VBA code saves time and increases accuracy by automating the routine and keeping things running at high accuracy and efficiency.

VBA is also one of the easiest ways to automate processes. It doesn’t require installing anything on the client’s computer with Excel. By writing the VBA code, employees increase their productivity and make themselves more valuable to current and future employers.

For tasks like data consolidation, data analysis, forecasting, or reporting, users can effectively automate a large portion of their work in areas such as Finance, Banking, Healthcare, Customer Service, and Management Reporting.

Learning Forms and Controls helps users to build User Interactive Windows or Forms, including getting the data from various sources and interacting with other applications.

In addition, VBA can automate most tasks, including report generation, creating a spreadsheet, calculating a large amount of data, and performing data analysis.

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Objectives

Upon completion of the course, learners will be to manage content & execute policies to better manage the content with Google Workspace.

This is a combined course, which actually consists of a google workspace course, google workspace training, google workspace course, google drive course, Google sheets course, Google docs course, google forms course, jamboard course, google Slides course, and much more.

In this Best Google Workspace course in Singapore, learners will delve into the dynamic world of content management using Google Workspace. From setting up organizational content management policies to posting engaging content, the course ensures a comprehensive grasp of effective content handling in Google Workspace.

Learners will also acquire skills to stay abreast of market offerings, using this knowledge to create compelling content within the Google Workspace ecosystem.

After the end of our Best Google Workspace course in Singapore, you will have the skills, knowledge and abilities to do the following tasks on your own:

Content management policies, guidelines and permissions on content management
Web content for deployment
Organization’s web properties and assets
Creation and curation of web content guidelines
Web content and platform management systems
Types of performance metrics of content management systems
Customer and visitor experience on web properties and assets
Types of market offerings on content management systems
Types of plug-ins to manage the organization’s web properties and assets
Implement content management policies, guidelines and permissions on content management
Post and update content on content management systems
Maintain web properties and assets to uphold standards on user experience
Maintain awareness of market offerings on content management systems
Report on metrics to measure performance of content management systems
Recommend the adoption of appropriate plug-ins to manage and maintain the organization’s web properties and assets
Generate ideas to improve customer and visitor experience on web properties and assets

Target Audience

This course is best suited for

professionals,
managers,
executives,
technicians,
Senior Leadership,
junior staff,
freelancers,
data entry operators,
web designers and
content creators.

Course Outline

Topic 1 Overview of Google Workspace

Setup Google Workspace for your organization
Post and update content on Google Drive
Manage web content on Google Drive

Topic 2 Google Workspace Contents and Assets

Create and Curate Google Docs, Sheets, Slides
Maintain Google Forms, Jamboard, Gmail, Calendar, Meet
Maintain Google Sites

Topic 3 Google Admin and Add-ons

Reports on key metrics of your organization)
Google workspace add-ons
Improve Google Workspace

Pre-Requisites

Minimum Entry Requirements
Knowledge and Skills
• Able to operate computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude
• Positive Learning Attitude
• Enthusiastic Learner

Experience
• Minimum of 1 year of working experience.
• Minimum 18 years old

Support

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

Venue:

All courses are conducted at:

190 Middle Road, 10-08 Fortune Centre, Singapore 188979. 5 mins walk from Bencoolen MRT station. Bugis, Rochor, Bras Basah MRT are nearby, within walking distance.

The venue is disabled-friendly.

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"

Michele Martin

HR Manager

“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"

Joy Tan

Project Engineer

How To Register

How To Register For Excel VBA Software Design Course in Singapore

Register for the 3 Days Excel VBA Macro Course today by simply clicking on the chosen course date available at the top of this page.

Need Help?
Call us at +65-6250-3575, SMS / WhatsApp: 9066-9991

Send an email to training@intellisoft.com.sg

We have regular public classes For Excel VBA Programming training each month, and Corporate Training can be arranged at your office too!

Note: This class uses a convenient and hands-on approach to gain Excel VBA Mastery. It requires you to take part in VBA programming exercises during the class. You can bring your own laptop or request to use our computer during the class beforehand.

WSQ Funded Excel VBA Training:

Join today, and begin to Master Excel VBA coding with our step-by-step instructions and helpful, patient Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

Accelerate Your Career With the Most Effective & Practical Training.

Training Course Fees & Funding

Full course fee: S$960.00 (before GST & government funding) TGS: TGS-2022016805

Highest Funding

70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

SG Citizens aged 40+ (Individual, SME or MNC)
SME-sponsored SG Citizens (21+)
SME-sponsored PRs (21+)

Course Fee S$960.00

SSG Funding (70%) − S$672.00

Nett Fee S$288.00

GST (9%) S$86.40

You Pay S$374.40

SkillsFuture Credit UTAP Funding* SFEC (Company)

SSG Funded

50% Grant

50% SSG Grant

Baseline WSQ Funding

SG Citizens aged 21–39 (Individual or MNC)
MNC company-sponsored PRs (21+)
Individual PRs (21+)

Course Fee S$960.00

SSG Funding (50%) − S$480.00

Nett Fee S$480.00

GST (9%) S$86.40

You Pay S$566.40

SkillsFuture Credit UTAP Funding* SFEC (Company)

Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$960.00 + 9% GST = S$1,046.40 applies. Contact us for more details.

Additional Funding Options

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

Advanced Data Analytics and Data Visualization with Excel – TEMP

Data Analysis & Visualization through Infographics creation course in Singapore

Create Dynamic Dashboards in Excel
Quickly & Easily

The Advanced Data Analytics & Data Analytics with Excel will elevate your skills to Excel Mastery.

In this 2 Day Advanced Data Analytics course, you will learn how to do:

Statistical Analysis in Excel,
Forecasting with Excel,
Using Correlation & Regression for detecting underlying Trends,
Creating Dynamic Dashboards & Charts,
Advanced Pivot Table Technique for Management Reporting
How to combine data from multiple worksheets to do data analysis,
Creating self-updating charts, reports & dashboards,
Performing Scenario Analysis for multi-variate testing & forecasting,
PLUS, many more techniques to filter the noise, and visualize the data for Better Decision Making

You should know Excel well to join this course, and it will help you to get closer to Excel mastery.

Now, With up to 70% WSQ Grant*

Analyze & Visualize Data like a Pro
with Hidden Excel Features

WSQ Grant of up to 50-70%

A good visualization tells a story, removing the noise from data and highlighting useful information, curating data into a form easier to understand, and highlighting the trends and outliers.

Advanced Data Analytics and Visualization course using Microsoft Excel, helps build complex models, making it easy to reach meaningful conclusions, and simplifies the decision-making process.

Companies can then use these insights to identify areas to improve upon and factors that influence customer satisfaction and make better predictions for sales and growth.

Data storytelling helps the data feel alive and ensures that the message it’s conveying is meaningful and relevant, by balancing logic and facts with the emotional impact of a story, companies can better engage their audiences and enhance interactions with their customer base during business events.

By the end of this practical business intelligence with Excel course, you will be able to apply advanced data analytics and data visualization techniques to identify underlying trends and patterns in data with Microsoft Excel.

Data Interpretation Analysis training at Intellisoft Singapore — Data Analysis & Visualization training at Intellisoft Singapore

Learning Data Science, Data Visualization & Data Analysis are critical skills in gaining a deeper understanding of your data and making better decisions. They help in analyzing the performance of the business & continuous improvement of processes.

This course covers a number of Statistical Data Analysis Techniques for Predictive Analytics, Data Mining, Advanced Data Visualization Techniques & much more… all using Microsoft Excel. Each method is demonstrated with examples & exercises for your own business analytics.

Intellisoft offers WSQ funded, UTAP supported SkillsFuture Credits Ready Courses in Singapore

This is the highest level of Microsoft Excel MasterClass to learn advanced Data visualization & Business Analytics.

Classroom-based lectures with hands-on exercises on analyzing data using Microsoft Excel are used in this workshop to analyze & visualize data and find meaningful information. Data and business analytics provide valuable insights to management.

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Objectives

Excel Data Analysis Training in Singapore at Intellisoft Systems

Excel Data Analysis Course in Singapore at Intellisoft Systems, Singapore[/caption]

Data visualization allows business users to gain insight into their vast amounts of data.

It benefits them to recognize new patterns and errors in the data.

The main goal of data visualization is to make it easier to identify patterns, trends and outliers in large data sets.

Making sense of these patterns can lead to enhanced quality and speed of decision-making processes, as well as measurable increases in productivity and efficiency.

Analyze Data With Charts to identify trends

The objective of this Advanced Data Analytics & Data Visualization training is to help companies in using business intelligence tools to turn raw data into consumable insights, making it a powerful tool people can use to make better, data-driven decisions.

In this course, learners will learn how to leverage the power of Excel to organize and summarize data. They will learn how to use Trend Analysis, Advanced Pivot Table Techniques and Advanced charts to summarize data in a dynamic way based on a selection of values from a list or other Pivot tables.

Data Interpretation & Analysis training at Intellisoft

The course covers Advanced Excel Data Analytics & Data Visualization Topics, like:

Best Excel functions for deeper data analysis, data mining & business analytics
Tips for cleansing, transforming & modelling data,
Sensitivity Analysis with Data Tables,
Goal Seek Find the missing pieces,
Advanced Excel Visualisation Techniques using Multiple Charts, Pivots & Slicers
Data Modeling & Linear Regression for Predictive Analysis
Creation of Excel Dashboards for Business Intelligence & Management Reporting of Insights

Learn The Secrets of Data Analytics With Excel, & Become a Power Ninja Data Analyst!

Target Audience

Data Analyst reviewing data insights Most data analysts, managers, decision-makers, and even end users typically struggle with report creation as they lack knowledge of features such as data analysis, data cleanup, advanced pivot tables techniques, and visualization techniques within Excel.

With this WSQ course, we target such people and will help such people learn advanced data analytic and data visualization techniques to organize data better and represent the same in both a dynamic tabular and chart format.

After attending this WSQ Advanced Excel Data Analytics & Visualization course, our audience will be better able to:

Organize data within excel in a “normalized” way to create dynamic reports.
Create Pivot tables and charts that provide a dynamic view of data based on slider selections.
Create infographics summaries that are linked to the analyzed data and Pivot tables.

Course Outline

Advanced Data Analytics & Data Visualization Course With Excel
Course Outline

This is a very practical, hands-on, and insightful course, full of advanced Excel techniques to bring in the data, analyze it quickly, identify trends, and visualize the information in charts, graphs and dashboards.

Data Analysis & Visualization Training in Singapore at Intellisoft With WSQ Funding

Module 1: Data Modeling Using Pivot Tables & Pivot Charts

Introduction to Data Modeling
Data Filtering & Transformation
Use Pivots to identify patterns across multiple data sets
Visual Analysis with Pivot Charts

Module 2: Solver and Scenarios to Manage Multiple Constraints

Managing Multiple Constraints
Proof of concept using Data Solver
Decision Making using Scenarios

Module 3: Data Modeling & Linear Regression for Better Forecasts

Data Modeling Principles
Building a Model With Excel
Using Linear Regression

Module 4: Data Mining and Goal Seek To Derive Business Insights

Data Mining With Lookup Functions
Business Insights From Goal Seek
Advanced Use Cases for Data Mining With Excel Functions

Module 5: Statistical Analysis and Data Visualization Dashboards

Key Principles of Data Visualization
Presentation of qualitative data-driven visualization
Statistical analysis of data

Learn The Secrets of Data Analysis With Excel Today in Singapore.

Join This Practical Training
To Get Ahead With Advanced
Business Data Analysis & Visualization.

data analysis course

Learn The Best Excel Functions & Features for Data Analytics!

Business Data Analytics With Excel Course Trainer:

Advanced Data Analytics and Data Visualization with Excel Training at Intellisoft.

This Excel Data Analysis course is created and delivered by Vinai Prakash, Master Trainer & Founder of Intellisoft Systems.

Vinai has authored several articles on Data Analysis, Excel Dashboarding Techniques, Data Warehousing, Data Mining, Using SQL Databases for Creating Data-Rich applications, published in leading magazines, newspapers & books.

Click Here to Download The 8 Habits of Highly Effective Data Analysts(An article written by Vinai Prakash, published in The Straits Times Newspaper in Singapore)

Pre-Requisites

It would be great if you have good knowledge of Excel and could write simple formulas like SUM, IF, Create Bar Charts and use Excel on a regular basis for basic analysis and reporting.

Good knowledge and experience in using Excel on a regular basis.
Familiarity with Basic Excel functions is a must.
A passion for acquiring Data Analysis Superpowers.
Note: Anyone with Database, Business Intelligence, IT Programming, or similar experience are pretty qualified to take this course, even if lacking in everyday Excel experience.

Microsoft Excel software is available for download from the Microsoft website as a subscription. We will provide you with a copy of Microsoft Excel for use in the class, on our laptops.

Support

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

Michele Martin

HR Manager

Joy Tan

Project Engineer

How To Register

How To Register For Advanced Data Analytics & Data Visualization With Excel Course in Singapore

Register for the 2 Days Advanced Excel Data Analytics & Data Visualization MasterClass Course today by simply clicking on the chosen course date available at the top of this page.

Need Help?
Call us at +65-6250-3575, SMS / WhatsApp: 9066-9991

Send an email to training@intellisoft.com.sg

We have regular public classes For Advanced Data Analytics & Visualization With Excel MasterClass each quarter, and Corporate Training can be arranged at your office too!

Note: This class uses a convenient and hands-on approach to gain Excel Analytics & Visualization Mastery. It requires you to take part in Data Analysis & Data Visualization exercises during the class. You can bring your own laptop or request to use our computer during the class beforehand.

WSQ Funded Data Analytics and Visualization With Microsoft Excel Training:

Join today, and begin to Master Excel Data Analytics with our Step-by-step instructions and helpful, patient, Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

Accelerate Your Career With the Most Effective & Practical Training.

Excellent workshop. Great and Patient Trainer! I am able to clean up the data, using lookup functions more efficiently, and Pivot table analysis & visualization was the best. Mr Vinai is great, he's a real expert in Excel and look forward to attending more of his sessions.

Being able to concisely explain formulas and techniques in a short time and stay relevant is the highlight. We loved the real-world exercises that helped us hone our business analysis skills. The trainer is very passionate about sharing his knowledge and keeps the lessons relevant.

Training Course Fees & Funding

Full course fee: S$900.00 (before GST & government funding) TGS: TGS-2022017399

Highest Funding

70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

SG Citizens aged 40+ (Individual, SME or MNC)
SME-sponsored SG Citizens (21+)
SME-sponsored PRs (21+)

Course Fee S$900.00

SSG Funding (70%) − S$630.00

Nett Fee S$270.00

GST (9%) S$81.00

You Pay S$351.00

SkillsFuture Credit UTAP Funding* SFEC (Company)

SSG Funded

50% Grant

50% SSG Grant

Baseline WSQ Funding

SG Citizens aged 21–39 (Individual or MNC)
MNC company-sponsored PRs (21+)
Individual PRs (21+)

Course Fee S$900.00

SSG Funding (50%) − S$450.00

Nett Fee S$450.00

GST (9%) S$81.00

You Pay S$531.00

SkillsFuture Credit UTAP Funding* SFEC (Company)

Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$900.00 + 9% GST = S$981.00 applies. Contact us for more details.

Additional Funding Options

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

Practical Skills to Clean, Analyze & Visualize Data

🔧 Data Cleanup (Preparing Your Data for Analysis)

Master practical Excel techniques to ensure your data is clean, consistent, and analysis-ready. Learn how to:

Detect and remove duplicate rows and inconsistent or missing data
Use TRIM, CLEAN, FIND & REPLACE to standardize text formats
Apply LEFT, RIGHT, MID, and FIND functions to extract values from text
Use Data Tools to remove duplicates and Advanced Filter to extract unique records
Format dates consistently and clean up invalid or irregular entries
Convert cross-tab reports into proper tabular format
Correct inaccurate values and update missing information efficiently
Use Excel Tables with filters to explore and correct data issues.

🎯 These skills ensure you’re always working with accurate, clean data – the foundation of every good analysis.

📊 Data Analysis (Extracting Insights from Data)

Develop strong analytical skills using Excel’s powerful formulas and tools. You will learn how to:

Use XLOOKUP, VLOOKUP, OFFSET, INDEX & MATCH to fetch and combine data from multiple sources
Apply COUNTIFS, SUMIFS, and logical functions to summarize and evaluate complex data sets
Use TEXTJOIN, TEXTSPLIT, and TRANSPOSE for advanced data manipulation
Analyze work schedules with date functions like NETWORKDAYS, WORKDAY, TEXT
Handle errors with formulas like IFERROR, and understand Excel error types
Work with 3D References and Data Modeling Techniques to consolidate data across multiple sheets
Use Range Names for cleaner formulas and easier navigation.

🔍 By mastering these tools, you’ll be able to extract insights, solve problems, and make confident decisions from your data.

📈 Data Visualization (Presenting Data Effectively)

Turn your raw data into meaningful visuals and dashboards. You’ll be able to:

Create dynamic Pivot Tables and advanced summaries
Add Slicers and Timelines for interactive data filtering
Build dashboards with Excel Tables, custom filters, and visuals
Design impactful charts – bar, column, line, and pie – to tell your data story
Perform Pareto analysis to identify top contributing factors and solve problems
Use Conditional Formatting to highlight trends, outliers, and insights at a glance
Optimize Excel Table Design for professional and structured reporting

📊 These skills will help you present your findings clearly, impress stakeholders, and support data-driven decisions.

✅ Why Join This Excel Data Analytics Course?

Whether you’re in HR, finance, operations, or marketing – you’ll walk away with job-ready Excel skills to clean, analyze, and visualize data like a pro. If you’ve ever felt frustrated with messy spreadsheets or unsure how to get insights from raw data, this course will empower you with real-world techniques that make a difference.

Infographics & Data Visualization with Excel – TO BE DELETED

Excel training at Intellisoft in Singapore

Learn to Analyze & Visualize Data With Infographics & Pivot Tables

Up To 70% WSQ Grant. Use SkillsFuture & UTAP to offset the balance.

Learn Advanced Excel Skills to Save Time & Impress
Achieve More with Data Analysis & Visualizaiton Tricks

What Will You Learn in this Advanced Excel Training?

Create Infographics & Visualize Data
With Advanced Excel Tricks: Course Overview

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Course Objectives

Target Audience

Course Outline

Pre-Requisites

Training Course Fees & Funding

Full course fee: S$750.00 (before GST & government funding) TGS: TGS-2023017925

Highest Funding

70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

SG Citizens aged 40+ (Individual, SME or MNC)
SME-sponsored SG Citizens (21+)
SME-sponsored PRs (21+)

Course Fee S$750.00

SSG Funding (70%) − S$525.00

Nett Fee S$225.00

GST (9%) S$67.50

You Pay S$292.50

SkillsFuture Credit UTAP Funding* SFEC (Company)

SSG Funded

50% Grant

50% SSG Grant

Baseline WSQ Funding

SG Citizens aged 21–39 (Individual or MNC)
MNC company-sponsored PRs (21+)
Individual PRs (21+)

Course Fee S$750.00

SSG Funding (50%) − S$375.00

Nett Fee S$375.00

GST (9%) S$67.50

You Pay S$442.50

SkillsFuture Credit UTAP Funding* SFEC (Company)

Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$750.00 + 9% GST = S$817.50 applies. Contact us for more details.

Additional Funding Options

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What an insight into Infographics & Data Analysis. The trainers make sure we learn the steps and do it on our own. I will come back for more practical training"

Daniel Martin

Sales Director

“The training was everything I hoped for, and more. I would have never discovered the hidden infographic features of Excel on my own. Thanks a lot Intellisoft !"

Patrick Han

Finance Controller

How To Register

Accelerate your Career With the Most Effective Training!

Basic Data Analytics with Excel for Beginners

Advanced Excel training at Intellisoft Singapore

Basic-Intermediate Excel Course (WSQ Funded)

Use 70%* WSQ Grant, SkillsFuture & UTAP

What Will You Learn in Basic Data Analytics Course with Excel?

Learn Excel Fundamentals To Save Time & Improve Productivity

WSQ Grant of up to 50-70%

The process of analyzing a data set for patterns and identifying which variables and values are most relevant through data transformation and mining. Data analysis is the foundation of good business decisions and effective action.

Hence this Beginners course in Microsoft Excel will start with an overview of data analytics strategy aligned to the organization’s overall data analytics metrics for various products and services.

Then the participants will learn to use Excel for data preparation.

After learners learn Excel’s basic data preparation techniques, they can proceed to data analysis and visualization using Microsoft Excel for business.

Master Excel To Get Work Done Fast,
Create Tables, Formulas, Charts, Sort, Filter & Visualize Like a Pro...

Learn Basic-Intermediate Excel (Course Outline)

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Objectives

Objectives WSQ Course for Beginners in Excel in Singapore:

Upon completion of the Basic Excel for Beginners course, you will be able to perform basic analytics with Excel. You will be able to understand better customer activities and behavior using Excel for business. Effective visualization techniques with charts enhance the data understanding and make it easier to report the data analytics findings.

Basic-Intermediate Excel 2019 Training @Intellisoft — Basic Excel Fundamentals with Microsoft 365Training @Intellisoft

Improve your productivity and efficiency with the new time saving features in Excel 365.

A very Practical, Hands – on approach to learning Excel – by doing exercises, and learning simple tips and tricks in the class.

The class is taught by Certified, Experienced Microsoft Trainers with years of experience in using Microsoft Excel.

Learn Microsoft Excel tips & techniques that will make your work faster, efficient, and you will be able to do complex tasks in a matter of minutes.

Target Audience

This program is highly recommended for those who want to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use Microsoft Excel for keying in, manipulating, analysing, visualizing and reporting data easily.

Be prepared to do a lot of Hands-On Exercises on Excel to learn the new concepts and shortcuts, tips & techniques of Microsoft Excel. This is what makes this Excel Training program unique and beneficial for you.

Course Outline

Section 1: Data Preparation

Lesson 1: Data & Corporate Strategy: Introduction to Microsoft Excel

Understanding Organization’s product and services
Current and emerging data analytics tools and technology trends
The need for Microsoft Excel

Lesson 2: Introduction to Excel for Business

Getting Started with Excel
Using the Ribbon as the Excel User Interface
Navigating within the Worksheet
Selecting a Cell or Range of Cells
Entering Data
Cutting, Copying, and Pasting Cell Values
Copy and Paste Special
Saving & Opening your Workbook

Lesson 3: Managing Rows & Columns in Excel

Inserting, Moving & Deleting Cells
Managing Columns and Rows
Hide and Unhide Rows & Columns
Changing Column Width & Row Height

Lesson 4: Organize and Prepare Data

Format Worksheet Tabs
Insert and Delete Worksheet
Move and Copy Worksheet
Hide & Unhide Worksheet

Lesson 5: Formatting Cells in Excel

Formatting the Cell
Number and Date Formatting
Finding and Replacing Text
Spell Check

Section 2: Data Operations & Data Analysis in Excel

Lesson 6: Formulas & Functions of Microsoft Excel

Excel Arithmetic Operators & Order of Operations
Using Auto Fill Options
Using Basic Functions
Writing simple & practical Formulas on your own
Absolute Referencing

Lesson 7: Basic Data Analysis With Tables, Sorting, Filtering, Summary Information

Create and Modify Tables
Sorting and Filtering Data in a Table
Getting Summary Information in a Table
Formatting a Table For Reporting

Lesson 8: Large Workbooks & Reporting

Managing Large Workbooks
Printing Worksheets
Setting Page Setup Options
Setting Page Breaks

Section 3: Data Visualization

Lesson 9: Creating Charts For Data Visualization

Summarizing Data Visually Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Change the Chart Body
Creating a Pie Chart
Using Chart Titles & Placing Charts

Lesson 10: Evaluate Data Analysis Findings

Tables
Visualizations
Reports

Pre-Requisites

Basic knowledge of computers, using the keyboard, mouse and Windows is required.

This is a beginner-level program, so we will teach you all about getting started with Excel, and then how to get the most out of it for day-to-day use at your office or home.

All you need is basic PC skills to make the most of this Basic Data Analytics course with Excel Training Course.

Please Note that:

Participants must sit & pass the short assessment at the end of the training to be eligible for the WSQ grant.
At least 75% of attendance is required by SSG to be eligible for the WSQ funding.
Participants will receive a WSQ certificate of Attainment upon successful completion of training and assessment.

Support

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Training Course Fees & Funding

Full course fee: S$485.00 (before GST & government funding) TGS: TGS-2023017924

Highest Funding

70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

SG Citizens aged 40+ (Individual, SME or MNC)
SME-sponsored SG Citizens (21+)
SME-sponsored PRs (21+)

Course Fee S$485.00

SSG Funding (70%) − S$339.50

Nett Fee S$145.50

GST (9%) S$43.65

You Pay S$189.15

SkillsFuture Credit UTAP Funding* SFEC (Company)

SSG Funded

50% Grant

50% SSG Grant

Baseline WSQ Funding

SG Citizens aged 21–39 (Individual or MNC)
MNC company-sponsored PRs (21+)
Individual PRs (21+)

Course Fee S$485.00

SSG Funding (50%) − S$242.50

Nett Fee S$242.50

GST (9%) S$43.65

You Pay S$286.15

SkillsFuture Credit UTAP Funding* SFEC (Company)

Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$485.00 + 9% GST = S$528.65 applies. Contact us for more details.

Additional Funding Options

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

Some of the companies that experienced our trainings

“The expert trainers really made a difference. I would have never discovered so many shortcuts, tips & tricks of Excel on my own! The training was everything I hoped for, and more..."

Michele Martin

Project Engineer

"What I love about this training is that the trainers made sure we practice the steps on our own. The practical exercises & examples helped a lot. I will definitely come back for more trainings"

Joy Tan

HR Manager

How To Register

How To Register For Learning Basic-Intermediate Excel in Singapore

Register for the 2 Days Excel Basics today by simply clicking on the chosen course date available at the top of this page.

Need Help?

Call us at 6250-3575, WhatsApp: 9066-9991
Send an email to training@intellisoft.com.sg OR
Submit an online enquiry if you have any questions regarding Excel Basic Data Analytics training.

We have regular public classes For Excel Training each month, and Corporate Training can be arranged at your office too!

Note: This class is a very practical, and hands-on workshop session. It requires you to take part in Excel exercises during the class. A laptop with Excel pre-loaded is provided to each participant for use during this workshop.

SkillsFuture Microsoft Excel Training:

Join today, and begin to Master Excel with our Step-by-step instructions and helpful, patient, Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

Accelerate your Career With the Most Effective Training!

Google Workspace Content Management

SkillsFuture Google Workspace Training Course with 70% WSQ Funding

Learn Google Drive, Docs, Slides & Sheets with WSQ Funding

The Best WSQ Funded Google Workspace Course which teaches you how to master Google Drive, Google Docs, Google Sheets, Google Forms, Google Slides, and Much More.

All this with up to 70% WSQ Funding for locals & companies in Singapore.

Join Today and Master Google to Enhance Your Efficiency & Productivity at Work!

Learn to Manage all your data in the Google Cloud Easily!

Training Course Fees & Funding

Full course fee: S$600.00 (before GST & government funding) TGS: TGS-2023039928

Highest Funding

70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

SG Citizens aged 40+ (Individual, SME or MNC)
SME-sponsored SG Citizens (21+)
SME-sponsored PRs (21+)

Course Fee S$600.00

SSG Funding (70%) − S$420.00

Nett Fee S$180.00

GST (9%) S$54.00

You Pay S$234.00

SkillsFuture Credit UTAP Funding* SFEC (Company)

SSG Funded

50% Grant

50% SSG Grant

Baseline WSQ Funding

SG Citizens aged 21–39 (Individual or MNC)
MNC company-sponsored PRs (21+)
Individual PRs (21+)

Course Fee S$600.00

SSG Funding (50%) − S$300.00

Nett Fee S$300.00

GST (9%) S$54.00

You Pay S$354.00

SkillsFuture Credit UTAP Funding* SFEC (Company)

Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$600.00 + 9% GST = S$654.00 applies. Contact us for more details.

Additional Funding Options

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

In this course, learners will delve into the dynamic world of content management using Google Workspace.

From setting up organizational content management policies to posting engaging content, the course ensures a comprehensive grasp of effective content handling in Google Workspace.

Students will also acquire skills to stay abreast of market offerings, using this knowledge to create compelling content within the Google Workspace ecosystem.

You will gain knowledge of using Google Forms, Google Docs, Google Sheets, Google Calendar, Gmail, Meet, Google Workspace, Google Drive, Jamboard, and much more.

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Objectives

Upon completion of the course, learners will be to manage content & execute policies to better manage the content with Google Workspace.

Learners will also acquire skills to stay abreast of market offerings, using this knowledge to create compelling content within the Google Workspace ecosystem.

After the end of our Best Google Workspace course in Singapore, you will have the skills, knowledge and abilities to do the following tasks on your own:

Content management policies, guidelines and permissions on content management
Web content for deployment
Organization’s web properties and assets
Creation and curation of web content guidelines
Web content and platform management systems
Types of performance metrics of content management systems
Customer and visitor experience on web properties and assets
Types of market offerings on content management systems
Types of plug-ins to manage the organization’s web properties and assets
Implement content management policies, guidelines and permissions on content management
Post and update content on content management systems
Maintain web properties and assets to uphold standards on user experience
Maintain awareness of market offerings on content management systems
Report on metrics to measure performance of content management systems
Recommend the adoption of appropriate plug-ins to manage and maintain the organization’s web properties and assets
Generate ideas to improve customer and visitor experience on web properties and assets

Target Audience

This course is best suited for

professionals,
managers,
executives,
technicians,
Senior Leadership,
junior staff,
freelancers,
data entry operators,
web designers and
content creators.

Course Outline

Topic 1 Overview of Google Workspace

Setup Google Workspace for your organization
Post and update content on Google Drive
Manage web content on Google Drive

Topic 2 Google Workspace Contents and Assets

Create and Curate Google Docs, Sheets, Slides
Maintain Google Forms, Jamboard, Gmail, Calendar, Meet
Maintain Google Sites

Topic 3 Google Admin and Add-ons

Reports on key metrics of your organization)
Google workspace add-ons
Improve Google Workspace

Pre-Requisites

Attitude
• Positive Learning Attitude
• Enthusiastic Learner

Experience
• Minimum of 1 year of working experience.
• Minimum 18 years old