Date: 25th January & 1st February 2023
Venue: Lumileds Malaysia Sdn. Bhd., Bayan Lepas, Penang
Course Objectives:
Upon completion of this program, participants should be able to:
Create formulas and functions, like:
- COUNTIF Function
- AVERAGEIF Function
- SUMIF Function
Manage Table with using Auto Filters
Visualizing Data with Chart
Understanding tables, performing filter and sort and extracting information from data for analysis
Able to use simplified features and functions in Excel for data analysis
Prerequisite:
Basic knowledge of Windows is essential with the follow pre-requisites:
Have attended Microsoft Excel – Foundation Level, OR
Able to switch between task applications
Able to create a spreadsheet with simple formatting
Able to create a basic chart
Able to print a spreadsheet with headers and footers added
Able to create basic formulas – Addition, Subtraction, Multiplication and Division
Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
Course Methodology:
This program will be conducted through interactive lectures, practical exercises and group assignments. Case studies on real-world scenarios are included to demonstrate the practicability of the lessons.
Who Should Attend:
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
More Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.
Comments