Microsoft Excel Intermediate Level Course Singapore
For anyone who knows the basics of Excel but wants to go further, this Intermediate Excel Course Singapore gives you the right skills to work with data properly. In 1 day classroom training, you will cover Excel formulas and functions, logical and text functions, sorting, filtering, conditional formatting, charts and PivotTables. This Microsoft Excel Intermediate Course Singapore is built for working professionals, analysts, students and entrepreneurs who use Excel regularly and are ready to move beyond the basics.
UTAP
NTUC membersCourse Start Date
Schedule
- Days: 1 Days
- Duration: 7 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
SSG Course Details
- Microsoft Excel Intermediate Level 2021/ 365 (TGS-2023018624)
- Course Subsidy Validity Until 31-12-2024
- Course Duration - 7 Hours
- Register Now
Who Should Attend This Intermediate Excel Course Singapore
This Intermediate Excel Training Singapore is for anyone who already has basic Excel knowledge and wants to build on it. Working professionals who handle data and reports daily, analysts who need stronger Excel formulas and functions skills, admin staff tired of doing things the long way, entrepreneurs managing their own numbers, and students preparing for the workplace—this course fits all of them. If you use Excel regularly and feel there is more you should know about Excel data analysis and reporting, this Microsoft Excel Intermediate Course is the right next step for you.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
To receive your Certificate of Completion for this Intermediate Excel Course Singapore, a minimum attendance of 75% is required.
Above 16 years old
High School Level English
Basic internet & computer operation skills
Microsoft Excel Intermediate Course Singapore
This Microsoft Excel Intermediate Course Singapore is a 1-day classroom training that covers the functions, formulas and features that most Excel users never properly learn. It is built for people who are past the basics and ready to work faster, handle data more efficiently and produce reports that actually look professional. From Excel formulas and functions to charts, filtering and PivotTable training, everything covered in this course connects directly to what you will use at work.
Prerequisites
Before joining this Excel intermediate training Singapore, participants should be comfortable with the following:
They should be able to create, edit and format worksheets, write basic formulas including SUM and AutoSum, and print and manage simple Excel workbooks. If you can do these things comfortably, you are ready for this course.
Microsoft Excel Intermediate Course Singapore
This Excel skills training Singapore gives you practical experience across the features that matter most in daily work. You will learn to build and customise PivotTables, create and format charts that present data clearly, sort and filter records to find what you need quickly, and apply a range of Excel intermediate level functions to handle calculations with less effort. Every topic in this Microsoft Excel intermediate level training is supported by guided exercises so you practise each skill as it is taught, not after.
- Creating and customizing PivotTables
- Building and formatting charts
- Sorting and filtering data efficiently
- Using a range of intermediate Excel functions to streamline tasks
- This is a hands-on course with guided exercises for every topic to reinforce learning through practice.
Benefits of Taking This Intermediate Excel Course Singapore
Knowing a few Excel shortcuts is one thing. Being able to build a PivotTable, write a nested logical function or set up conditional formatting without stopping to Google it is another. This Intermediate Excel Course Singapore gives you that second level of capability in one structured classroom day. Here is what you take away:
- Build and use PivotTables to summarise large data sets in minutes
- Write Excel formulas and functions that automate calculations you currently do manually
- Sort, filter and organise data the way professionals do
- Apply conditional formatting to spot patterns and errors instantly
- Create charts and visual reports that communicate numbers clearly
- Use Timelines and Slicers to analyse and present data from different angles
Why Intermediate Excel Training Singapore is Important for Your Career
If you work with data, reports or numbers in any capacity, the gap between basic and intermediate Excel is the gap between spending two hours on a task and finishing it in twenty minutes. This excel intermediate training Singapore teaches you exactly the functions, tools and techniques that make that difference, and in Singapore’s competitive job market, that kind of efficiency is what sets you apart.
- Excel formulas and functions are used across every industry in Singapore and knowing them properly saves hours of manual work every week
- Pivot table training Singapore is one of the most practical skills professionals need for data handling and reporting roles
- Proficiency in Microsoft Excel 2021 / 365 gives you a visible edge whether you are growing in your current role or moving into a new one
- This excel intermediate training Singapore is delivered in a classroom with guided exercises so every skill is practised as it is taught
- Every topic in this course connects directly to real tasks professionals handle at work on a daily basis
Unsure if this course is suitable for you? Take this Quick test to help you decide.
Grants available
UTAP
Union Training Assistance Programme
UTAP: Update info about UTAP funding on all pages.
SkillsFuture Eligible
SkillsFuture Credit : Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
2nd Day: Intermediate Excel Course Outline
For people with basic knowledge of Excel want to learn more about advanced formulas (text, math, date and time, logical, etc) and advanced tools like chart, sorting, filtering, conditional format, pivot table
Lesson 1: Working with Functions
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions
Lesson 2: Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic D: Outline and Subtotal Data
Lesson 3: Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers
Microsoft Excel Intermediate Course – FAQs
What will I learn in the Intermediate Excel Course?
In this course, you’ll build on your basic Excel skills and learn how to:
- Create and customize PivotTables
- Build and format charts to visualize data
- Sort and filter data effectively
- Use commonly used functions and formulas for more advanced data analysis
- Apply Excel techniques in real-world exercises through hands-on practice
Who should attend the Intermediate Excel Course?
This course is ideal for students and professionals who already understand the basics of Excel and are looking to expand their skills in data handling, analysis, and presentation.
What are the prerequisites for this course?
You should have a basic working knowledge of Microsoft Excel, including how to:
- Create and edit worksheets
- Format cells and data
- Use basic formulas (e.g., SUM, AutoSum)
- Print and manage simple Excel files
Is this course hands-on?
Yes, the Intermediate Excel course is fully hands-on. Each topic includes guided exercises so you can apply what you’ve learned in real time and build confidence through practice
Will I receive a certificate upon completion?
Yes, upon successful completion of the course and assessment, participants will receive a Certificate of Completion. However, those who do not complete or fail the assessment will not receive a Statement of Attainment (SOA) and must pay the full course fee, including any funding components.
What if I fail or do not complete the assessment?
Participants who do not pass or complete the assessment will be marked as non-competent and will not receive the SOA. They will also be responsible for paying the full course fee, including the SSG-funded portion.
Why should I take the Intermediate Excel Course?
This course helps you move beyond the basics and equips you with practical Excel skills used in everyday business tasks. It enhances your ability to manage and analyze data more efficiently, making you more productive and competitive in the workplace.