Vision & Mission
Upcoming Events
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 2019
 
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-7955 7778
Fax: 603-7955 1945
 
 
Upcoming Trainings & Events
 
Microsoft Excel Functions and FormulasMidvalley City, KL 8-9 August 2019
Download Registration Form
 
Users of Microsoft Excel are familiar with its common functions and formulas but many have yet to discover the potential and its application of these tools. In learning and maximizing its specific & relevant functions, common and tedious tasks can be simplified and made easy. Some formulas are relatively straight-forward and some can be made more powerful when they are combined. Participants will discover how to avoid common pitfalls in using them, from learning the basic facts in using formulas to leveraging the usage of more complex functions.
 
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
 
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 RM 1007
Duration 14 Hours Members Less -
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.