phone call us Inspizone+65 8586 4485
Email us Inspizoneenquiry@inspizone.com
Send Enquiry
Chat with us InspizoneChat With Us
Python Programming Course in Singapore

WSQ Microsoft Excel Intermediate & Advanced Course in Singapore

Master advanced Microsoft Excel skills in Singapore with our WSQ Intermediate & Advanced course. Elevate your spreadsheet proficiency, unlock powerful features, and enhance your data analysis capabilities.






Course Start Date


  • 23/12/2024 | 09:30 to 17:30
    Week Days
  • 08/01/2025 | 09:30 to 17:30
    Week Days
  • 12/01/2025 | 09:30 to 17:30
    Weekend
  • 08/02/2025 | 09:30 to 17:30
    Weekend
  • 10/02/2025 | 09:30 to 17:30
    Week Days
  • 24/02/2025 | 09:30 to 17:30
    Week Days
  • 09/03/2025 | 09:30 to 17:30
    Weekend
  • 10/03/2025 | 09:30 to 17:30
    Week Days
  • 24/03/2025 | 09:30 to 17:30
    Week Days
  • 29/03/2025 | 09:30 to 17:30
    Weekend
  • 14/04/2025 | 09:30 to 17:30
    Week Days
  • 27/04/2025 | 09:30 to 17:30
    Weekend
  • 28/04/2025 | 09:30 to 17:30
    Week Days
  • 19/05/2025 | 09:30 to 17:30
    Week Days
  • 16/06/2025 | 09:30 to 17:30
    Week Days
  • 30/06/2025 | 09:30 to 17:30
    Week Days
  • Schedule


    Days: 3 Days
    Duration: 24 Hours
    Timings: 9:30 AM - 5:30 PM

    10 Anson Road, 26-08A International Plaza, Singapore 079903

    Register Now

    Why Choose Us


    • Expert Local Trainers
    • Hands-on Training by experts
    • Certificate of Achievement
    • Free Refresh Class within 6 Month

    Quick Register


    Quick Register

    Who Should Attend This WSQ Microsoft Excel Intermediate & Advanced


    The WSQ Microsoft Excel Intermediate & Advanced is designed for individuals who are new to Microsoft Excel and want to establish a solid foundation in using this spreadsheet software.

    Course Completion Requirements:

    Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

    Entry Requirements

    Above 21 years old

    High School Level English

    Efficient internet & computer operation skills

    WSQ Microsoft Excel Intermediate & Advanced in Singapore


    This Microsoft Excel Intermediate & Advanced course is catered to a diverse range of audience seeking to enhance their existing data analysis skills for more advanced applications in a business context using Excel applications. Target audiences for this course include:

    • Professionals involved in data analysis, modelling, and reporting within their organizations.
    • Data Analysts who work with data on a regular basis and want to automate data manipulation and reporting tasks in Excel.
    • Finance professionals who rely on Excel for financial modelling, forecasting, and data analysis.
    • Accountants and finance professionals who use Excel for financial reporting and analysis.
    • Administrative staff who manage data, records, and reports using Excel.
    • Project managers who use Excel for project planning, tracking, and reporting.
    • Individuals who use Microsoft Excel regularly for tasks such as data analysis, reporting, budgeting, or project management.
    python programming certification singapore
    best python course singapore

    What Will You Learn WSQ Microsoft Excel Intermediate & Advanced Course

    • Learners are able to prepare and assist in generating diverse business insight reports adhering to legal and ethical guidelines related to data protection using data modelling and data visualisation principles.
    • Learners are able to perform complex database queries across multiple tables/unions to extract pertinent data by employing techniques used in data science.
    • Learners are able to identify the statistical techniques and machine learning methods to conduct meaningful and relevant data analysis on distinct datasets.
    • Learners are able to provide assistance with data transformation, quality checking and cleansing of data set into easily digestible formats.
    • Learners are able to apply data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data for business insights with applicable functional languages.
    • Learners are able to demonstrate an understanding of the underlying data structures involved in data science and summarise the data studies for business insights presentation.
    • Learners are able to recognise the significance of domain context in data science to produce performance dashboards and insight reports tailored to specific business domains.

    Training fee:

    *Course fee before WSQ funding: $550.00/pax + the new 9% GST rate will be applied for all registration made after 31st December 2023

    WSQ Funding: (GST included)

    *The funding amount mentioned is indicative and will be confirmed upon registration.

    Course Fee Subsidies for SMEs

    SINGAPORE CITIZENS AND PRS ≥ 21

    70% of Course Fees

    WSQ Deductible: $385.00

    Payable: $214.5 (including GST)

    Passing Exam & Full Attendance required

    Course Fee Subsidies for Non-SMEs

    SINGAPORE CITIZENS ≥ 40

    SINGAPORE CITIZENS < 40 AND PRS

    70% of Course Fees

    50% of Course Fees

    WSQ Deductible: $385.00

    Payable: $214.5 (including GST)

    WSQ deductible: $275.00

    Payable $324.5 (including GST)

    Passing Exam & Full Attendance required

    Course Fee Subsidies for Self-sponsored Individuals

    SINGAPORE CITIZENS ≥ 40

    21⩽SINGAPORE CITIZENS < 40 AND 21 ⩽PRS 

    70% of Course Fees

    50% of Course Fees

    WSQ Deductible: $385.00

    Payable: $214.5 (including GST)  (Can be offset by Skillsfuture credits if have)

    WSQ deductible: $275.00

    Payable $324.5 (including GST)   (Can be offset by Skillsfuture credits if have)

    Passing Exam & Full Attendance required

    Discount policy:

    •   3 pax from a same group: 5% discount for each person
    •   4 pax from a same group: 10% discount for each person

    Assessment Plan:

    •   Practical Performance: 1 hour

    An entrance test is required before the course, kindly help us process via Entrance Quiz (Est time to complete: 10 min).

    Fund Available


    WSQ

    Singapore Workforce Skills Qualifications

    WSQ Fund: Baseline funding deduction upto 70% for Singaporeans/ PRs. Further SFEC, Absentee Payroll and WSS applicable.

    SkillsFuture Eligible

    SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees

    PSEA

    Post-Secondary Education Account

    PSEA Funds: are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.

    UTAP

    Union Training Assistance Programme

    UTAP: NTUC members enjoy 50% *unfunded course fee, capped at $250 each year.

    WSQ MICROSOFT EXCEL INTERMEDIATE & ADVANCED Course OUTLINE


    Module One: Create and Manage Worksheets and Workbooks

    Manage Workbooks

    • Reference data in another worksheet/workbook
    • Reference data by using 3D references

    Manage Workbook Review

    • Configure formula calculation options
    • Restrict editing
    • Protect a worksheet
    • Protect workbook structure
    • Encrypt workbooks with a password

    Module Two: Apply Custom Data Formats and Layouts

    Apply Custom Data Formats and Validation

    • Create custom number formats
    • Populate cells by using advanced Fill Series options
    • Configure data validation

    Automating Task

    • Create and modify simply macros

    Apply Advanced Conditional Formatting

    • Create custom conditional formatting rules
    • Create conditional formatting rules that use formulas
    • Manage conditional formatting rules

    Module Three: Create Advanced Formulas

    Define Named Ranges and Objects

    • Name cells
    • Name data ranges
    • Name tables

    Look up data using Functions

    • Look up data by using the VLOOKUP
    • Look up data by using the HLOOKUP function
    • Look up data by using the MATCH function
    • Look up data by using the INDEX function

    Troubleshoot Formulas

    • Trace precedence and dependence
    • Monitor cells and formulas by using the Watch Window
    • Validate formulas by using error checking values
    • Evaluate formulas

    Apply Advanced Logical & Statistical Functions

    • Perform logical operations by using AND, OR, and NOT functions
    • Perform logical operations by using nested functions
    • Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS
      functions

    Apply Advanced Date and Time Functions

    • Reference the date and time by using the NOW and TODAY functions
    • Serialize numbers by using date and time functions

    Module Four: Perform Data Analysis and Business Intelligence

    Managing External Data

    • Import, transform, combine, display, and connect to data
    • Consolidate data

    Performing What-If Analysis

    • One & Two Variable Data Tables
    • Achieve Target Value by using Goal Seek
    • Present multiple values with Scenarios
    • Forecast data

    Module Five: Create Advanced Charts

    Create Advanced Charts

    • Add trend lines to charts
    • Create dual axis charts
    • Save a chart as a template

    Module Six: Analyze Data with PivotCharts & PivotTables

    Create and Manage Pivot Tables

    • Create PivotTables
    • Modify field selections and options
    • Format data
    • Group PivotTable data
    • Create slicers & timelines
    • Reference data in a PivotTable by using the GETPRIVOTDATA function
    • Add calculated fields
    • Using report filter pages
    • Drill down details

    Create and Manage PivotCharts

    • Create PivotCharts
    • Manipulate options in existing PivotCharts
    • Apply Styles to PivotCharts

    google logo Reviews of our students


    Sarah Lah
    Sarah Lah
    4 months ago

    Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.
    Arun Dixit
    Arun Dixit
    11 months ago

    I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.
    Wenyan Yeo (W)
    Cara Chan
    4 days ago

    Attended WORDPRESS WEBSITE CREATION COURSE on 25 Sep 2023. Really appreciate the training made simple for beginners like myself. The trainer Mr Abhinay gave clear explanations and repeated many times to make sure we understood. Understanding how Wordpress works enabled me to navigate my company website and make updates efficiently. Unfortunately, the plug-in used by my company website was not taught in the course; which is understandable given the many different types of plug-ins available.The staffs were helpful and understanding when I was unable to log-in my singpass for attendance. It was overall an enjoyable experience to me. Snacks and beverages at the pantry was a bonus, too! Thank you, Inspizone!
    Joanna
    Joanna
    10 months ago

    Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.
    Guido Sudero
    Guido Sudero
    11 months ago

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Avira Dixit
    Avira Dixit
    a year ago

    I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!
    Leanie Lee
    Leanie Lee
    a year ago

    I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.
    Wenyan Yeo (W)
    Wenyan Yeo (W)
    7 months ago

    Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.
    Lucia
    Lucia
    a year ago

    I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.
    J Quek
    J Quek
    2 years ago

    I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.
    Katherine Ang
    Katherine Ang
    a year ago

    I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!
    Patricia Tong
    Patricia Tong
    5 years ago

    Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.
    alex koh ming
    alex koh ming
    3 years ago

    BEST EXCEL TRAINING
    Jacqueline Lee
    Jacqueline Lee
    2021-09-22

    Went for a accounting course, Steven was friendly and helpful
    Wenyan Yeo
    Guido Sudero
    2021-09-01

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Ken Cheong
    THIRUMALA DEVI
    2021-09-15

    Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.
    Josephine Low
    Lachu Gandhi
    2021-09-07

    Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.
    shengwei tan
    shengwei tan
    2021-07-01

    Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.
    Chiqui Ehong
    Grace CH Ong
    2021-06-11

    A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂

    Related Courses