WSQ Microsoft Excel Essentials
Topic outline
-
-
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 Guide File
Click to view or download the lesson guide.
-
PPT Slides File
Please click to view or download the PPT slides.
-
Data Files (For Exercises)
-
-
-
Short Question and Answer QuizOpened: Sunday, 5 April 2026, 3:00 PMClosed: Sunday, 5 April 2026, 8:00 PM
Complete ALL six questions in the Short Question and Answers.
-
Practical Performance Assessment QuizOpened: Sunday, 5 April 2026, 3:00 PMClosed: 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.
-
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.
-

