HRDF Claimable under SBL-khas
[01] OBJECTIVES
Participants will be benefit by being able to:
⮚Using multiple worksheets, workbooks and workspaces
⮚Working in Financial functions
⮚Use advanced formatting techniques
⮚Using the Auditing Tools to track information
⮚Using charts to display financial data
⮚Use templates
[02] COURSE CONTENTS
Charting Data
– Creating sparklines inserting Charts
– Inserting PivotTables PivotCharts
– Using slicers creating timeline
Inserting Art and Objects
– Inserting SmartArt Text boxes
– Inserting pictures, equations
– Drawing shapes
Advanced Formula Tasks
– Understanding relative and absolute cell references
– Using multiple cell references
– Using 3 D references Array formula
Using Advanced Functions
– Using the PMT FV Function
– Using VLOOKUP HLOOKUP Functions
– Using IF, AND, OR Functions
Outlining and Grouping Data
– Outlining grouping data
– Creating subtotals
– Removing outlining grouping
[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)
