MICROSOFT EXCEL 2016 INTERMEDIATE

  • Overview
  • Programme Structure

Programme overview

MS Excel Basic to Intermediate course aims to gives the overall usage of spreadsheet in all levels. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

PROGRAMME FACTS

Entry Requirement

  • Age 15 - 20
  • Any nationality

Duration

  • 2 Days Workshop

Certification Body

Programme Structure

Upon completion of this program, participants should be able to create simple to complex formulas and functions, like:

  • Database Function

  • COUNTIF Function

  • COUNTIFS Function

  • AVERAGEIF Function

  • AVERAGEIFS Function

  • SUMIF Function

  • SUMIFS Function

  • IF Function

  • AND Function

  • VLOOKUP Function

  • Validate data in a Worksheet

  • Filter data using Auto & Advanced Filters

  • Create Chart

  • Clean Duplicate Records

  • Apply Conditional Formatting

  • Protect Worksheet & Workbook

PROGRAMME FACTS

Entry Requirement

  • Age 15 - 20
  • Any nationality

Duration

  • 2 Days Workshop

Certification Body

Share This
Scroll to Top