Course title: Excel & Data Capturing: Get Hired for Admin and Data Jobs

Level: Beginner to intermediate. You should know how to type and use a phone or computer. Basic Excel helps, and Chapter 1 gives you a quick refresher.

Duration: Self-paced — about 5 hours of reading, practice and quizzes across 7 chapters.

Format: Text lessons, short videos, hands-on practice activities, a quiz after every chapter, a final assessment and a certificate of completion.

What you need: A phone or computer with internet. You’ll use free Google Sheets or free Excel for the web. A computer or laptop is best for speed, but not required.

Price: R199 once-off (online)

Certificate: PurpleGrowth certificate of completion, issued automatically when you finish all chapters and the final assessment

What this course gets you

By the end of this course you will be able to:

• Set up clean, well-structured spreadsheets and use formulas with confidence

• Capture data faster and more accurately, and prevent errors with dropdown lists and validation

• Clean messy data with TRIM, PROPER, Find & Replace and Remove Duplicates

• Answer business questions with IF, COUNTIF, SUMIF and their multi-condition versions

• Match lists with VLOOKUP and XLOOKUP, and fix lookups that fail

• Build pivot tables, clear charts and a one-page weekly report

• Handle personal information responsibly under POPIA, pass Excel tests and earn with your skills

Who this course is for

• Job seekers applying for data capturer, admin clerk, stock controller and office assistant jobs

• People already in admin or call centre roles who want to work faster and stand out

• Anyone who has to pass an Excel or typing test for a job

• Side hustlers who want to earn by helping small businesses with their spreadsheets

Further free resources

Free tools and sites you can use to practise, find work and keep growing after the course. All free at the time of writing.

• JobAlertsZA — a free tool that finds matching jobs for you: set alerts for data capturer and admin roles — https://jobalertsza.com/

• SAYouth.mobi — free, zero-rated platform for young job seekers — https://sayouth.mobi/

• Google Sheets — free spreadsheets on your phone or computer — https://sheets.google.com/

• Microsoft Excel for the web — free with a Microsoft account — https://www.microsoft.com/en-za/microsoft-365/free-office-online-for-the-web

• Monkeytype — free typing speed and accuracy tests — https://monkeytype.com/

• Information Regulator — official information about POPIA — https://inforegulator.org.za/