Introduction

Microsoft Excel is a spreadsheet program used to record and analyse numerical and statistical data. It is a powerful tool that can help organise, calculate, analyse, revise, update, and present data much easier. This course will provide participants with the knowledge to utilise various basic functions within Microsoft Excel such as creating charts, entering and deleting data, basic formulas and so on. This course is very suitable for participants who have zero knowledge on Microsoft Excel.

Learning Outcome

At the end of the program, participants will be able to:

• Understand the use of a spreadsheet and its benefits.
• Utilise spreadsheet software in a day-to-day business environment effectively.
• Indicate the names and functions of the Excel interface components.
• Enter, edit, and format data and cells.
• Construct formulas, including the use of built-in functions, and relative and absolute references.
• Create and modify charts.
• Preview and print worksheets.

Duration

2 Days (13 hours)

Target Participant

• Division II (ES2)
• Division III (ES3)
• Division IV
• Division V

Language

English / Malay