Microsoft Excel - Advanced Course

COURSE OVERVIEW

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

Course Standards

Unit Standard Number: 116943, NQF Level 4, 3 Credits

The learning never stops

CURRICULUM

  • Create and edit a macro
  • Update workbook properties
  • Add data validation criteria to a workbook
  • Create a data list outline
  • Create an interactive data with power view
  • Perform a statistical analysis with the Analysis Tool Pack
  • Consolidate data
  • Merge with workbooks
  • Sort and filter data 
  • Create a Pivot Table
  • Filter data using slicers
  • Analyze data using Pivot charts
  • Use text functions
  • Use logical function
  • Use specialized functions
  • Use date functions
  • Use lookup functions
  • Use financial functions
  • Import a delimited text file
  • Export Excel data
  • Create a web query
  • Import and export XML data
  • Integrate excel data with the web
  • 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:

  • 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.

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

  • Communication at ABET level 3 or equivalent
  • Mathematical Literacy at ABET Level 3 or equivalent
  • Mathematical literacy communication skills at least at NQF level 3
  • Use generic functions in a Graphical User Interface (GUI)-environment (ID117902 – NQF level 1)
  • Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem (ID 116940 – NQF level 3).

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 (US 116937) - Beginner

Microsoft Excel (US 116940) - Intermediate

Microsoft Project