Microsoft Excel Intermediate Level Course Singapore
Intermediate Excel Course: Learn Essential Advanced Features, Functions, and Commonly Used Formulas in Microsoft Excel
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
Intermediate Excel training is ideal for both students and professionals looking to enhance their Excel skills beyond the basics.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
Microsoft Excel Intermediate Course Singapore
This 1-day hands-on training focuses on enhancing your Excel skills by covering advanced features, commonly used functions, and essential formulas. It is designed for users who are comfortable with the basics and want to deepen their knowledge for more efficient data handling and reporting.
Prerequisites
Participants should have a basic understanding of Microsoft Excel, including the ability to:
- Create, edit, and format worksheets
- Use basic formulas such as SUM and AutoSum
- Print and manage simple Excel workbooks
What You’ll Learn
In this Intermediate Excel Training, you’ll gain practical experience in:
- 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.
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.