Microsoft Excel 2013 Power Functions (SkillsFuture Approved / PIC Claimable)

Excel 2013 Power Functions Training Course

A 2 days Microsoft Excel 2013 Power Functions course specially tailored to equip users with hands on practice-on using features in Microsoft Excel 2013 that are not revealed in main stream Excel training course.

After learning these advanced Excel functions, users would find it easier and faster to perform data analysis and data searches. Performing time consuming and mundane tasks become a breeze as calculations can now be done using various functions.

This course helps you to become more productive and efficient as you are able to obtain fast results in simpler steps.

You will learn how the formulas and functions can be used in real-world scenarios with practical examples.

Microsoft Excel 2013 Power Functions Training Course
(SkillsFuture Approved / PIC Claimable) SkillsFuture Covers 100% of Course Fees (Self Sponsored)

 

Available Training Dates

To Be Confirmed

sign-up-button-green

MOCD Excel Course Banner

Curriculum Covered in Microsoft Excel 2013 Power Functions Training Course 

Statistical Function

  • Small
  • Medium
  • Large

IFS Function

  • SUMIFS
  • AVERAGEIFS
  • COUNTIFS

Information Functions

  • ISBLANK
  • ISNUMBER
  • ISERROR
  • IFERROR

Text Functions

  • Text
  • Value
  • Trim
  • Len
  • Left
  • Right
  • Find
  • Search
  • Replace
  • Substitute

LOOKUP AND REFERENCE FUNCTIONS

  • Vlookup
  • Hlookup
  • Choose
  • Match
  • Index

Date Functions

  • Day
  • Days
  • Month
  • Year
  • Weekday
  • Weeknum
  • Datevalue

Please take note that:

  • Training Classes will be postponed if there are less than 6 attendees.
  • We can arrange a close class if your company have a minimum of 6 participants.
  • All payments are accepted using only Singapore dollars, and are non-exchangeable or non refundable for other items.

sign-up-button-green