logo_ilearn

ONLINE SKILLS PROGRAMME

Microsoft Excel - Advanced

<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 Who Should Attend Prerequisites Unit Standards Course Content

Overview

Overview

This course is designed to provide learners with advanced abilities to work with Excel. It will allow learners to be able to perform functions such as pivot tables, lookups, as well as advanced formulas. The course will also provide learners with the ability to organise and manage their activities responsibly and effectively by using a spreadsheet application.

Duration

Delivery Method

Who Should Attend

Prerequisites

Unit Standards

Unit Standards

Using a Graphical User Interface (GUI)-based Spreadsheet Application, Enhance the Functionality and Apply Graph / Charts to a Spreadsheet NQF 4 (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.

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.

Course Content

List of Lessons

• Sparklines
• Charts creation
• Chart design
• Chart formatting
• Screenshots and screen clipping
• Shapes
• SmartArt
• Themes
• Proofing tools
• Tracking changes
• Comments
• Managing multiple windows
• Splitting worksheets into panes
• Workbook views
• Header and footer
• Page setup
• Microsoft account
• File properties
• Workbook protection
• Workbook inspection
• File AutoRecovery
• Using templates
• Compatibility issues
• Saving a workbook to the Web
• Introduction to macros
• Macro recording
• Macro editing
• Macro security
• Digitally signed macros

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