WSQ Microsoft Excel Advanced

Topic outline

• Select topic General

  General

  Collapse all Expand all
  • Select activity Announcements

    

    Announcements Page

    Mark as done

    Welcome to WSQ Microsoft Excel Advanced!

    There are six 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:

    • Use a series of business statistical formulas and functions for summarising and analysing categorical or numerical data sets, including utilising nested conditions, lookup, text, date, and time functions. 

    • Harness the skills needed to use Excel's built-in data analysis tools to analyse data sets and identify trends and patterns. 

    • Distinguish between Excel's built-in statistical functions and tools to conduct statistical analyses, taking into account the needs and objectives of stakeholders. 

    • Utilise PivotTable to understand and analyse the core data structures that include summarising datasets for the presentation of actionable business insights to stakeholders. 

    • Adopt relevant statistical software techniques to perform data queries across multiple sources to extract pertinent data for stakeholders. 

    • Apply macro recording functionality to aid automation of working with data sets and performing repetitive tasks. 

    
    

• Select topic Learner Resources

  Learner Resources
  • Select activity Learner Guide

    

    Learner Guide File

    You can click here 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 Exercise Files

    

    Exercise Files Folder

    Not available unless any of:

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

  Assessment
  • Select activity Short Questions and Answers

    

    Short Questions and Answers Quiz

    Opened: Sunday, 28 December 2025, 3:00 PM

    Closed: Sunday, 28 December 2025, 8:00 PM

    Not available unless any of:

    • You are a(n) Student
    • You are a(n) Non-editing Teacher
  • Select activity Excel Advanced Statistics (For PP Assessment)

    

    Excel Advanced Statistics (For PP Assessment) File

    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: Sunday, 28 December 2025, 3:00 PM

    Closed: Sunday, 28 December 2025, 8:00 PM

    Instruction:

    The Practical Performance Assessment consists of SIX major Tasks. 

    The candidate must complete all given tasks as per the instructions to demonstrate proficiency in implementing the application of data analytics 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