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 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 Essential Skills (Level 1 & 2) Online Learning – Microsoft Teams 3-4 April 2023 (9.00 AM – 5.00 PM)
Download Registration Form
 
Course Fee: RM455.80 (inclusive SST) per participant
 
Organizations depend on highly skilled employees to produce high quality work. This course is designed to equip participants the essential skills to leverage on Microsoft Excel on their daily tasks. In this course, participants will gain the knowledge and skills re- quired to create and edit worksheets, apply basic formatting techniques, use the data validation, charts and tables and leverage on conditional formatting. This course is ideal for users who have little knowledge of using the Microsoft Excel.
 
OBJECTIVE:
• Discover Excel by navigating the Interface, Ribbon and the Toolbar
• Apply the techniques and rules in entering, editing, formatting data orderly and accurately
• Perform calculations and summarized data using relevant functions and formulas
• Manage and format data across multiple worksheets systematically
• Apply Data Validation in setting criteria and rules on entering data
• Leverage on the Conditional Formatting
• Apply Charts and Tables for clearer presentations
• Set and manage printing of Excel spreadsheet
• Explore the techniques of using Excel shortcuts

WHO TO ATTEND
This course is useful for users who want to get a strong foundation of Microsoft Excel. Participants will immediately apply the knowledge and skills at work.
 
COURSE OUTLINE
Module 1: Getting Started
Module 2: Entering, Editing & Formatting Data and Numbers
Module 3: Calculating Totals & Summaries using Formulas
Module 4: Data Validation
Module 5: Conditional Formatting
Module 6: Managing Multiple Worksheets
Module 7: Printing: How not to have “Sexy on Spreadsheet, Ugly on Printout"
Module 8: Basic Skills for Chart Makers
Module 9: Using Excel Productively
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.