Welcome to Excel Competency Series: Level 1 – Foundations, your comprehensive introduction to Microsoft Excel. This self-study course has been designed specifically for online learners who want to develop essential spreadsheet skills for the South African workplace. Whether you are completely new to Excel or have some basic experience, this course will give you a solid foundation.

How to Use This Study Guide

This study guide is structured to take you through approximately eight hours of self-paced learning. The material is divided into ten modules, each building on the previous one to give you practical, hands-on Excel skills.

• Read each module thoroughly and take notes on key concepts
• Complete the activities and self-assessment questions at the end of each module
• Refer to the glossary whenever you encounter unfamiliar terms
• Work through the knowledge check assessments after completing all modules
• Use the reference section for further reading and research

Study Tip  Set aside dedicated time for each module. We recommend breaking the eight-hour course into 3-4 sessions of 2 hours each. Take short breaks between modules to absorb the material effectively. Practice each skill in Excel as you learn it.

Each module includes learning objectives, detailed content, practical examples, key concept callouts, activities for self-reflection, and summary questions to test your understanding.

Who Should Complete This Course

This introductory course is designed for anyone who needs to understand Excel fundamentals, including:

• Administrative staff and office workers in any industry
• Students preparing for the workplace or further studies
• Small business owners managing their own records
• Human resources and payroll administrators
• Finance and accounting entry-level professionals
• Anyone seeking to improve their computer literacy skills
• Employees preparing for more advanced Excel training

Important Note  No prior knowledge of Excel is required for this course. All concepts are explained from first principles, making this ideal for beginners. Basic computer literacy (using a mouse, keyboard, and Windows) is assumed.

Course Overview and Learning Outcomes

Course Description

Excel Foundations – Level 1 provides a comprehensive introduction to Microsoft Excel as an essential workplace tool. The course covers the Excel interface, creating and managing workbooks, entering and editing data, basic formulas and functions (SUM, AVERAGE, MIN, MAX, COUNT), cell formatting, worksheet management, chart creation, printing, file management, and data security principles including compliance with the Protection of Personal Information Act (POPIA).

This course aligns with the National Qualifications Framework (NQF) Level 2-3 standards for computer literacy and spreadsheet applications, as recognised under the Skills Development Act 97 of 1998. The content has been developed in accordance with South African workplace requirements and data protection legislation.

Learning Outcomes

Upon successful completion of this course, you will be able to:

• Navigate the Excel interface with confidence, including the Ribbon, Quick Access Toolbar, and various workbook views
• Create, save, open, and close workbooks in multiple file formats
• Enter, edit, and manipulate text, numbers, and dates in worksheet cells
• Construct basic formulas using arithmetic operators and cell references
• Apply essential functions including SUM, AVERAGE, MIN, MAX, and COUNT
• Format cells, rows, and columns for professional presentation
• Manage multiple worksheets within a single workbook
• Create and modify basic charts to visualise data
• Configure print settings and prepare documents for printing
• Apply basic data security principles in compliance with POPIA

Course Structure

The course consists of ten modules:

• Module 1: Introduction to Excel — The Excel Interface and Environment
• Module 2: Creating and Managing Workbooks
• Module 3: Entering and Editing Data
• Module 4: Basic Formulas and Functions
• Module 5: Cell Formatting and Presentation
• Module 6: Managing Worksheets
• Module 7: Introduction to Charts
• Module 8: Printing and Page Setup
• Module 9: File Management and Saving
• Module 10: Data Security and POPIA Compliance

Assessment

Your understanding will be assessed through module quizzes, self-assessment questions, a comprehensive final examination, and a practical assessment. To successfully complete this course, you should work through all modules, achieve a minimum of 60% on the final examination, and complete the practical assessment satisfactorily.

In terms of the Skills Development Act 97 of 1998 and the National Qualifications Framework Act 67 of 2008, this course provides foundational skills that contribute to workplace competency development. Employers registered with Sector Education and Training Authorities (SETAs) may claim skills development points for employees completing this training.