ProspenAfrica | Training and Consulting Services Provider

Advanced Microsoft Excel Training

2 Day Accredited Training

Unit standards: 116943, NQF Level 4, 3 Credits
Dates: 15 – 16 April 2024
Locations: Johannesburg, South Africa
Platform: Available In-Class / Online

Price: R 7 499.00

mictseta logo

Course Introduction

It’s time to save your time and gain control over your financial, accounting, auditing, presentations and day to day data calculations, sorting, and storing work, by one of the most intelligent software application Ms Excel
Discover methods to dramatically reduce the time you spend on spreadsheets

  • Develop practical solutions to your business problems through superior spreadsheet design

  • Upgrade your spreadsheet skills with advanced data management techniques

  • Consolidate worksheets from different sources into one workbook

  • Develop efficient techniques for using charts

This unit standard is intended for people who need to enhance spreadsheet appearance 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.

Course Objectives

People credited with this unit standard can:

  • Create and edit a graph/chart.

  • Load data from an external data source to produce a given spreadsheet result.

  • Insert and edit objects in a spreadsheet.

Who should attend?

  1. Learners in Financial Services: Those pursuing qualifications or careers in the financial sector, especially in areas involving financial transactions, records, or client interactions.

  2. Administrative Professionals: Individuals working in administrative roles that involve processing financial transactions, maintaining records, or managing financial information.

  3. Compliance Officers: People involved in ensuring that financial transactions adhere to regulatory standards and procedures.

  4. Banking and Insurance Personnel: Professionals in banking or insurance industries where understanding and processing financial transactions is crucial.

  5. Accounting Clerks or Assistants: Individuals handling financial records, transactions, or reconciliations as part of their job responsibilities.

  6. Students in Business Studies: Those studying finance, accounting, or related fields to gain a foundational understanding of financial transactions and record-keeping.

Training methodology

Training Methodology

Our diverse instructional approaches ensure effective learning:

– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.

Training Outline

Module 1: Create and edit a graph (Graph refers to all types of graphs and/or charts.)

  • The major graph types are defined in terms of their purpose.

  • A graph is created from a given data source.

  • A graph is edited.

  • The graph type is changed.

  • A graph is copied and moved based on given specifications.

  • A graph is resized.

  • A graph is deleted from a spreadsheet.

Module 2: Load data from an external data source to produce a given spreadsheet result

  • The external data file is checked to ensure that the input into a spreadsheet will achieve the required results.

  • The format of the input file is determined to ensure correct input into a spreadsheet.

  • The data is copied into the spreadsheet

  • The resulting spreadsheet is in accordance with the given spreadsheet result.

Module 3: Insert and edit objects into a spreadsheet.

  • An object is inserted into a spreadsheet.

  • A selected object is manipulated in a spreadsheet.

  • Use a drawing tool to draw an object in the spreadsheet.

Request a call back

Related Courses

Intermediate Microsoft Word: SAQA ID: 119078, NQF L3
Date: 11 - 12 April 2024

Microsoft Word Intermediate

SAQA ID: 119078, NQF L4

View Course
Basic Excel Training
Date: Available on Request

Basic Excel Training

SAQA ID: 61591, NQF L3

View Course
Microsoft Excel Intermediate
Date: Available on Request

Microsoft Excel Intermediate

SAQA ID: 50334, NQF L5

View Course
Microsoft Teams for End-Users
Dates: Available on Request

Microsoft Teams for End-Users

SAQA ID: 58724, NQF L4

View Course

Open chat
Need Help? Chat with Us
Scan the code
Powered by Prospen Africa
Welcome to Prospen Africa!
Check out our 15% Off sale when you purchase QCTO Training Material