Advanced Short 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

Contact person name
UCE
Contact person e-mail
Uce-info@nwushortcourses.info
Enquiry Form
Application Form