Skip to content
Certifyd
Office AdministrationCore Course

Effective Spreadsheet Usage

Build accurate spreadsheets with formulas, functions and charts, and keep the data in them safe.

1 day

Choose a formatTraining a team? Get a quote

Pay per course in RM. No subscription.

An office administrator organising files at a bright reception counter

Effective Spreadsheet Usage is a 1-day Office Administration core course in Malaysia that counts toward the Certifyd Digital Essentials Practitioner (CDEP) certification. It runs live on scheduled dates, live online, and ends with an online test and a work document. It is aligned to the NOSS competency unit Effective Spreadsheets Usage.

Duration
1 day
Price
From RM 590.00

Why does this skill matter?

Run the office so nothing depends on one person's memory: vendors, assets, stock, policies, projects, staff development and the digital tools behind them.

Most office work now lands in a document, a spreadsheet or a slide deck, and a broken formula or a misplaced file costs time and trust. Handling files, online information and personal data properly also matters under the Personal Data Protection Act 2010.

What will you be able to do after this course?

Effective Spreadsheet Usage is one of the core courses for the Certifyd Digital Essentials Practitioner (CDEP). It focuses on one part of the job, effective spreadsheet usage, and is aligned to the competency unit Effective Spreadsheets Usage. Finish it in a live class, pass the online test and the work document, and you receive a Certifyd certificate with a transcript of the units covered, credited toward the CDEP.

  • Create spreadsheets and save them in the right file type
  • Enter, edit and manage data across cells, rows, columns and worksheets
  • Apply formulas and standard functions correctly
  • Format cells, develop charts and prepare spreadsheet outputs
  • Protect personal data in line with the PDPA 2010 and keep files and devices secure

Who is this course for?

  • Clerks, receptionists and admin assistants
  • Staff moving into office or desk roles
  • Employers who want a common digital baseline

Which format suits you?

Live with a MITE trainer, live online.
  • Choose live if you learn best by asking questions, want a fixed date in your calendar, or your employer prefers attendance records.
  • Both formats lead to the same certificate and the same credit toward the certification.

Live class

A MITE trainer on set dates, live online. The Certifyd Trainer programme runs in person.

Duration
1 day
Price
RM 590.00

Same Certifyd micro-credential and unit credit in either format.

Dates coming soon

What is available right now?

  • Live: dates on request. Ask us to schedule a class for your team.
A professional joining a live online class from a quiet home office with a headset and notebook

What does your transcript list?

Your course certificate comes with a transcript of these NOSS or NCS units and work activities. It is evidence you can use for a JPK microcredential through PPT.
  • Effective Spreadsheets UsageNCS-006:2017-C04
    • Utilise the spreadsheet application
    • Work with spreadsheet cells
    • Work with rows, columns and worksheets
    • Apply spreadsheet formulas and functions
    • Utilise cell formatting features
    • Develop charts
    • Prepare spreadsheet outputs
  • Computer Essential UsageNCS-006:2017-C01
    • Operate computer and devices
    • Configure desktop and icons setting
    • Produce text documents files
    • Manage computer file and folders
    • Access network connection
    • Confirm security and well-being of users and devices
  • Ethical Online Essential PracticesNCS-006:2017-C02
    • Apply web browsing skills and online security concepts
    • Use the web browser, tools and settings
    • Conduct online search
    • Utilise communication concepts
    • Manage user email essentials

How does the course work?

Learn it, practise it, show it.
  1. Choose a class date and pay online in RM. Your seat is held while you pay.
  2. Learn with a MITE trainer on your date, live online.
  3. Complete the course by attending every live day.
  4. Receive your Certifyd certificate with a QR code. The course is credited toward Certifyd Digital Essentials Practitioner (CDEP) at once.

What do you get?

Pay per course in RM. No subscription.
  • A Certifyd certificate for this course, with a unique code and QR
  • Credit toward Certifyd Digital Essentials Practitioner (CDEP), so you never repeat this course
  • Teaching in English or Bahasa Malaysia
  • A MITE trainer who answers your questions on the day

Which certification does this course count toward?

Finish this course and it already counts. You never repeat it.

This course is one of the core courses for the Certifyd Digital Essentials Practitioner (CDEP). Finish it and you are already part of the way to a post-nominal title.

  • Effective Spreadsheets Usage, mapped to the national competency unit.
  • Same Certifyd micro-credential and unit credit in either format.

How does the path to a certification work?

Start free. Pay one course at a time.

Can you train your whole team?

In-house classes or seats per course. Tell us the headcount, we send a quote.

We run this course as a private class for your team only, at your premises, at a MITE centre or live online, on dates that suit you. Smaller teams can take seats on a public class. Tell us your headcount and we reply with a quote.

Build the next skill in the same track.

Frequently asked questions.

Short answers to what people ask first.

How long is Effective Spreadsheet Usage?

It runs for 1 day as a live class, live online.

What is the difference between the live and online formats?

Every class has a MITE trainer and runs on set dates, live online. You finish with an online test and a work document, and your certificate lists the units and work activities covered.

What certificate do I get?

You receive a Certifyd certificate for this course with a unique code and QR, which anyone can verify online. A core course also counts toward its certification.

How much does it cost?

The current live class price is shown above. If a price is not published yet, it shows price on request.

Do I need experience before taking Effective Spreadsheet Usage?

It suits people who already do this work or are about to. If you are unsure, take the free readiness check for the certification first. It shows whether this course is the right place to start.

Is Effective Spreadsheet Usage HRD Corp claimable?

Not at the moment. Only courses HRD Corp has approved are claimable, and each approved course says so on its page. Your employer can still pay for it directly.

What if I cannot attend my live date?

Contact us before the class and we will tell you your options, such as moving to another date where seats are open.

Ready to start Effective Spreadsheet Usage?

Pick a live date. You leave with a certificate, a transcript of the units covered and credit toward Certifyd Digital Essentials Practitioner (CDEP).

Choose a formatTraining a team? Get a quote

Pay per course in RM. No subscription.