Microsoft Master Excel Course in Singapore
UTAP
NTUC members
SkillsFuture
Eligible
3 DAYS
Course Days
21 HOURS
Course Duration
9:30 AM - 5:30PM
Course Timings
VENUE
10 Anson Road, 26-08A International Plaza, Singapore 079903
Course Start Date
Master Excel Training Course in Singapore
The Master Excel Course is designed to take you from beginner to advanced proficiency in Excel. You’ll learn essential basics, intermediate functions, and advanced tools step by step. (Not sure if you need the basics? Take our quick quiz to find out!)
Master essential Excel functions and formulas.
Create and manage professional worksheets efficiently.
Organize, clean, and manipulate data with ease.
Format data for clear presentation and analysis.
Automate tasks and streamline workflows using Macros.
Gain expertise in PivotTables, VLOOKUP, HLOOKUP, charts, sorting, and filtering.
What Will You Learn Master Excel Training Course
Build a strong foundation with Excel basics, worksheets, and data entry.
Apply formulas, functions, and logical operations for accurate analysis.
Format, organize, and manage data effectively for clarity.
Create PivotTables, charts, and dashboards for powerful reporting.
Use VLOOKUP, HLOOKUP, sorting, and filtering to simplify data handling.
Automate repetitive tasks and integrate data across sheets using Macros.
Who Should Attend This Master Excel Training Course
This Master Excel Training Course is ideal for professionals, managers, accountants, data analysts, students, and business owners seeking to improve data management, reporting, and automation skills for career growth.
Analyst
Turn insights into strategy
Business professionals
Drive smarter decisions
Entrepreneur
Innovate with AI power
Training Professionals
Upskill the future workforce
Student
Kickstart your AI journey
Entry Requirements
Above 16 years old
High School Level English
Basic internet & computer operation skills
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Grants available
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
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
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: Create Sparklines
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
See how MOCD Studio’s courses help our students grow and succeed
Top Most Related Courses
Join Advanced Excel Training in Singapore
Join our Advanced Excel Course in Singapore to learn powerful tools like VLOOKUP, HLOOKUP, data consolidation, protecting your worksheets and...
Read More
Microsoft Excel Intermediate Training Course
UTAP Union Training Assistance Programme Quick Enquiry Registration 1 DAYS Course Days 7 HOURS Course Duration 9:30 AM – 5:30PM...
Read More
Learn Basic Excel Course in Singapore
UTAP Union Training Assistance Programme Quick Enquiry Registration 1 DAYS Course Days 7 HOURS Course Duration 9:30 AM – 5:30PM...
Read More
Microsoft VBA Macro Excel Training Course Singapore
UTAP Union Training Assistance Programme Quick Enquiry Registration 3 DAYS Course Days 21 HOURS Course Duration 9:30 AM – 5:30PM...
Read More
Best Microsoft Excel Dashboards Training Course in Singapore
UTAP NTUC Members SkillsFuture Eligible Quick Enquiry Registration 2 DAYS Course Days 14 HOURS Course Duration 9:30 AM – 5:30PM...
Read MoreMaster Excel Training FAQ
What is Master Excel Training?
Master Excel Training is a practical course that teaches you how to use Excel efficiently to save time and boost productivity.
What if I fail/did not complete the assessment?
You will be considered non-competent and no Statement of Attainment (SOA) will be awarded. You are required to pay the complete course fee, which includes the SSG’s funding requirement.
Who should attend the Master Excel Course?
The Master Excel course is ideal for professionals across roles—like analysts, managers, and marketers—as well as students and job seekers looking to boost their Excel skills.
What are the benefits of attending a Master Excel Training in Singapore?
The benefits of attending a Master Excel training in Singapore include: Improved proficiency in using Excel for data analysis, management, and reporting. Increased efficiency and productivity in the workplace. Enhanced ability to make informed decisions based on data. Improved marketability and job prospects. Increased confidence and satisfaction in your skills.
What topics will be covered in a Master Excel training course?
Topics covered in a Master Excel course include: Basic Excel functionality and navigation. Advanced formulas and functions. Data management and analysis tools. Pivot tables and charts. Data visualization and presentation techniques. Macros and VBA programming.
What type of certificate will I receive after completing the Master Excel training course?
Upon completing the Master Excel course, you'll receive a Certificate of Achievement from Inspizone, validating your Excel skills in data analysis, management, and reporting.
Why is it important to master Excel?
Mastering Excel is essential because it’s a powerful tool for data analysis, management, and reporting. It helps you work faster, make smarter decisions, and present data clearly and professionally.
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFECFor Self-sponsor
* Singaporean can offset the payable amount via SkillsFuture Credit (Except Mid Career Credit) and/or PSEA * NTUC Union members can reimburse of up to 50% of the unfunded fee under UTAP Enjoy up to $250 UTAP support. More info: UTAP
Note: minimum 75% attendance & passing all the assessment are required for WSQ subsidy deduction.
Address
10 Anson Road,
26-08A International Plaza
Singapore 079903
Top Trending Courses
Terms and Conditions
Accounting & Non Finance Course
Programming course
Soft Skills Course
Creative Course
Project Management Course
Soft Skills Course
LCCI Certification Course
Microsoft Excel Course
Online Marketing Course
Website Design Course