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

 
 
Information & Communication Technology
Microsoft Excel Essential Skills (Level 1 & 2)
 
Objectives

• 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

 
Topics Covered

​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

*For more information, please click and refer to the brochure.

 

 
Target Audience

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.

 
Methodology
 
Scheme SBL Fee RM455.80
Duration 14 Hours Members Less -