MS Excel for Beginners
Almost every South African workplace uses spreadsheets: stock lists in a hardware store, timesheets on a construction site, sales figures in a shop, attendance registers at a school and budgets in every office. Job adverts for admin, stores, sales and reception posts often ask for "computer literacy" or "working knowledge of Excel". This course gives you that working knowledge, step by step, from the first time you open the program. You will learn your way around the Excel screen, enter text, numbers and dates correctly, format a sheet so it is easy to read, write formulas, use SUM, AVERAGE, MIN, MAX and COUNT, sort and filter a list, build clear charts, and print, save and share your work safely. Every lesson uses the same practice data, a sales list from a fictional hardware store, so you can follow each step on your own computer. The course is fully online and self-paced. Each lesson gives exact steps for Microsoft Excel (Microsoft 365) on a Windows 11 computer, and a hands-on activity in your workbook. You finish with a practical task, a final assessment and a MetaCo Certificate of Completion that you can add to your CV.
What you will learn
Enter and tidy data, write formulas, use SUM and AVERAGE, sort and filter lists and build simple charts in Microsoft Excel.
- Module 1: Introduction
- Module 2: Getting Started with Excel
- Module 3: Entering and Editing Data
- Module 4: Formatting Your Worksheet
- Module 5: Formulas
- Module 6: SUM, AVERAGE and Other Functions
- Module 7: Sorting and Filtering
- Module 8: Charts
- Module 9: Printing, Saving and Sharing
- Module 10: Putting It into Practice
How it is assessed
Short quizzes as you go, a final assessment with three attempts (fresh questions each time) and a practical task.
Certificate
MetaCo Certificate of Completion, with your own number and a QR code employers can scan. This certificate confirms completion of a MetaCo short course.
Part of these pathways: HR Assistant, Finance Clerk, IT Support Assistant, Stores Assistant
What you get
- The lessons, quiz and practical task
- A downloadable workbook (PDF)
- The Information Technology toolkit
- A one-page cheat sheet to keep
- The MetaCo certificate with a QR verification link, and a "Copy to my CV" line
- The Career Starter Kit, free with your first purchase
More Information Technology courses
Use a Windows 11 computer with confidence: files and folders, the internet and the shortcuts that save time every day.
R349
Create professional letters, reports, tables and templates in Microsoft Word, run a mail merge and save your work as a PDF.
R349
Organise your email, manage a work calendar, take part in online meetings and share documents safely in Microsoft 365 and Google Workspace.
R349
Protect yourself and your employer from hackers and scammers: strong passwords, phishing, phone and WhatsApp scams, and safe devices and Wi-Fi.
R349
Learn computer hardware basics, fix common faults, sort out printer and network problems, and log support tickets like a professional helpdesk agent.
R449
Use AI chat tools to save time at work: write clear prompts, check every answer, protect personal information and stay honest.
R349
