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 a Question or Need a Quotation?

Simple. Just tell us what you need here. 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

Best Basic Excel Course (WSQ Funded)

Learn Excel Basics To Save Time & Improve Productivity

Basic Data Analytics with Excel for Beginners

Use 70%* WSQ Grant, SkillsFuture & UTAP

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

Simple Tables & Charts in Excel

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

Advanced Excel training at Intellisoft

Objectives of This WSQ Course for Beginners in Excel in Singapore:

Upon completion of the Basic Data Analytics with Excel for Beginners course, you will be able to perform basic analytics with Excel. You will be able to understand better customer activities and behaviour 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

  • Overview of Data-Centric Strategies
  • Understanding Organization’s product and services
  • Current and emerging data analytics tools and technology trends
  • Aligning to organization analytics strategy
  • The need for 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

Lesson 6: Formulas & Functions

  • 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 Data Analytics 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

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need here. 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 Basic Data Analytics Training with 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

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

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

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.

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

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

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 a Question or Need a Quotation?

Simple. Just tell us what you need here. 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*

Data Analytics & Visualization with Power BI

Power BI Dashboard Training in Singapore
Power BI Dashboard Training in Singapore

Master Power BI with 70% WSQ Grant*

WSQ, UTAP & SkillsFuture Grants in Singapore

What Will You Learn in Power BI MasterClass

Course Overview:
Data Analytics & Visualization With Power BI

Course Objectives

Features of Power BI Course at Intellisoft Systems in Singapore

Course Outline

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*

Do You Have a Question or Need a Quotation?

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

Power BI Feature Set

Target Audience

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!

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!

Microsoft Training at Intellisoft

Claim WSQ Grant

Companies sponsoring their staff for training can Claim up to 70% WSQ Funding, subject to SSG Eligibility Criteria.

Applicable for Individual & Company Sponsored Singaporeans/PRs.

Pre-Requisites

Power BI Dashboard Design in Singapore

Register For Power BI Training Course in Singapore

Some of the companies that experienced our trainings

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!