Primary tabs

Advanced Course
in
Excel
The demand for training Advanced Excel is presently on the increase at government departments and Non-Government Organisations (NGO’s)

Purpose of the course:

Train advanced computer skills (Excel ) to government officials and NGO’s

Admission requirements:

Admission requirements: 
Basic excel
Learning assumed to be in place: 
Learners should be competent in • English • Knowledge and experience of basic computerization actions and activities

Course outcomes and assessment criteria :

Course outcomes and the associated assessment criteria: 

Study Unit

Outcomes

Assessment Criteria

  After completion of this course, participants will: Participant will be assessed on the following criteria:

(INYM 121): Computer Applications and Packages: Proposed NQF Level 6 (Proposed 2 Credits)

 

On completion of this module the student will be able to:

  • Apply advanced worksheets formatting options;
  • Use logical, statistical, financial and mathematical operations functions;
  • Create charts and apply advanced chart formatting features;
  • Work with tables and lists to analyse, filter and sort data. Create and use scenarios;
  • Validate and audit spread sheet data;
  • Enhance productivity by working with named cell ranges, macros and templates;
  • Use linking, embedding and importing features to integrate data;
  • Apply spread sheet security features;
  • Create and use macros;
  • Combine and compare large sets of data in a spread sheet
  1. Furthermore, the student should also be able to demonstrate the manipulation of spread sheets through the application of knowledge of tables, calculations, transfer of data between different applications, functions and graphic representations
  • Validate Data
  • Create tables
  • Change table format
  • Sort and Filter table data
  • Transfer information between the sheets, workbooks
  • Create charts
  • Create pivot tables and charts
  • Use different advance formulas to manage information

 

Assessment: 
Yes
Method of assessment: 
Summative: • Practical assessment on computer e.g. practical individual and maintenance of spread sheets Formative: • Written test and final exam

Additional information

Mode of delivery: 
Contact
Target group: 
People who are responsible for the finance section/directorate of a government department or organisation
Contact us
Name: 
UCE
E-mail: 
Telephone number: 
018 285 2821