
- This event has passed.
MS Excel Boot Camp for the HR Professional
June 13, 2020 @ 10:00 am - 3:00 pm UTC+8
Free
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 MS 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
Module 3 – Advanced Formula and Functions
- VLOOKUP, HLOOKUP and XLOOKUP
- Nested Formula
- 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