Welcome to Your Course

Welcome to Excel Intermediate Analysis: The Power User – Level 1. This comprehensive self-study course has been specifically designed to take you from basic Excel knowledge to intermediate proficiency, equipping you with the practical skills needed to analyse data effectively in today’s data-driven workplace.

In South Africa’s competitive job market, Excel proficiency is no longer optional – it is an essential skill demanded across virtually every industry sector. From finance and accounting to human resources, marketing, and operations, the ability to manipulate, analyse, and present data using Microsoft Excel has become a fundamental competency that employers expect.

Who Should Take This Course?

This Level 1 course is designed for:

• Individuals who have basic Excel knowledge and want to build intermediate skills
• Working professionals seeking to improve their data analysis capabilities
• Students preparing for careers requiring spreadsheet proficiency
• Employees undertaking skills development programmes for B-BBEE compliance
• Anyone seeking NQF-aligned training in spreadsheet applications

Course Structure

This Level 1 course consists of six comprehensive modules, each designed to build upon the previous one. The course includes practical exercises, real-world case studies, and self-assessment activities to ensure you can apply your learning effectively. Upon completion, you will be well-prepared to progress to Level 2 and Level 3 of the Excel Intermediate Analysis programme.

How to Use This Study Guide

This self-study guide has been designed to provide you with a comprehensive learning experience that you can work through at your own pace. As this is a self-directed course (not instructor-led), you will need to take responsibility for your own learning journey.

Study Recommendations

• Set a Study Schedule —Allocate regular time blocks for your studies. We recommend 2-3 hours per session, with 2-3 sessions per week for optimal retention.
• Practical Practice —Excel is a practical skill – you must practice what you learn. Have Excel open while studying and work through each example.
• Complete All Exercises —Each module includes practical exercises. Complete all of them to reinforce your learning.
• Use the Glossary —If you encounter unfamiliar terms, refer to the glossary at the end of this guide.
• Self-Assessment —Complete the self-assessment exercises to test your understanding before moving to the next level.

Icons and Conventions

Throughout this guide, you will encounter various visual cues:

• Key Concept boxes highlight important definitions and principles you need to remember
• Practical Exercise sections provide hands-on activities to reinforce learning
• Tip boxes offer useful shortcuts and efficiency recommendations
• Important boxes highlight critical information or common pitfalls

Technical Requirements

To complete this course, you will need access to Microsoft Excel 2016 or later (Excel 365 recommended). While many features work similarly across versions, some functions may differ slightly. This course is designed around the Excel 365 interface, but notes are provided where older versions differ significantly.

Learning Outcomes and Assessment

This course is aligned with the South African National Qualifications Framework (NQF) and specifically references Unit Standard 258879 (Work with Spreadsheets) at NQF Level 3, registered on the SAQA database. The skills developed in this course contribute towards competency development as recognised under the Skills Development Act 97 of 1998.

Specific Learning Outcomes

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

• LO1 —Navigate the Excel interface confidently and customise the workspace for optimal productivity
• LO2 —Apply cell referencing techniques including relative, absolute, and mixed references
• LO3 —Use mathematical, statistical, logical, and text functions to solve practical problems
• LO4 —Organise and manage data effectively using sorting, filtering, and validation techniques
• LO5 —Apply conditional formatting to highlight important data patterns
• LO6 —Create and modify basic PivotTables for data summarisation
• LO7 —Develop professional charts and visualisations to communicate data insights
• LO8 —Apply data handling practices compliant with POPIA (Protection of Personal Information Act 4 of 2013)

Assessment Approach

As a self-study course, assessment is conducted through:

• Practical exercises embedded throughout each module
• Self-assessment questions at the end of each module
• Comprehensive case studies requiring integration of multiple skills
• A final portfolio of evidence comprising completed exercises

For learners registered through a SETA-accredited provider, formal assessment may be arranged separately. This course material provides the foundational knowledge required for such assessments.

NQF and SETA Alignment

This course material aligns with the requirements of the Media, Information and Communication Technologies (MICT) SETA and contributes towards the National Certificate: Information Technology: Systems Development (SAQA ID 48872) and related qualifications. The content supports the Skills Development Element of the B-BBEE scorecard as outlined in Code Series 300 of the Broad-Based Black Economic Empowerment Act 53 of 2003.