Our basic and advanced Excel training courses in Singapore are packed with practical functions, tips and shortcuts that save you time at work.

Our funded Excel courses, from basic to advanced, cover these key topics:

• Entering & Editing Headings, Data, Dates and Basic Formula & Functions
• Using Absolute & Relative Referencing
• Creating Tables, Sorting & Filtering
• Begin with Simple Summary Functions & Advance to VLookup, Text, Logical, Database & Financial Functions
• Pivot Tables To Summarize Data
• Simple to Advanced Charting Functions
• Slicers & Timelines 
• Infographics & Data Visualization
• Forecasting Data based on Data Modeling
• Finding Data Trends & Analyzing Data For Decision Making
• Creating Dynamic Dashboards for sharing, slicing and dicing by the users and management.
• Consolidation of Multiple Files

Microsoft Excel’s rich functionality allows you to summarize your data quickly by organizing and structuring your data correctly.

With powerful Filtering, Sorting & Searching Tools you are able to quickly and easily narrow down the criteria that will assist in your decisions.

Combine these tools with the Tables, Pivots, & Graphs you can find the information that you want quickly & easily even if you have hundreds of thousands of data items.

What you learn at each level

Basic-Intermediate Excel (2 days)

For new or self-taught users. You enter and format data properly, write formulas with relative and absolute references, use SUM, AVERAGE, IF, COUNTIF and SUMIF, turn ranges into tables, sort and filter large lists, and build clear charts. By the end of day two you can take a raw list and turn it into a tidy, printable report without help. Basic-Intermediate Excel course details

Advanced Excel course (3 days): pivot tables, VLOOKUP and advanced formulas

This advanced Excel training is for people who already use Excel every week. Advanced Excel classes run at Fortune Centre on weekdays or Saturdays, and you move from single formulas to analysis:

• Lookups: VLOOKUP and XLOOKUP, then INDEX and MATCH for the cases a simple lookup cannot handle.
• Advanced Excel formulas: IFS, SUMIFS, COUNTIFS and AND/OR to calculate only what meets your criteria, plus the statistical functions you need to summarise and analyse data.
• Pivot tables in depth: group sales by region, product, month or quarter; show sums, counts, averages and percentages; add slicers and timelines. We go through each pivot table feature step by step until every learner has built their own on the exercise files.
• Clean, error-proof data: Advanced Filter to pull out the records that meet several criteria at once, conditional formatting to spot duplicates, invalid codes and outliers, and data validation rules that stop wrong entries before they happen.
• Sharing safely: protect sheets, cells and workbooks, and set separate passwords to open or to edit a file, so you can share a report without exposing costs or price lists.
• Time savers: what-if analysis and a first look at recording macros for steps you repeat every month.

Advanced Excel course details

Advanced Data Analytics & Visualization with Excel (2 days)

For analysts and managers who report to others. You combine data from several sheets into a data model, build interactive dashboards with charts, slicers and timelines, and present trends so decision makers can read them at a glance. Data Analytics & Visualization course details

Specialist Excel courses

• Excel for HR: headcount, leave, payroll and HR reports from people data.
• Power Query & Power Pivot: clean and combine files from many sources once, then refresh them with a click.
• Excel VBA: automate repetitive tasks with macros and VBA.
• Microsoft 365 with Copilot: Word, Excel and PowerPoint, with Copilot to draft, summarise and analyse faster.

Pivot tables, VLOOKUP and the advanced Excel skills employers ask for

Most job descriptions that mention Excel ask for the same things: pivot tables, lookups, clean data and clear charts. Pivot tables let you summarise thousands of rows by any dimension with a few clicks and no formulas. Lookups join data from different lists, for example prices into an order list or department names into a staff list. Our advanced Microsoft Excel training spends the most time on exactly these, because they save the most hours at work. If you mainly need dashboards and data models, the Data Analytics & Visualization course takes these skills further.

How to choose your level

• You type data and use a few simple formulas: start with Basic-Intermediate Excel.
• You already use IF and SUM but struggle with VLOOKUP or pivot tables: take the Advanced Excel course.
• You build reports for managers and want dashboards: take Advanced Data Analytics & Visualization.
• You work in HR, combine many files, or repeat the same steps every month: Excel for HR, Power Query & Power Pivot, or Excel VBA.

Not sure? Answer the 3 questions at the top of this page, or WhatsApp us and a trainer will suggest a level.

Grants and funding for Excel courses

• Course fee grant: up to 70% of the course fee for Singapore Citizens aged 40 and above and for employees sponsored by an SME; other eligible Singapore Citizens and PRs receive a 50% grant. The after-grant prices above already include GST.
• SkillsFuture Credit: Singaporeans can use it to pay the balance after the grant, on the basic and the advanced Excel course alike.
• UTAP: NTUC members can claim part of the fee back under UTAP.
• Employers: up to 90% SFEC support for eligible employers, and Absentee Payroll for the hours staff spend in class.

Why learn Excel with Intellisoft Training

Every course is hands-on classroom training at Fortune Centre, near Bugis and Bencoolen MRT. A laptop, an eBook and exercise files are provided, so you practise on real examples rather than watching slides. Trainers are WSQ certified adult educators, rated 4.7/5 for knowledge in post-course evaluations, and you leave with a WSQ Statement of Attainment or an Intellisoft Certificate of Completion, depending on the course. We have trained 25,000+ learners in Singapore over 24+ years, and thousands of them come back for their next course.