Siren Watcher

Siren Watcher CV Education TAFE NSW

Excel Certificates

Author: Siren Watcher. Published: 2022-02-15.

Institution: TAFE NSW

Course: Certificate in Advanced Excel

Course: Certificate in Intermediate Excel

Advanced Course Description:

This course develops learners knowledge and skills in advanced concepts of Microsoft Excel. Learners are provided with hands on practical experience.

Advanced Course Outcome:

  • Interface customisation.
  • Importing/exporting data.
  • Auditing tools.
  • Advanced formulas and filtering.
  • Data analysis.
  • Outlining, grouping and subtotals.
  • Consolidation options.
  • Pivot tables.
  • Macros.

Intermediate Course Description:

This course takes learners beyond the basics of Microsoft Excel. Learners are provided with hands on practical experience.

Intermediate Course Outcome:

  • Interface and best practice.
  • Formula and function revision.
  • Importing and exporting data.
  • Conditional formatting.
  • Grouping and linking.
  • Advanced templates, charts, functions and formulas.
Back