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