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] Manipulating Data Effectively with Microsoft Excel (Level 1 & 2) Online Learning – Microsoft Teams 18-19 November 2024; 19-20 December 2024 (9.00 AM – 5.00 PM)
Download Registration Form
 
Objectives
  • ​Apply the best practices of data import options to Extract, Transfer, Import/Export data and text files from worksheet, files, software & other programs.
  • Apply techniques in cleaning up large volume of data: remove and rearranging duplicate rows/columns, spaces, fixing time, date and numbers.
  • Manage, organize and summarize data in a particular order based on your criteria with the Sort and Subtotal features.
  • Select and filter the data to view and set criteria to extract data that you intend to analyse using the View, Auto Filter and Advanced Filter functions.
  • Structure and Present data impressively using Excel Tables.
  • Match and reconcile your data using the Vlookup Functions.
  • Leverage on Excel critical formulas in enhancing work efficiency-If/Nested If, And/Or, Count/Counta, Countif, Sumif/Average Ifs
  • Learn the basics of Excel Macro
 
Topics Covered

​Module 1: Extract Data into Excel
Module 2: Data Cleansing
Module 3: Data Managing
Module 4: Table Formatting
Module 5: Advanced Formulas
Module 6: Macro
 
*For more information, please click and refer to the brochure.

 
Target Audience

Experience in using Microsoft Excel basic features or have completed the Microsoft Excel (Fundamental & Intermediate).

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