• Skip to primary navigation
  • Skip to main content
iLearn

iLearn

Accredited Learning Solutions Provider

  • ABOUT US
  • ACCREDITED LEARNING
    • Instructor-led Skills Programmes
      • – Business Administration
      • – Contact Centre
      • – Entrepreneurship
      • – Information Technology
      • – Management
      • – Sales
    • Online Skills Programmes
      • – Microsoft Excel – Beginners
      • – Microsoft Excel – Intermediate
      • – Microsoft Excel – Advanced
    • Recognition of Prior Learning
    • Learnerships
      • – Business Administration
      • – Contact Centre
      • – Information Technology
      • – Management
      • – Marketing
      • – New Venture Creation
      • – Project Management
      • – Wholesale & Retail
      • – Training and Development
      • – Project Management
      • – Insurance
  • DIGITAL LEARNING
    • Learning Experience Platform
    • Learning Management System
    • Digital Learning Content
    • Custom Course Development
    • MyMastery
  • SHORT COURSES
    • Business Communications Skills
      • – Business Communication
      • – Business Writing Skills
      • – Email Management
      • – Interpersonal Skills
    • Conflict Management Courses
      • – Conflict Management
      • – Emotional Intelligence
      • – Managing Anger Methods
      • – Preventing Workplace Violence
    • General
      • – Business Etiquette
      • – Developing Positive Assertiveness
      • – IT Technical Courses
      • – Risk Taking
    • Leadership Skills
      • – Goals and Goal Setting
      • – Leadership
      • – Leading Through Change
      • – Leadership Skills for Women: Achieving Impact as a Manager
      • – Meeting Skills for Leaders
      • – Plan Your Work
      • – Professionalism in the Office
      • – Women in Leadership
      • – Working in Teams
    • Microsoft Office
      • – Microsoft Access
      • – Microsoft Excel
      • – Microsoft Outlook
      • – Microsoft Project
      • – Microsoft Publisher
      • – Microsoft Visio
      • – Microsoft Word
      • – Microsoft PowerPoint
    • Management Courses
      • – Motivating Employees
      • – Managing Anger Methods
      • – Managing your Teams in a Remote or Virtual Environment
      • – Performance Management
      • – Stress Management
      • – Sales
      • – Time Management
    • Money Management Courses
      • – WealthyMe
      • – WealthyCouples
    • Project Management Courses
      • – Project Management Fundamentals
      • – Project Management
    • Sales and Marketing Courses
      • – Customer Service
      • – Negotiation skills
  • QCTO HUB
  • ESD
  • TRAINING CALENDAR
  • NEWS
  • CONTACT US

ONLINE SKILLS PROGRAMME

Microsoft Excel - Beginners

MictSETA Learneship Services
Overview Duration Delivery Method Who Should Attend Prerequisites Unit Standards Course Content
Overview
Overview

This course is designed to assist learners with the ability to use spreadsheet applications to perform calculations. After completing the course, the learner will be able to organise and manage their activities responsibly and effectively by using a spreadsheet application to organize information into rows and columns for a specific purpose. They will be able to collect, analyse, organise, perform calculations, and critically evaluate information by using a spreadsheet application. Learners will be able to communicate effectively using visual, mathematical and/or language skills in the modes of oral and/or written persuasion when engaging with the subject by using a spreadsheet application to organize information into rows and columns for a specific purpose.

Duration
Duration

17 online hours and a POE submission.

Delivery Method
Duration

Self-paced online learning.

Who Should Attend
Duration

This course is intended for people who need to create and edit spreadsheets using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

Prerequisites
Prerequisites

The learner must be competent in Communication, Mathematical Literacy and Computer Literacy at NQF level 2.

Unit Standards
Unit Standards

Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Create and Edit Spreadsheets NQF 2 (4 credits)
(116937)

Learning outcomes:

  • Demonstrate an understanding of the principles of spreadsheets.
  • Create, open and save spreadsheets.
  • Produce a spreadsheet from a given specification.
  • Edit a spreadsheet.
  • Format a spreadsheet.
  • Check spelling and grammar in a spreadsheet.
  • Print a spreadsheet using features specific to spreadsheets.

Change the Appearance of a Spreadsheet (3 credits)
(258879)

Learning outcomes:

  • Outline data in a spreadsheet.
  • Modify the display of spreadsheet data.
  • Apply conditional formatting to data.
  • Create and use templates.
  • Work with comments.
Course Content
List of Lessons

• Introduction to the practical use of Excel
• Excel window
• Ribbon
• Excel workbook
• Creation and saving of a workbook
• Opening an existing workbook
• Manipulating worksheets
• Navigation within a worksheet
• Cell range selection methods
• Adjusting rows and columns
• Data entry into cells
• Numeric values in cells
• Moving and copying cell values
• Copying and moving using the Clipboard
• Font formatting
• Alignment of data in cells
• Borders and fill
• Basic number formats
• Date, time and percentage number formats
• Cell styles
• Copying formatting
• Excel table
• Conditional formatting
• Basic formulas
• AutoSum
• Number and date fill series
• Text series and custom lists
• Sorting
• Recommended charts
• Instant data analysis
• Pictures in Excel
• Printing
• Customisation of the program settings
• Getting help with Excel

Enquire Now
Accredited Skills Programmes

Business Adminstration

Business and Office Administration

Business Etiquette and Ethics

Business Writing Skills

Frontline Reception Etiquette

Planning and Coordinating Business Meetings

Report Writing Skills

Bridging the Gap

Computer Literacy

Work Readiness

Contact Centre

Call Management

Customer and Sales Techniques

Customer Interaction

Debt Recovery

Implement Contact Centre Activities

Inbound Contact Centre Skills

Outbound Contact Centre Skills

Performance and Coaching

Problem Solving Skills

Service Excellence

Service Levels and Statistical Data

Team Performance and Safety Awareness around the Workplace

Time and Stress Management

Entrepreneurship

Create a Business Plan

Deal with HIV/AIDS

Finance And Set Up A New Venture

Improve New Venture Performance

Identify and Demonstrate Entrepreneurial Ideas and Opportunities

Manage Customer Service

Manage Contracts And Production

Manage Administration And Negotiate An Agreement

Manage Finances

Manage People

Manage Marketing and Sales

Manage Staff

New Venture Financial and Industry Aspects

Produce a Business Plan

Research and Viability of a New Venture ideas

Understanding Marketing

Information Technology

Client Server Networking

Computer Programming Principles and Fundamentals

Computer Systems and the Use of Computer Technology in Business

Computer Technology Principles

Computer Technology Principles and Support

Configure, Operate and Administer Server Computer and Peripherals

Database Access

Data Communication and Networking Support

Design a LAN for Developmental Office and Enterprise Development

Introduction to Computers

Microsoft Access

Microsoft Excel

Microsoft Outlook

Microsoft PowerPoint

Microsoft Word

Network, Concepts, Architecture and Standards

Using the Internet

Work Effectively as a Team Member within a Developmental Project Environment

Management

Change Management

Diversity and Conflict Management

Ethics and Knowledge Management

Human Resources Management

Leadership and Motivational Skills

Organisational Standards and Performance Monitoring

People Management

Performance Management

Presentation Skills

Relationship Management

Results-based Management

The Code Of Conduct And Customer Service Standards

Time Management

Leadership

Project Management

Assist with Project Implementation

Assist with Project Planning

Participate in Project Budgeting and Risk Management

Project Management Introduction

Supervise a Project Team

Sales & Marketing

Close a Deal with a Customer

Customer Management

Customer Sales Management

Develop Customer Needs and Relationships

Identify Product Features, Advantages and Benefits to the Customer

Marketing Customer Interaction

Marketing Ethics and Code of Conduct

Marketing Information

Marketing Strategies

Marketing Resources

We are here to help guide you. Contact us to learn more.

About Us

iLearn is a national learning solutions company that works together with forward-thinking companies to grow their people and their business. We specialise in digital and accredited learning programmes that create continuous and purposeful learning environments within organisations.

Careers
Privacy Policy / POPI

Recent Post

iLearn named one of SA’s fastest growing companies

Celebrating Excellence at iLearn: Awards 2025

AI, Data, & the Rise of Skills-Based Learning in South Africa (2025 & Beyond)

Find Us

Tel:  0861 ILEARN

Johannesburg

Cape Town

Durban

Port Elizabeth

Follow Us

© 2025 iLearn | All Rights Reserved | Privacy Policy

Are you a Learner wanting to join a Learnership? Click here

Are you a Learner wanting to join a Learnership?
Read more

Are you a Learner wanting to join a Learnership?
Read more

How to get more B-BBEE points for less
5 reasons Business Skills have become more important
How to manage retrenchments responsibly

Are you a Learner wanting to join a Learnership?

Are you a Company needing more info?

We’ve updated our Privacy Policy to better reflect how we collect, use and share your information.