Introduction

This course is for those with basic Excel skills and looking to enhance their knowledge in composing formulas and applying them to manipulate data. Participants will learn how to audit and correct their formulas. They will also learn to work with Excel functions from the date and time, text, statistics, and lookup and work with many worksheets, large worksheets, and print worksheets. Additionally, it allows data to be imported from other software, analyse data tables and use pivot tables to make a summary of information. However, many do not know that MS Excel can be a powerful analytical tool in assisting decision-makers to come to an informed result.

Learning Outcome

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

• Create formulas.
• Correct formula errors.
• Apply advanced Excel Functions such as Conditional Formatting.
• Create effective spreadsheets – Work with many worksheets- and large worksheets.
• Create more advanced charts and pivot table.
• Use an electronic spreadsheet to make useful alternatives to support in making decisions.
• Interpret raw data into useful data for decision-makers.

Duration

2 Days (13 hours)

Target Participant

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

Language

English / Malay

Pre-Requisite

Basic knowledge of Microsoft Excel