Microsoft Excel, Word, PowerPoint Combined 3 Day Training With CoPilot

Microsoft 365 Excel, PowerPoint, Word & Copilot Training course at Intellisoft Singapore
Microsoft 365 Excel, PowerPoint, Word & Copilot Training course at Intellisoft Singapore

Microsoft Word, Excel, and PowerPoint  Training Workshop in Singapore – Combined Class

Word,PowerPoint,Excel 2010 Training @Intellisoft Singapore
Word, PowerPoint, Excel with Copilot in Microsoft 365Training @Intellisoft Singapore

Improve your PowerPoint Presentation skills, Work better with Numbers and Data in Excel  Microsoft 365, and create stunning documents in Microsoft Word by attending a short, 3 day, Hands-on & Practical workshop on Microsoft Office in Singapore.

Course Duration : 3 days is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

If you want to join our dedicated Excel course in Singapore & improve your skills, we have multiple courses – Basic Excel for Analytics, Advanced Excel Courses in Singapore & VBA Macro Programming Courses.

Learn Microsoft Word,PowerPoint,Excel2010 at Intellisoft
Learn Microsoft 365 Word, PowerPoint, Excel at Intellisoft with Copilot

Microsoft Office (Word, Excel & PowerPoint) for Basic to Intermediate Level is best suited for people who want to get more out of Microsoft Office Suite and make the best use of the software in their day-to-day use.

Learn Office 365 tips and techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a short time.

Excel, Word & PowerPoint are simple office productivity tools from Microsoft, and are very easy to pick up, once you follow our step-by-step, practical and useful approach to learning the software to maximize your efficiency and effectiveness with the use of these popular software packages.

Learn Copilot for Office 365 - Word, Excel, PowerPoint
Learn Copilot for Office 365 – Word, Excel, PowerPoint

Go To Top

This program is highly recommended for those who want to understand the concepts of Documents, Spreadsheets and Presentations, and want to demonstrate the ability to expertly use these applications on a personal computer.

Beginner users and People who know the basics, but want to learn the Intermediate features of Microsoft Excel, Word & PowerPoint will find this program extremely useful.

Go To Top

 

Day 1: Microsoft Excel 

Section 1: Formulas and Functions 

Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Commonly Used Functions

Section 2: Organizing Worksheet and Table Data

Create and Modify Tables
Sort and Filtering Data
Get Summary Information in a Table

Section 3: Working with Charts

Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart

Section 4: Working with Graphics

Add Pictures into a Worksheet
Customize Pictures and Objects
Add Drawing Objects
Add SmartArt

Section 5: Managing Large Workbook

Manage Large Workbook Printing
Worksheets Setting
Page Setup Options

Section 6: Customizing & Enhancing Workbooks

Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Section 7: Analyze and transform data with Microsoft 365 Copilot in Excel

Analyze your data
Transform your data
Add Tables
Add Charts
Sort & Filter Data

Day 2: Microsoft Word 

Section 1: Manage documents

Format documents
Save and share documents
Insert text and paragraphs
Format text and paragraphs
Create and configure document sections

Section 2: Manage tables and lists

Create tables
Modify tables
Create and modify lists

Section 3: Create and manage references

Create and manage reference elements
Create and manage reference tables

Section 4: Insert and format graphic elements

Insert illustrations and text boxes
Insert shapes
Insert pictures
Insert SmartArt graphics
Insert screenshots and clips
Insert text boxes
Format illustrations & text boxes
Add text to graphic elements

Section 5: Manage document collaboration

Add and manage comments
Manage change tracking

Section 6: Maximize the AI features using Copilot in Microsoft Word
Draft a new document
Use the Copilot pane to chat with Copilot in Word
Linking files in Copilot in Word
Facilitate Collaboration using real-time coauthoring

Day 3: Microsoft PowerPoint 

Section 1: Working With Text 

Using an Outline Adding Text Using Bullets and Numbering Formatting Text & Paragraphs Using Text Boxes Setting Tabs

Section 2: Adding Multimedia Elements

Using Multimedia Elements Working With Pictures Applying Styles & Effects Modifying Hyperlinks Working With SmartArt

Section 3: Enhancing Presentations

Adding Audio & Video Media
Using Animation
Managing Multiple Transitions
Changing Animation Order
Using Slide Transitions

Section 4:  Preparing The Slide Show

Reviewing The Presentation Customizing the Presentation Proofing the Presentation Setting up a Slide Show Using Presentation Tools
Using Presenter View Rehearsing a Presentation Presenting The Slide Show

Section 5: Design captivating presentations with Microsoft 365 Copilot in PowerPoint

Create a new presentation
Transform written documents into presentations
Adjust layouts, reformat text, and time animations

Microsoft 365 Course in Singapore with Excel, Word, PowerPoint & Copilot - With WSQ Funding, UTAP, SkillsFuture, SFEC Grants & Absentee Payroll
Microsoft 365 Course in Singapore with Excel, Word, PowerPoint & Copilot – With WSQ Funding, UTAP, SkillsFuture, SFEC Grants & Absentee Payroll

Go To Top

Basic knowledge of computers, using the keyboard, mouse and Windows is required. This is an Intermediate level program, so we will teach you all about Microsoft Office and then how to get the most of it for day to day use at your office or home.

Go To Top

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.
Microsoft Training at Intellisoft

Learn Practical Skills

Companies sponsoring their staff for this Microsoft Excel, Word, PowerPoint training will benefit from increased employee productivity.

Your team will learning the fundamentals of Microsoft Office 365 easily.

Excel Dashboard Training Participants

3 Days Workshop

Enhance your team's efficiency and effectiveness with Microsoft Excel, Word, PowerPoint Combined 3 Day Training.

Contact us for advise on how to go about how to get started in learning the fundamentals of Microsoft Office 365 easily.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Training Course Fees

The full course fees for this training is S$980, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$686 Funding by SSG
Pay $294
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$490 Funding by SSG
Pay $490
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

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

How To Register

Register for the 3 Days of Microsoft Office 365 with Copilot training today by simply clicking on the chosen course date available at the top of this page. Need Help?

  1. Call us at +65 6250-3575, SMS / WhatsApp: +65 9066–9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Microsoft 365 Excel, Word and PowerPoint with Copilot training.

You can call us at +65  6250-3575 for your Customized Corporate training enquiry.

Learn Microsoft Office 365 With CoPILOT
&
Enhance Your Productivity

Microsoft Office Training in Singapore - Learn Word, Excel, PowerPoint in 3 days

Excel VBA Macro Software Design

WSQ Excel VBA SkillsFuture Course at Intellisoft Singapore
Intellisoft offers WSQ funded, UTAP supported SkillsFuture Credits Eligible Courses in 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.

Our Excel VBA (Visual Basic for Applications) training course aims to teach individuals how to use VBA programming language to automate tasks and develop custom solutions within Microsoft Office applications, such as Excel.

The course typically covers VBA syntax and structure, data types and variables, programming constructs such as loops and conditional statements, functions and subroutines, working with arrays and collections, and interacting within the Excel application.

With this Excel VBA knowledge, you will be able to:

  • Combine & consolidate multiple Excel files into a single file,
  • Clean data faster, Create Pivot Tables with VBA,
  • Create Forms,
  • Append data from External files, and
  • Learn to use Range, Objects, Properties & Methods in VBA to automate routine tasks.

The goal of the course is to provide individuals with the skills and knowledge they need to create powerful macros, automate repetitive tasks, and develop custom solutions that can help them work more efficiently and effectively with Microsoft Office applications.

Additionally, the training will include best practices for debugging, testing, and maintaining VBA code and tips for optimizing performance and writing efficient code.

Go To Top

The target audience for an Excel VBA macro programming class includes individuals who want to automate tasks, streamline workflows, and create custom solutions using Excel. This can include:

  1. Business professionals: Individuals who work with Excel regularly, such as financial analysts, project managers, or administrative assistants, can benefit from learning VBA to automate repetitive tasks and create customized reports.
  2. Programmers and developers: Individuals who have experience with programming languages such as Java or Python can use VBA to extend the functionality of Excel and create custom add-ins that interact with other applications.
  3. Students: Students who are studying business, finance, or data analysis can benefit from learning VBA as it is a valuable skill in many industries and can help them stand out in the job market.
  4. Excel power users: Individuals who already have advanced knowledge of Excel and want to take their skills to the next level can benefit from learning VBA to create more complex solutions and automate advanced tasks.

Overall, anyone who uses Excel frequently and wants to increase their productivity, efficiency, and accuracy can benefit from learning VBA macro programming.

Go To Top

Lesson 1: Software Design With Macros

TOPIC A: Getting to Know Excel Macros

  • Visual Basic for Applications
  • Macros
  • Object-Oriented Programming
  • Macro Options
  • Activity: Getting to Know Macros

TOPIC B: Creating a Macro in Microsoft Excel

  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder
  • Activity: Creating a Macro Using the Macro Recorder

TOPIC C: Editing an Excel Macro

  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro
  • Activity: Editing a Macro

TOPIC D: Debugging a Macro in Excel

  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro
  • Activity: Debugging a Macro

TOPIC E: Customizing the Quick Access Toolbar and Hotkeys

  • Add a Button to the Quick Access Toolbar to Run a Macro
  • Assign a Keyboard Shortcut to a Macro
  • Activity: Customizing the Quick Access Toolbar and Hotkeys

TOPIC F: Setting Macro Security in Excel

  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • Activity: Setting Macro Security
Summary

Review Questions

 

Lesson 2: Formatting Worksheets Using Macros

TOPIC A: Inserting Text With Excel Macros

  • The Selection Property
  • The ActiveSheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text
  • Activity: Inserting Text

TOPIC B: Formatting Text with Macros in Excel

  • How to Format Text
  • Activity: Formatting Text

TOPIC C: Sorting Data within Excel

  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data
  • Activity: Sorting Data

TOPIC D: How To Duplicate Data With Excel Macros

  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data
  • Activity: Duplicating Data

TOPIC E: Generate a Report in Excel Using Macros

  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report
  • Activity: Generating a Report
Summary

Review Questions

 

Lesson 3: Creating an Interactive Worksheet with Excel Macros

TOPIC A: Determining the Dialog Box Type

  • Message Boxes
  • Input Boxes
  • Activity: Determining the Dialog Box Type

TOPIC B: Capturing User Input With Macros

  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Constant
  • Decision Structures
  • The Select Case Statement
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input
  • Activity: Capturing User Input
Summary

Review Questions

 

Lesson 4: Working with Multiple Worksheets

TOPIC A: Insert, Copy, and Delete Worksheets With Excel Macros Methods

  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets
  • Activity: Inserting and Deleting Worksheets

TOPIC B: Renaming Worksheets Within Excel

  • Expressions
  • The DateSerial Function
  • The Format Function
  • How to Rename Worksheets
  • Activity: Renaming Worksheets

TOPIC C: Modify the Order of Worksheets Easily With Excel Macros

  • The Move Method
  • How to Modify the Order of Worksheets
  • Activity: Moving Worksheets within a Workbook
  • TOPIC D: Print Worksheets
  • The PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets
  • Activity: Printing a Workbook
Summary

Review Questions

 

Lesson 5: Performing Calculations With Excel Macro Code

TOPIC A: Create User-Defined Functions inside Excel

  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Defined Functions
  • Activity: Creating and Applying a User-Defined Function

TOPIC B: Automate SUM Functions

  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings
  • How to Automate SUM Functions
  • Activity: Automating SUM Functions
Summary
Review Questions

Go To Top

The prerequisites for joining our VBA macro programming workshop are:

  1. Basic knowledge of Excel: Participants should have a good understanding of Excel’s features, such as creating and formatting worksheets, entering data, and using basic formulas and functions.
  2. Access to Excel: Participants should have access to a version of Excel that supports VBA programming, such as Excel 2013 or later.
  3. Willingness to learn: Participants should be motivated and willing to learn new skills and concepts related to VBA programming.

Go To Top

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.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

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!

Infographic of Financial Reports

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

The full course fees for this training is S$960, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

70% Grant

$672 Funding by SSG
960
Pay $288
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

50% Grant

$480 Funding by SSG
960
Pay $480
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*
WSQ Excel VBA SkillsFuture Course at Intellisoft Singapore
WSQ UTAP SkillsFuture Credits Ready Courses at Intellisoft Systems Singapore

Infographics & Data Visualization with Excel

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

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Microsoft Training at Intellisoft

Claim WSQ Grant

Singaporeans & PRs (individuals or Company Sponsored) can claim up to 70% WSQ Grant*.

* Subject to SSG Eligibility Criteria

Contact us To Calculate Your Grant Amount

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Training Course Fees

The full course fees for this training is S$750, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

70% Grant

$525 Funding by SSG
Pay $225
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

50% Grant

$375 Funding by SSG
Pay $375
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

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

Simple Tables & Charts in Excel

WSQ Grant of up to 50-70%

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

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...

Advanced Excel training at Intellisoft

Learn Basic-Intermediate Excel (Course Outline)

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-Intermediate Excel 2019 Training @Intellisoft

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

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.

Go To Top

Target Audience For Basic Excel Training 2019 / Microsoft Office 365

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.

Go To Top

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

Go To Top

Pre-Requisites For Basic-Intermediate Excel Training

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: 

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

Go To Top

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!

Microsoft Training at Intellisoft

Claim WSQ Grant

Companies sponsoring their staff for training can get upto 70% WSQ Funding.

Individual Singaporeans & PRs are also eligible for up to 70% WSQ Funding.

* SSG Terms & Conditions Apply

SkillsFuture Ready

Singaporeans can use SkillsFuture Credits for this training.

NTUC Members can utilize UTAP.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Training Course Fees

The full course fees for this training is S$485, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$339.50 Funding by SSG
Pay $145.50
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$242.50 Funding by SSG
Pay $242.50
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

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?

  1. Call us at 6250-3575,  WhatsApp: 9066-9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. 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!

Advanced Data Analytics and Data Visualization with Excel

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

Data Analysis & Visualization through Infographics creation course in Singapore

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
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.

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
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!

Go To Top

Data Analyst reviewing data insightsMost 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:

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

Go To Top

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 InsightsExcel Dynamic Dashboard Course in Singapore

  • 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)

Go To Top

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.

Go To Top

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.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

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 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!

Infographic of Financial Reports

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.

Training Course Fees

The full course fees for this training is S$900, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

70% Grant

$630 Funding by SSG
900
Pay $270
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

50% Grant

$450 Funding by SSG
900
Pay $450
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

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.

Excel for HR Professionals

Excel for HR course in Singapore at Intellisoft with SkillsFuture Credits Eligibility
Microsoft Excel training at Intellisoft

Up to 70% WSQ Funding & SkillsFuture Credits Eligible Course on Excel Analytics for HR Professionals in Singapore

Course Duration for Microsoft Excel for HR Training: 2 days

Where: Intellisoft Training Room @FortuneCentre
Using: Microsoft Excel 365.   Call +65 6250-3575 for Details.

Unlock the power of data-driven decision-making with Excel for HR Professionals, a comprehensive 2-day hands-on workshop designed specifically for Human Resource executives, managers, and analysts.

In today’s fast-paced, metrics-driven workplace, HR teams must go beyond spreadsheets and truly analyze their workforce data to provide strategic insights. This workshop equips you with the tools, techniques, and confidence to clean, manage, analyze, and visualize HR data using Microsoft Excel.

You’ll learn how to calculate HR metrics, build interactive dashboards, use PivotTables for workforce analysis, and even perform hypothesis testing to validate HR strategies. From understanding employee turnover trends to visualizing recruitment funnels, this course will help you deliver clear, data-backed insights to management.

Led by a senior HR analytics expert, this course blends real-world HR scenarios with Excel’s practical capabilities, making it an essential upskilling program for modern HR professionals.

Learn Excel at Intellisoft Singapore
Learn Excel at Intellisoft Singapore

By the end of this 2-day workshop, participants will be able to:

  • Understand key HR metrics and their role in data-driven decision-making

  • Clean and prepare HR data for analysis using Excel

  • Apply essential Excel formulas like IF, XLOOKUP, COUNTIF, and SUMIFS

  • Perform basic descriptive statistics to summarize HR data

  • Use PivotTables with grouping, binning, and slicers for HR reporting

  • Create charts and dashboards to visualize workforce trends

  • Build interactive HR dashboards with KPIs and slicers
  • Apply data validation and protection for secure HR reporting

  • Translate HR data into actionable insights for management

In just 2 days, HR Professionals will learn the tips that save hours to resolve the difficulties they face on a daily basis in doing employee compensations, salary, leave, benefits etc.

In this practical training, participants will learn formatting techniques to convert data from different sources,  and how to make the best use of most important formulas for HR.

What will you get:

  • Quality training is delivered by Microsoft Certified Trainers from the industry.
  • Participants get the easy to read and understand manual specially designed for this course to take back for practice and future reference.
  • All formulas and functions from these files could be directly used at workplace.
  • Ability to ask questions on the spot and maximize your learning.

You can register online for the Advanced Excel for HR Training.

If you want to join our other Excel course in Singapore & improve your skills, we have multiple courses – Basic Excel for Analytics, Advanced Excel Courses in Singapore & VBA Macro Programming Courses.

Go To Top

This course is targeted towards HR Executives, HR Analysts, Talent Acquisition Specialists, and HR Business Partners who want to enhance their Excel skills for real-world HR use. If you have some HR background, or work in any function in HR, this practical and hands-on course on HR Analytics with Advanced Excel skills will be of great use to you and your organization.

After completion of the Advanced Excel for HR Analytics Training, you will be able to do the following easily:

  1. Calculate the tax deductible  amount based on the different salary range.
  2. Display first name, last name with prefix in one single column from three different columns.
  3. Find years of service of employees.
  4. Find the total salary expenses in different regions, different departments.
  5. Total  number of employees in the company  in different departments.
  6. Find the total salary given to employees of a particular department or designation in a particular month.
  7. Find number of employees joined on particular date/month in any department in any country.
  8. Calculate the bonus based on overall performance of an employee.
  9. Find the number of leaves taken by any employee, find the designation of an employee from his salary.
  10. Count number of directors or any designation in a company.
  11. Display the records according to department, by hire date, by salary etc.
  12. Calculate the total overtime hours for employees for any month.
  13. View summarized salary for all the different countries in different departments.
  14. Set the status, department of an employee through data validation.
  15. Validate the hire date upon data entry.
  16. Calculate salary based on overtime hours.
  17. Calculate the net pay of an employee from his/her daily pay and leaves taken.
  18. Consolidate overtime hours and rate for two employees
  19. Compare employee’s involvement in department from the working hours using charts.
  20. Find total number of employees working in specific department from specific dates, and much more in this 2 day HR focused Microsoft Excel 365 workshop.

Register today!

Go To Top

Excel Training @Intellisoft
Excel Training @Intellisoft

Excel for HR Professionals: 2Day Practical Workshop – Course Outline

Empower HR decisions with Data-Driven Insights Using Microsoft Excel

Excel for HR course in Singapore at Intellisoft with SkillsFuture Credits Eligibility

Day 1: Foundations of Excel for HR Analytics

Module 1: Introduction to HR Analytics with Excel

  • The role of HR analytics in modern workforce planning and decision-making.
  • Overview of key HR metrics: turnover, absenteeism, training ROI, cost per hire, etc.
  • How Excel supports people analytics in daily HR operations.

Module 2: Excel Basics Refresher for HR Teams

  • Navigating Excel’s interface and layout.
  • Best practices for entering, editing, and formatting HR data.
  • Time-saving shortcuts and tricks tailored for HR scenarios.

Module 3: Managing & Cleaning HR Data

  • Data formatting essentials: text, numbers, dates, currencies.
  • Cleaning messy HR data using Text Functions in Excel like TRIM, PROPER, UPPER/LOWER, and SUBSTITUTE.
  • Removing duplicates, fixing blank records, and using Flash Fill for smart entries.

Module 4: Sorting, Filtering & Conditional Formatting in HR

  • Sorting multi-column HR data (e.g. tenure within departments).
  • Advanced filters: finding employees with specific certifications or expiring contracts.
  • Highlighting absenteeism, birthdays, or contract expiry using conditional formatting.

Module 5: Key Statistics and Descriptive Analytics for HR

  • Understanding key statistical indicators: average, median, mode, min, max, standard deviation.
  • Using built-in functions for Analysis using Average, Median, Mode, Standard Deviation: AVERAGE(), MEDIAN(), MODE.SNGL(), STDEV.P().
  • Applying statistics to HR use cases: average age, training hours, salaries.

Module 6: Useful Formulas for HR Analysis

  • Using IF, COUNTIF, SUMIF, AVERAGEIF for common HR calculations.
  • XLOOKUP vs VLOOKUP: when and how to use each to fetch employee details.
  • Introduction to trend analysis & forecasting in HR Data

Day 2: Advanced HR Analytics, Reporting & Dashboards

Module 7: Pivot Tables for HR Reporting & Analysis

  • Creating PivotTables to analyze headcount, turnover, attendance.
  • Grouping and binning by age, years of service, and salary ranges.
  • Calculating % of total, count of hires by department, and more.
  • Adding slicers for filtering by department, gender, or employment type.
  • Hypothesis Testing in HR data

Module 8: HR Data Visualization with Excel Charts

  • Choosing the right chart type for HR reports.
  • Creating trend charts for attrition, headcount growth, or training hours.
  • Combining multiple data series (e.g. budget vs actual training spend).

Module 9: Building HR Dashboards in Excel

  • Elements of a good HR dashboard: KPIs, interactivity, simplicity.
  • Creating interactive dashboards using slicers, PivotTables, and PivotCharts.
  • Designing dashboards for recruitment, employee engagement, or manpower planning.
  • Incorporating Excel form controls (drop-downs, checkboxes) to enhance dashboards.

Module 10: Working with Protected & Shared HR Data

  • Locking specific cells, sheets, or workbooks to protect sensitive data.
  • Using data validation for dropdowns in HR forms (e.g. job roles, departments).

Module 11: Real-World Case Studies & Practice

  • Case 1: Employee turnover analysis and exit trend identification.
  • Case 2: Performance appraisal summary using VLOOKUP & PivotTables.
  • Case 3: Recruitment dashboard using slicers to filter by job level or location.

Target Audience

HR Executives, HR Analysts, Talent Acquisition Specialists, and HR Business Partners who want to enhance their Excel skills for real-world HR use.

Learning Outcomes

By the end of the course, participants will be able to:

  • Organize, clean, and analyze HR data using Excel formulas and tools.
  • Create PivotTables with binning and slicers to gain deeper insights.
  • Apply descriptive statistics to identify patterns in workforce data.
  • Build dashboards to communicate HR metrics and support strategic decisions.

Full of  Practical, Hands on Exercises based on HR work. A Laptop for doing the exercises is provided in the class room for all participants. What are you waiting for? Register for Excel for HR Executives.

Go To Top

This course is designed for: New and Experienced HR professionals from:

  •     Admin Professionals
  •     Compensation and Benefits Professionals
  •     HR Reward and Payroll Professionals
  •     HR Managers
  •     Anyone who perform HR functions in their organizations on daily basis

This course is extremely practical with multitude of hands on exercises that HR Executives will learn to apply in routine HR work and present meaningful information to the management. You can attend the HR workshop on Excel at Intellisoft Systems.

You must know the basics of using computer, and using elementary usage of Microsoft Excel.

Go To Top

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.
Microsoft Training at Intellisoft

Learn Practical Skills

Companies sponsoring their staff for this Excel training will benefit from increased employee productivity.

Your team will learn the most useful formulas, shortcuts, tips & tricks to become good at using Excel at a Expert level.

Excel Dashboard Training Participants

2 Days Workshop

Enhance your team's efficiency and effectiveness with key Excel Skills

Contact us for advise on how to go about how to get started in learning Key Excel Skills for HR.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

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

How To Register

Register for the 2 Days of Excel for HR training today by simply clicking on the chosen course date available at the top of this page. Need Help?

  1. Call us at +65 6250-3575, SMS / WhatsApp: +65 9066 – 9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Excel for HR training.

We also offer Corporate Trainings for Advanced Excel 365 version. If you have a group of people, we can arrange to conduct the Advanced  Excel for HR   training at your office location too. Just contact us for details.

Master Excel
&
Enhance Your Productivity

Training Course Fees

The full course fees for this training is S$1,000, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

70% Grant

$700 Funding by SSG
1000
Pay $300
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

50% Grant

$500 Funding by SSG
1000
Pay $500
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!