HRDF Claimable under SBL-khas
[01] OBJECTIVES
Participants will be benefit by being able to:
⮚Manage, organize, filter and analyse large and complex datasets efficiently
⮚Apply advanced formulas and functions
⮚Create dynamic reports using PivotTables, PivotCharts and advanced reporting tools
⮚Understand basic VBA concepts and apply simple automation techniques in Excel workflows
[02] COURSE CONTENTS
Named Ranges & Formula Errors
– Understanding Named Ranges
– Tracing Formula Precedents and Dependents
– Running an Error Check
Sort and filter
– Understanding filter records
– Using sort data
Manage & Group Data
– Configuring data evaluation transpose data
– Creating subtotals
Work with scenarios & using solver
– Create edit scenarios
– Running solver
– Generate report scenarios with solver
– Modify constraints
Managing Data
– Enables Analysis ToolPak
– Using Data Analysis Tools, Goal Seek
Advanced PivotTable & PowerPivot
– Create PivotTable PivotChart
– Sort filter Pivoted Data
– Create PivotTable with PowerPivot Data
Using Macros
– Record, edit running a Macro
– Writing a Macro using the Visual Basic Editor
[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)
