HRDF Claimable under SBL-khas
[01] OBJECTIVES
Participants will be benefit by being able to:
⮚Identify basic worksheet and workbook concepts and terms
⮚Enter & edit data
⮚Modify the worksheet
⮚Use functions to calculate and return values
⮚Format cells to enhance the appearance of your worksheet
⮚Use drawing features and other enhancement
⮚Change the page set up to define how the printed worksheet appears
[02] COURSE CONTENTS
Basic of Microsoft Excel
– Creating managing workbooks
– Entering and deleting data
Working with Data
– Inserting, merging and splitting cells
– Using Paste Special, Find and Replace
– Move, hide unhide cells
Excel Tools Usage
– Understanding cell references and formula
– Using basic advanced functions
– Using timesaving tools
Formatting
– Formatting text
– Wrap text, cell alignment
– Using cell styles, formatting data as a table
– Insert page breaks adding background
Print, Sharing & Customizing
– Save share the workbook
– Customize quickbar access toolbar
– Resetting interface changes
[03] CERTIFICATION
– Certificate of Attendance
[04] TARGET GROUP
- Administrative Personnel
- Students
- Finance & Accounts Personnel
- Executives
- Anyone interests in learning Microsoft Excel
- *Maximum 25 pax per group
[04] METHODOLOGY
- Guided Demonstrations
- Real business case scenarios
- Hands-on
- Interactive Q&A
In-House training available in West Malaysia (Johor, Melaka, Ipoh, Penang, Kuantan, Pahang)
FOR MORE DETAIL, PLEASE CONTACT:
011-2665 1380
(Ms Ezatul)