Spreadsheet confidence for every office professional — navigation, formatting, formulas, charts and printing — using Excel 2019 / Microsoft 365 with Malaysian business examples.
Number formats, tables, conditional formatting basics
➕
Formulas
SUM, AVERAGE, logical IF, relative vs absolute refs
📊
Charts & print
Present insights + print-ready layouts
What this course is
Excel basics that stick.
Most workplace frustration with Excel is not intelligence — it is never being shown the efficient patterns. Two focused days fix that for HR, finance, ops and admin teams.
Each learner works on realistic datasets (leave trackers, simple P&L summaries, inventory lists).
Optional half-day add-on introduces Power Query awareness for teams planning to continue to our Advanced Analytics track.
Who should take this course
💼
Administrators
Daily reporting duties.
📚
Fresh graduates
Workplace readiness.
📈
Managers
Delegating template standards.
🎯
Career returnees
Confidence rebuild.
👥
Corporate teams
On-site cohorts welcome.
🧠
Anyone avoiding Excel
We normalise asking questions.
Prerequisites
✓ Basic Windows/macOS literacy
✓ Excel installed (2019 or Microsoft 365)
→ HRD Corp claims supported — speak to our coordinator.
Course Curriculum
Two days. Hands-on.
See trainer screen + replicate immediately — no death-by-slide.
Labs
Repeatable patterns. Immediate apply.
Every learner leaves with starter templates for their department.
01
Cleanup
Normalise messy sheet.
Basics
02
HR roster
Formatted table + filters.
Format
03
Budget
IF + absolute refs.
Formula
04
Dashboard lite
Chart + print layout.
Output
05
Timed challenge
45-minute integrated task.
Exam
06
Show & tell
Share tip with class.
Capstone
+ Take-home exercise workbook with solutions.
Assessment
Practical exam. Timed spreadsheet tasks.
Closed-book practical using datasets not seen in class — mirrors workplace surprises.
Excel Basic practical
TasksFormatting + formulas + chart
Duration60 minutes
Passing80% rubric
RetakeOne complimentary
Daily drills
01
Warm-ups
02
Formula sprint
03
Mock exam
0%
Pass Rate
98% pass practical first attempt.
We drill muscle memory until spreadsheet fear disappears.
Hands-onTemplates98% passHRD readyCertificate
Why our pass rate is 98%
YouTube learning
Inconsistent practice.
Nexperts
Structured reps + feedback.
Your analytics path
Graduate to Advanced Analytics.
Continue to Excel Advanced Analytics or SQL tracks.
