MS Excel Boot Camp for the HR Professional

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