Vision & Mission
Upcoming Events
MEFA Monthly Calendar
Training Programs
 
Industrial Relations
HR Management
& Development
Occupational Safety
& Health
Business Management
ICT
Certification &
Academic Courses
SWINBURNE
Certified Programs
UNIMAS
Certified Programs
In-house Courses
PSMB Scheme
Academy Staff
Contact Us
 
Training Directory 2024
 
MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia

Tel: 603-7498 7200

 
 
Upcoming Trainings & Events
 
[IT] Microsoft Excel Functions and FormulasOnline Learning – Microsoft Teams 11-12 November 2024; 4-5 December 2024 (9.00 AM – 5.00 PM)
Download Registration Form
 
Objectives
  • Master the dynamics about Formulas,
  • Working with Names,
  • Applying the Logical & Information Functions,
  • Using Arrays to Solve Multiple Functions, Text Functions,
  • Leveraging Lookup Functions,
  • Applying Count and Sum Functions,
  • Optimizing Mathematical and Trigonometry Functions
  • Working with Dates and Time Functions
 
Topics Covered

​Module 1: Creating Formulas
Module 2: Working with Names
Module 3: Information Category & Logical Function
Module 4: Array Formulas
Module 5: Text Category
Module 6: Lookup & Reference Category
Module 7: Math & Trig Category
Module 8: Counting and Summing Category
Module 9: Dates and Time Category
 
*For more information, please click and refer to the brochure.

 
Target Audience

This course is recommended to users who use Microsoft Excel extensively at work. Familiarity with the basics of Microsoft Excel is assumed.

 
Methodology
 
Scheme SBL Fee RM1026
Duration 14 Hours Members Less -
 
This course will also be conducted at the following dates/venues
 
15-16 October 2024 (9.00 AM – 5.00 PM)Online Learning – Microsoft Teamsmore details  >>
    
4-5 December 2024 (9.00 AM – 5.00 PM)Online Learning – Microsoft Teamsmore details  >>
    
There are currently no events scheduled for other dates or venues.