
- This event has passed.
MS Excel Boot Camp for HR Professionals
February 22, 2020 @ 9:00 am - 6:00 pm UTC+8
Php6048
MS Excel is a must in any HR arsenal. It’s the easiest way to track projects, create and maintain databases, and even come up with reports.
Module 1 – Basics of EXCEL
- Understanding and Navigating the Toolbar
- Formatting Sheets, Cells and Values
- Managing Your Workbook and Your Worksheets
Module 2 – Basic Formula and Functions
- CONCATENATE
- SUM and SUMIF
- AVERAGE
- IF, AND, OR
- COUNT, COUNTA, COUNTIF
- MAX and MIN
- ROUND
Module 3 – Advanced Formula and Functions
- TRIM and IFERROR
- VLOOKUP and HLOOKUP
- INDEX and MATCH
- Nested Formula
- CHOOSE
- Circular References and Conditional Formatting
- Dropdown Menus
Module 4 – USING Pivot Table and Building Dashboards
- Uses of Pivot Table
- Building A Pivot Table
- Analyze and Design
- Building A Dynamic Dashboard using Pivot