Microsoft Office Archives - Intellisoft Systems

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

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!

Go To Top

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.

Go To Top

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)

Go To Top

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.

Go To Top

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

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

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

SkillsFuture Credit

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

SFEC (Enterprise Credit)

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

UTAP (NTUC Members)

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.

+65 6250-3575 WhatsApp Us

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

Microsoft Project Training (WSQ) – TEMP

Microsoft Project Course in Singapore With WSQ Grants from SSG

Microsoft Project Professional (upto 70% WSQ Funding) is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

SkillsFuture credits ready for Singaporeans Learn how to Begin, Plan, Execute, Monitor & Control, and Close a project – all using the latest Microsoft Project software in our hands – on classroom training.

UTAP: In addition, NTUC members can utilize UTAP to offset 50% of remaining fees (capped at $250 per year).

Learn to plan various tasks involved, resources required to accomplish the tasks, and the overall cost in order to plan a project properly. Course Length: 2 days.

Recommended Reading: Microsoft Project Training Crucial to Project Success Many project managers think Microsoft Project software (Microsoft Project 2016, MS Project 2013 ) to be just useful for creating a list of things to do… like a laundry list.

Some think that MS Project is more of a scheduling software, and it is useful only upto coming up with a Gantt Chart or a Network Diagram for their project. Nothing could be further from the truth!

Microsoft Project 2016 is a sophisticated piece of software, which is capable of doing much more than mere scheduling.

To read more, please visit Microsoft Project Training Crucial to Project Success

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Support

Course Objectives

Microsoft® Office Project Professional 2016 has an extensive range of easy to use shortcuts, tips and tricks, that will enable you to use it as a tool that assists in managing your projects effectively and efficiently.

In this Microsoft Project 2016 training course, you will create and modify a project plan, and begin to manage variances in a project, bringing the project to a success!

PLUS, you will learn completely NEW FEATURES introduced in Microsoft Project 2016! You will create and manage a project schedule using Microsoft® Project 2016.

Upon successful completion of this course, students will be able to:

• Identify the basic features and components of the Microsoft Project environment.

• Create a new project plan file and enter project information.

• Manage tasks by organizing tasks and setting task relationships.

• Manage resources for a project.

• Finalize a project plan.

• Exchange project plan data with other applications.

• Update a project plan.

• Manage project costs.

• Report project data visually.

• Reuse project plan information.

Go To Top

Target Audience

This course is designed for project managers, team leads, who have a basic understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans.

Format: Instructor led, highly interactive classroom setting with many practical exercises to do and learn from in this session.

Each student will be provided with a Laptop to use in the training room, to do the exercises. You can bring in your laptop notebook for your use in the class. It must be pre-installed with Microsoft Project 2016 software for your use.

Go To Top

Course Outline

Day 1 of Microsoft Project 2016

Lesson 1: Starting a Project

Project Management 101
Navigate and Customize the Project 2013 Interface
Add Tasks to a Project
Add Resources to a Project
Save a Project

Lesson 2: Working with Project Calendars

Manage Project Time Frames
Change Working Time

Lesson 3: Working with Project Tasks

Manage Project Tasks
Add Summary Tasks and Milestones

Lesson 4: Working with Project Resources

Manage Project Resources
Allocate and Level Work Resources

Lesson 5: Delivering a Project Plan

Print Project Views
Share Projects
Export Projects

Day 2 of Microsoft Project 2016

Lesson 6: Managing the Project Environment

Link Projects
Baseline a Project
Work with Custom Fields

Lesson 7: Managing Task Structures

Change a Task List
Create a Network Diagram
Manage the Critical Path
Use Lag and Lead

Lesson 8: Generating Project Views

Use View Command
Use Existing Views
Create Custom Views
Format and Share the Timeline View

Lesson 9: Producing Project Reports

Use Existing Reports
Create Custom Reports
Export Visual Reports

Go To Top

Pre-Requisites

Students enrolling in this class should have the following:

A general introductory-level understanding of project management concepts.
Basic end-user skills with any current Windows operating system.

Go To Top

Support