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

Duration

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

Duration

Certification Body

Share This
Scroll to Top