MS Excel Boot Camp for HR Professionals

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