Spreadsheet Skills for the Workplace

Office, Digital & Business Skills · Beginner · 20 hours

Master spreadsheets from zero to workplace-ready — data entry, formulas, charts, pivot tables and professional reporting, all contextualised for South African workplaces.

What you'll learn

• Navigate the Excel interface with confidence
• Build and format professional spreadsheets
• Use core functions: SUM, AVERAGE, VLOOKUP, IF
• Create charts and pivot tables for reporting
• Apply data validation and conditional formatting

Course modules

• Module 1: Getting Started with Excel
• Module 2: Data Entry, Selection & Formatting
• Module 3: Formulas & Basic Functions
• Module 4: Absolute & Relative References
• Module 5: Logical & Lookup Functions
• Module 6: Sorting, Filtering & Tables
• Module 7: Charts & Visualising Data
• Module 8: PivotTables & Summarising Data
• Module 9: Data Validation & Conditional Formatting
• Module 10: Professional Reporting & Printing
• Module 11: Core Concepts in Depth
• Module 12: Common Mistakes & How to Avoid Them
• Module 13: Tools, Resources & Templates
• Module 14: Standards, Quality & Best Practice
• Module 15: Health, Safety & Ethics
• Module 16: Case Study: A South African Example
• Module 17: Communication & Working with Others
• Module 18: Staying Current & Continuing to Learn
• Module 19: Capstone Project
• Module 20: Review, Assessment & Next Steps

Unlock this course for R19 on any phone. A certificate is optional (from R39).