WSQ Microsoft Excel Intermediate

Topic outline

• Select topic General

  General

  Collapse all Expand all
  • Select activity Announcements

    

    Announcements Page

    Mark as done

    Welcome to WSQ Microsoft Excel Intermediate!

    There are five learning units for this course. You are required to complete two written e-assessments, Short Questions  and Answers and Practical Performance  Assessment.

    Happy Learning!

    At the end of this course, you should be able to:

    • Use Excel for statistical analysis by organising cell ranges, managing formula errors, applying conditional logic, and employing lookup functions for data search and matching. 
    • Manage large Excel data sets, including multiple worksheets and workbooks, and application of protection measures for the interpretation of the categorised data. 
    • Organise data in Excel by sorting, filtering, and separating the contents into multiple sets to effectively interpret the collected data for categorisation of meaningful identified data. 
    • Use features in Excel to create tables, including managing data sets and removing duplicate records. 
    • Optimise Excel functionalities for process improvement in business statistics by creating and formatting charts, including displaying data through histograms. 
  • Select activity Announcements

    

    Announcements Forum
• Select topic Learner Resources

  Learner Resources
  • Select activity Learner Guide

    

    Learner Guide File

    Click to view or download the learner guide.

    Not available unless any of:

    • You are a(n) Student
    • You are a(n) Non-editing Teacher
  • Select activity PPT Slides

    

    PPT Slides File

    Click to view or download the PPT slides.

    Not available unless any of:

    • You are a(n) Student
    • You are a(n) Non-editing Teacher
  • Select activity Data Files (For Exercises)

    

    Data Files (For Exercises)

    Not available unless any of:

    • You are a(n) Student
    • You are a(n) Non-editing Teacher
• Select topic Assessment

  Assessment
  • Select activity Short Question and Answer

    

    Short Question and Answer Quiz

    Opened: Tuesday, 7 April 2026, 3:00 PM

    Closes: Tuesday, 7 April 2026, 8:00 PM

    Complete ALL FIVE questions.

    Not available unless any of:

    • You are a(n) Student
    • You are a(n) Non-editing Teacher
  • Select activity Practical Performance Assessment

    

    Practical Performance Assessment Quiz

    Opened: Tuesday, 7 April 2026, 3:00 PM

    Closes: Tuesday, 7 April 2026, 8:00 PM

    Instruction:

    The Practical Performance Assessment consists of FIVE major Tasks. 

    The candidate must complete all given tasks as per the instructions to demonstrate proficiency in organising and managing data using Excel.

    
    

    Not available unless any of:

    • You are a(n) Student
    • You are a(n) Non-editing Teacher
  • Select activity Appeal Process

    

    Appeal Process Page

    Mark as done

    You can submit the appeal by sending an email to sweeyee@asktraining.edu.sg by 17:00 within five working days from the date of completion of assessment.

    The Assessment Appeal Panel will review and decide on the submitted appeal against a Not Yet Competent (NYC) or a grade award. The panel comprises the Management, Academic and Examination Board, and an independent Adult Educator (Trainer/Assessor). An appeal costs $50, but the AAP may waive this fee at its discretion.

    
    

• Select topic Course Feedback

  Course Feedback
  • Select activity Course Feedback

    

    Course Feedback Page

    Mark as done

    SSG Traqom Feedback Link

    
    

    
    

    @ASK Feedback Link