Basic Excel for Data Analytics — Beginner Course in Singapore

This basic Excel data analytics course in Singapore is built for complete beginners who want to move from staring at spreadsheets to confidently organising, analysing and reporting data. Over two hands-on classroom days you go from typing into cells to building formulas, summarising data with tables, and turning numbers into clear charts — all on real workplace tasks. If you have ever felt that Excel does more than you know how to use, this beginner-friendly programme closes that gap.

You will work in Microsoft Excel from the first hour, guided by an experienced trainer, practising every concept on a provided laptop as you learn it. By the end you can prepare clean data, write your own formulas with functions like SUM and AVERAGE, sort and filter tables, and produce reports and charts that help your team make better decisions. This is Excel for beginners, Singapore-relevant, and entirely practical.

What You Will Learn

• Find your way confidently around the Excel ribbon, worksheets and cells, and enter, copy and paste data without fuss.
• Prepare and tidy data — managing rows and columns, formatting cells, and applying number and date formats for clean, readable sheets.
• Write your own practical formulas using basic functions and absolute referencing, and let Auto Fill do the repetitive work.
• Analyse data with Excel tables — sorting, filtering and pulling SUM-style summary figures out of your records in seconds.
• Manage and print large workbooks cleanly, with sensible page setup and page breaks for professional reports.
• Turn data into clear charts — column, pie and more — and format titles, legends and layout to communicate findings at a glance.
• Pull tables, visualisations and reports together to present analysis to managers and stakeholders.

Who Should Attend

This course suits anyone who needs to work with data in Excel but has never had proper training in it.

• Beginners who want to grasp the core concepts of spreadsheets from the ground up.
• Office staff, administrators and coordinators who key in, manipulate and report data daily.
• Finance, HR and operations team members who build summaries, rosters and dashboards.
• Anyone who relies on Excel but wants the shortcuts, tips and techniques that make the work faster.
• Professionals seeking a recognised WSQ Excel credential to add to their profile.

Prerequisites

• No prior data analytics experience is needed — this is a true beginner-level course.
• Basic PC skills are enough: comfort with the keyboard, mouse and Windows.
• An interest in working hands-on, as the class is exercise-driven throughout.

Course Outline

Day 1 — Excel Foundations & Data Preparation

• Data & corporate strategy — why Excel matters in business, where it fits among current data-analytics tools, and how it supports your organisation’s products and services.
• Getting started with Excel — using the ribbon, navigating worksheets, selecting cells and ranges, entering data, copy and paste special, and saving and opening workbooks.
• Rows & columns — inserting, moving and deleting cells, hiding and unhiding, and adjusting column width and row height.
• Organising data — formatting worksheet tabs, and inserting, deleting, moving, copying, hiding and unhiding worksheets.
• Formatting cells — cell, number and date formatting, finding and replacing text, and spell check for clean, presentable sheets.

Day 2 — Formulas, Analysis & Visualisation

• Formulas & functions — arithmetic operators and order of operations, Auto Fill, basic functions, writing your own formulas, and absolute referencing.
• Analysing with tables — creating and modifying tables, sorting and filtering, getting summary information, and formatting tables for reporting.
• Large workbooks & reporting — managing big workbooks, printing worksheets, page setup options and page breaks.
• Charts for visualisation — summarising data visually, customising chart data, formatting legends and titles, and building column and pie charts.
• Evaluating findings — bringing tables, visualisations and reports together to communicate insights to stakeholders.

Funding & Certification

This is a WSQ-funded, SkillsFuture-eligible programme for those who qualify, and NTUC members may use UTAP to offset part of the remaining fee. Training is led by Intellisoft’s founder and Master Trainer, Vinai Prakash. Corporate runs for teams of 15 or more can be arranged at your premises or ours.