Advanced Excel Training Course in Singapore (3 Days)

This Advanced Excel course in Singapore takes you well beyond the basics and turns Microsoft Excel into a genuine productivity engine. Over three hands-on classroom days you will master the high-value features employers actually look for — PivotTables, lookup functions, macros, advanced filtering and rich charting — so that tasks which once took hours are done in minutes. The training is practical from start to finish, with plenty of guided exercises on real spreadsheets.

By the end of this Advanced Excel training in Singapore you will confidently build complex formulas, automate repetitive work with recorded macros, summarise large datasets with PivotTables, and present your numbers as clear charts and infographics. You will leave able to clean, analyse and visualise data faster, sharpening your value as an analyst in any finance, sales, HR or operations role.

What You Will Learn

• Build and refine PivotTables and PivotCharts to summarise large datasets in seconds.
• Apply lookup and logical functions such as VLOOKUP, XLOOKUP, HLOOKUP, IF, SUMIF and COUNTIF with confidence.
• Record and run macros to automate reports and repetitive tasks without writing code.
• Use advanced sorting, AutoFilter, Advanced Filter and database functions to extract exactly the records you need.
• Create custom number formats and advanced conditional formatting to make data readable at a glance.
• Define and reuse range names, including 3-D names, to write cleaner, easier-to-audit formulas.
• Combine, link and consolidate data across multiple sheets and workbooks, and share files safely with your team.
• Turn results into compelling charts, infographics and a clear visual data story.

Who Should Attend

This Advanced Excel course suits professionals who already use Excel and want to work faster and smarter with data.

• Business and data analysts who manipulate large datasets and build reports.
• Finance and accounting professionals building models, dashboards and projections.
• Project managers tracking plans, resources and progress in spreadsheets.
• Researchers and academics managing data and presenting findings visually.
• Administrative and operations staff automating repetitive, time-consuming tasks.
• Entrepreneurs and small-business owners tracking finances, sales and inventory.

Prerequisites

• You should be comfortable starting Excel, entering numbers and text, and applying simple formatting.
• You should know basic functions such as SUM and COUNT, and be able to copy data between cells.
• Around two to three months of regular Excel use is ideal — this is not a beginners’ course.
• If you are new to spreadsheets, start with our Excel Beginner / Intermediate programme first.

Course Outline

Day 1 — Formatting, Functions & Filtering Foundations

• Custom & conditional formats — create custom number formats and apply, edit and remove conditional formatting to highlight key values.
• Formulas & functions — work with relative and absolute references, text functions like LEFT and UPPER, CONCATENATE, and date functions such as TODAY.
• Range names — create range names from headings, use them in formulas, and build 3-D names across sheets.
• Advanced functions — master IF, nested IF, SUMIF, COUNTIF, VLOOKUP and HLOOKUP.
• Excel tables — create named tables, total rows, calculated columns, in-table filtering and duplicate removal.
• Auto & advanced filters — sort data, build custom AutoFilters, apply Advanced Filter and use database functions.

Day 2 — PivotTables, Charts, Macros & Collaboration

• Getting more from your data — subtotals, automatic outlines, manual grouping and data validation.
• Excel charts — create and format charts, add labels, and change chart types and data sources.
• PivotTables — build PivotTables, add and refresh report fields, change summary functions, create report-filter pages and PivotCharts.
• Shared workbooks — share and co-edit workbooks, track changes and resolve conflicts.
• Worksheet & workbook protection — protect sheets, password-protect ranges and secure entire workbooks.
• Combining & linking workbooks — link, edit and consolidate data drawn from multiple files.
• Macros — enable the Developer tab, adjust macro security, and record and run macros to automate work.

Day 3 — Data Storytelling & Infographics

• Creating infographics — design and build infographics following recognised standards and best practices.
• Visual data storytelling — explore different ways to tell a visual data story from your spreadsheets.
• Compelling data stories — combine infographics and visualisations into one clear, persuasive narrative for 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.