-
Chapter 1: Data Jobs and the Spreadsheet Basics You Need5 Topics1 Quiz
-
Chapter 2: Data Capturing — Fast and Accurate5 Topics1 Quiz
-
Chapter 3: Cleaning Messy Data5 Topics1 Quiz
-
Chapter 4: Counting and Adding Up With Conditions5 Topics1 Quiz
-
Chapter 5: Lookups — VLOOKUP and XLOOKUP5 Topics1 Quiz
-
Chapter 6: Pivot Tables, Charts and Reports5 Topics1 Quiz
-
Chapter 7: Protect the Data, Get Hired and Earn5 Topics1 Quiz
Quizzes
Participants 1
Chapter 1: Data Jobs and the Spreadsheet Basics You Need
Akhona Eland October 20, 2026
Almost every office in South Africa runs on spreadsheets: stock lists, staff registers, customer lists, sales figures and attendance records. Employers advertise for data capturers, admin clerks and stock controllers who can work in Excel quickly and accurately. This chapter shows you where these skills are used, which free tools to use, and the basics you’ll build on for the rest of the course.
Chapter outcomes
By the end of this chapter you will be able to:
-
Describe the jobs that use Excel and data capturing, and what employers ask for
-
Set up free Excel or Google Sheets on your phone or computer
-
Use basic formulas and cell references with confidence
-
Set up a clean, well-structured table
The quiz opens once you have marked every lesson in this chapter complete.
Enjoyed Chapter 1?
Unlock every chapter of Excel & Data Capturing: Get Hired for Admin and Data Jobs and download your certificate. R199 once-off, no monthly fees.
Get the full course – R199
Responses