Microsoft Master Excel Course
This comprehensive Excel Masterclass takes you from beginner to advanced level, equipping you with the skills to confidently use Microsoft Excel. Learn essential tools like formulas, PivotTables, VLOOKUP, HLOOKUP, charts, and how to efficiently sort and filter data.
UTAP
NTUC membersSkillsFuture Eligible
Course Start Date
Schedule
- Days: 3 Days
- Duration: 21 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 Basic Level 2021/ 365 (TGS-2023018268)
- Microsoft Excel Intermediate Level 2021/ 365 (TGS-2023018624)
- Microsoft Excel Advanced level- 2021/ 365 (TGS-2023018596)
- Register Now
Who Should Attend This Microsoft Master Excel Training
The Master Excel Training Course is ideal for individuals who want to become Excel experts, especially working professionals looking to enhance their data management and analysis skills.
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
Master Excel Training Course in Singapore
About the Course
This Master Excel Training Course is designed to take you from beginner to advanced level in Microsoft Excel. Whether you're just starting out or looking to deepen your expertise, this course covers everything from the basics to advanced Excel functions, formulas, and automation techniques.
Not sure if you need the basics? Take our Entrance Quiz to assess your current skill level and determine the right starting point.
Target Audience
This course is suitable for students and working professionals in any industry who want to build strong, practical Excel skills for everyday use or career advancement.
What You’ll Learn
- How to use essential Excel functions and formulas
- How to create and manage worksheets
- Techniques to manipulate and organize data
- Data formatting best practices
- How to automate tasks using Macros across multiple sheets
- Master tools like PivotTables, VLOOKUP, HLOOKUP, charts, sorting, and filtering
Requirements
If you're unsure about your readiness, take our Entrance Quiz – Course Prerequisite to assess your basic computer skills.
Basic computer and Windows skills are required, including:
- Typing
- Using files and folders
- Launching applications
- Sending/receiving emails
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
1st Day: Basic Excel Course Outline
For beginners to get started with Excel (how to work with worksheet, workbook, cells, using simple formulas like sum, auto sum)
Lesson 1: Getting Started with Excel 2021
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
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
3rd Day: Advanced Excel Course Outline
For people who have a need to consolidate, collaborate with others when working with Excel and want to automate their simple repetitive tasks in Excel with Macro
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
Master Excel Training FAQ
What is Master Excel Training?
Master Excel Training is a comprehensive program designed to teach you how to effectively use Microsoft Excel, from basic to advanced features, to streamline tasks and boost productivity.
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 portion typically subsidized by SSG.
Who should attend the Master Excel Course?
This course is suitable for business professionals, data analysts, finance and marketing executives, students, job seekers, and anyone looking to strengthen their Excel skills for professional or personal use.
What are the benefits of attending a Master Excel Training in Singapore?
Attending this training can help you:
Improve your Excel skills for data analysis and reporting
Increase workplace efficiency and productivity
Make better data-driven decisions
Enhance your employability and career prospects
Gain confidence in handling complex Excel tasks
What topics will be covered in a Master Excel training course?
The course includes:
Excel basics and navigation
Advanced formulas and functions
Data management techniques
PivotTables and charting
Data visualization and presentation
Introduction to Macros and VBA automation
What type of certificate will I receive after completing the Master Excel training course?
You will receive a Certificate of Achievement issued by Inspizone, recognizing your mastery of Excel for data management, analysis, and reporting.
Why is it important to master Excel?
Excel is a powerful tool used across industries for data analysis, management, and reporting. Mastering Excel allows you to work more efficiently, handle complex data, make informed decisions, and present information clearly—all essential skills in today’s data-driven workplace.