Microsoft Excel - Intermediate

COURSE OVERVIEW

This training course is designed to be highly interactive and practical oriented.

Course Standards

Unit Standard Number: 116940, NQF Level 3, 6 Credits

The learning never stops

CURRICULUM

  • Basics of Excel
  • Advanced copy and paste
  • Formulas (Average, Sum, COUNT, Max, Min, IF Function)
  • Cell Referencing
  • Rounding
  • View Options
  • Find and replace
  • Sort and filter
  • Graphs
  • Conditional formating
  • Ranges and Tables
  • Ranges Vs. Tables
  • Pivot table
  • VLOOKUP
  • Data Manipulations
  • Class Simulations and Practicals
  • Exercises
  • Comprehensive course notes and illustrations.
  • Progress quizzes keep learning on track.
    An overhead slide presentation providing supplementary.
  • Videos to illustrate best practices, case studies, and operational examples.
  • A learner workbook including progress quizzes.
  • Practical sessions 
  • Light refreshment is provided for classroom courses
  • Has attended certificate – Short course
  • CETA certificate of competence – statement of results. Issued approximately 6 – 8 months (Costs extra R400.00 excluding VAT). 

At the end of this course, delegates should be able to:

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

It is desirable for learners wishing to achieve this unit standard to be competent at

  • Mathematical Literacy at NQF Level 2 or equivalent.
  • ID 117902: Use generic functions in a Graphical User Interface (GUI)-environment, NQF level 1.
  • ID 116937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit a spreadsheets, NQF level 2.

For a short course: Successful delegates will receive a has attended certificate. (Normal course fee is charged)

For a certificate of competence – statement of result from CETA, a portfolio of evidence must be submitted by candidates and they must be found “competent” upon completion of course. (This costs an extra R400).

Statement of Results are issued digitally after approximately 6 – 8 months.

South Africa, Nigeria, Tanzania, Mozambique Botswana & Namibia

Course Status: Available

Related Courses

BROWSE RELATED COURSE

Microsoft Excel - Beginner

Microsoft Excel - Advanced

Microsoft Project