Topic outline

  • General

    • Welcome to WSQ Microsoft Excel Essentials!

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

      Happy Learning!

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

      • Identify the various types of business statistics, including descriptive statistics in Excel workbooks. 
      • Create and edit imported data from external sources in Excel. 
      • Create formulas and functions to calculate business statistics. 
      • Edit worksheet data and cells. 
      • Format cells and worksheets in Excel, and utilise conditional formatting to emphasise key data. 
      • Manage multiple worksheets and windows. 
      • Prepare and format worksheets for printing. 
      • Sort and filter data range. 
      • Create charts using existing data. 

  • Learner Resources

    • resource icon
      Learner Guide File

      Click to view or download the lesson guide.

      Not available unless any of:
      • You are a(n) Student
      • You are a(n) Non-editing Teacher
    • resource icon
      PPT Slides File

      Please 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
    • resource icon
      Data Files (For Exercises)
      Not available unless any of:
      • You are a(n) Student
      • You are a(n) Non-editing Teacher
  • Assessment

    • quiz icon
      Short Question and Answer Quiz
      Opened: Sunday, 5 April 2026, 3:00 PM
      Closed: Sunday, 5 April 2026, 8:00 PM

      Complete ALL six questions in the Short Question and  Answers.

      Not available unless: You are a(n) Student
    • quiz icon
      Practical Performance Assessment Quiz
      Opened: Sunday, 5 April 2026, 3:00 PM
      Closed: Sunday, 5 April 2026, 8:00 PM

      The Practical Performance Assessment consists of EIGHT major tasks. 

      The candidate must complete all given tasks as per the instructions to demonstrate proficiency in performing basic data management in Excel.


      Not available unless: You are a(n) Student
    • 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.


  • Course Feedback