Description
COURSE OBJECTIVES
Upon completion of the course, participant should be able to:
- Perform reference calculation
- Using function for data calculation and extraction
- Organize and filter data in worksheet
- Create and modify graph in worksheet
- Managing multi windows of workbook in the same worksheet
TARGET AUDIENCE
This course is suitable for participant such as Admin, Clerk, Manager, data analysis, and others who are using Microsoft Excel for their day-to-day job.
PREREQUISITES
Basic knowledge of Windows is essential with the following pre-requisites:
- Have already attended Microsoft Excel Foundation, OR
- Able to navigate the worksheet user interface
- Able to use the basic calculus and formula on worksheet
- Able to manipulate the row and column in worksheet
- Able to change cell format
METHODOLOGY
- This course will be conducted with lectures, PowerPoint Presentation, demonstration on lab, and practical exercise.