Microsoft Excel Advanced Level Course in Singapore
Advanced Excel Course Singapore: Master VLOOKUP, HLOOKUP, Data Consolidation, Worksheet & Workbook Protection, and Basic Macros.
Course 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 Advanced level- 2021/ 365 (TGS-2023018596)
- Mode of Training- Physical, in-class training
- Course Subsidy Validity- Until 31-12-2024
- Register Now
Who Should Attend This Advanced Excel Course Singapore
Advanced Excel Training in Singapore is ideal for students and professionals who already have a solid foundation in Excel and want to advance their skills to expert level.
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
Learn Advanced Excel Course in Singapore
- The Microsoft Advanced Excel Course in Singapore is a 1-day hands-on training program designed to help participants master advanced Excel skills for improved productivity and effective data management.
- This training covers important topics such as VLOOKUP, HLOOKUP, data consolidation, worksheet and workbook protection, basic Macros, and other advanced Excel functions.
- Participants will also engage in live practical exercises, applying concepts in real time to strengthen their Excel expertise and boost workplace efficiency.
- Target Audience: This course is intended for participants with intermediate-level Excel knowledge who are ready to take their skills to the next level.
Unsure if this course is suitable for you? Take this Quick test to help you decide.
Grants available
Funds
How to claim Funds
How to claim funds from Singapore.
1-day Advanced Excel course outline
Lesson 1: Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Use Dynamic Arrays and Dynamic Array Functions
Topic C: Trace Cells
Lesson 5: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends
Lesson 6: Creating Sparklines
Topic A: Create Sparklines
Frequently Asked Questions (FAQs)
What will I learn in the Advanced Excel Course in Singapore?
This course focuses on practical, real-world Excel applications. You’ll learn advanced features such as VLOOKUP, HLOOKUP, data consolidation, worksheet and workbook protection, basic macros, and other time-saving Excel techniques.
What if I fail or do not complete the assessment?
If you do not pass or complete the assessment, you will be marked as non-competent and will not receive a Statement of Attainment (SOA). You will also be required to pay the full course fee, including the SSG-funded portion.
Is there a prerequisite for joining this course?
While there are no strict prerequisites, participants are expected to have intermediate Excel knowledge to fully benefit from the training.
What is the duration of the Advanced Excel training?
This is a 1-day intensive training program (7 hours) that provides hands-on experience with advanced Excel functions and tools.
Why should I choose the Advanced Excel Course in Singapore?
Our course is developed and delivered by industry experts with real-world experience. You’ll gain practical skills, confidence, and tools you can apply immediately in the workplace.
You’ll receive:
- Expert-led training
- Hands-on exercises and live support
- A Certificate of Achievement upon completion
What is covered in the Advanced Excel course curriculum?
The course covers:
- Working with multiple worksheets and workbooks
- Workbook sharing and protection
- Creating sparklines and mapping data
- Using lookup functions and auditing formulas
- Automating workbook tasks
- Basic data forecasting techniques
Is it difficult to learn and complete the Advanced Excel course?
The difficulty level depends on your learning pace and commitment. With consistent practice and focus, mastering advanced Excel is achievable. It’s not about speed, but about steady progress and applying what you learn regularly.
Who is the Advanced Excel course suitable for?
This course is ideal for:
- Data analysts
- Business professionals
- Entrepreneurs
- Corporate trainers
- Students looking to upgrade their Excel skills