logo_ilearn

ACCREDITED SKILLS PROGRAMME

Microsoft Excel

<img class="fl-photo-img wp-image-123 size-full" src="https://ilearn.temp.co.za/wp-content/uploads/2018/07/Mict-logo.png" alt="Mict logo" itemprop="image" height="236" width="236" title="Mict logo" srcset="https://ilearn.temp.co.za/wp-content/uploads/2018/07/Mict-logo.png 236w, https://ilearn.temp.co.za/wp-content/uploads/2018/07/Mict-logo-150x150.png 150w" sizes="(max-width: 236px) 100vw, 236px" />

Overview Duration Delivery Method Prerequisites Unit Standards

Overview

Overview

The programme 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. Learners will learn how to use spreadsheet applications to organize information into rows and columns for a specific purpose. They will also learn how to use spreadsheet applications to perform calculations.

Duration

Delivery Method

Prerequisites

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.

Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Solve a Given Problem NQF 3 (6 credits)
(116940)

Learning outcomes:

Prepare and produce a spreadsheet to provide a solution to a given problem.
Adjust settings to customize the view and preferences of the spreadsheet application to suit the solution created for the given problem.
Work with multiple worksheets to suit the solution to the given problem.
Apply formulae to worksheets to provide alternative solutions to the given problem.
Apply simple built-in functions of the spreadsheet application to the given problem.
Apply formatting to a spreadsheet applicable to the given problem.
Use special effects to improve the presentation of the spreadsheet..
Evaluate a spreadsheet to comply with the given problem.

Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet NQF4 (3 credits)
(116943)

Learning outcomes:

Create and edit a graph.
Load data from an external data source to produce a given spreadsheet result.
Insert and edit objects into a spreadsheet.

Change the appearance of a spreadsheet NQF 3 (3 credits)
(258879)

Learning outcomes:

Outline data in a spreadsheet.
Modify the display of spreadsheet data.
Applying conditional formatting to data.
Create and use templates.
Work with comments.

Ensure spreadsheet integrity to enhance reliability NQF 4 (3 credits)
(258878)

Learning outcomes:

Set up a spreadsheet.
Apply security.
Check input data.
Check formulas and totals.
Check output data.
Audit spreadsheets.
Validate and sort data in a spreadsheet.

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

Contact Centre

Call Management

Customer and Sales Techniques

Customer Interaction

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 Marketing and Sales

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

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

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