Advanced Excel Skills & Dashboards for Compensation Professionals - Informa Connect Middle East
Contact for Queries: +971 4 407 2500 info-mea@informa.com
العربية
Select Page
×

Your Details

*red highlight indicates mandatory fields

Advanced Excel Skills & Dashboards for Compensation Professionals - Informa Connect Middle East
Home > Training > HR > Advanced Excel Skills & Dashboards for Compensation Professionals
Advanced Excel Skills & Dashboards for Compensation Professionals Training Course | HR Training Course

Advanced Excel Skills & Dashboards for Compensation Professionals

Course Director
Dianne Auld | Course Director
Dianne Auld


Education Partners

Overview

An advanced-level course helping you utilise advanced Excel formulas for your rewards work, understand the principles behind creating dashboards and create interactive formula-driven and pivot chart dashboards.

Who Should Attend

Compensation professionals who already have intermediate Excel skills, and would like to enhance their skills to improve their productivity in Excel and learn how to create interactive Excel models and dashboards for their rewards work. Delegates should use Excel for their day-to-day rewards work, be able to write a VLOOKUP formula and be familiar with pivots and charts.

Benefits of Attending

  • How to use Form Controls to set up scroll bars, spin buttons and combo boxes to make your data models and dashboards interactive with a professional touch
  • How to use the OFFSET, INDEX and CHOOSE formulas to count, sum and average rewards data for different periods based on user choice
  • How to use named ranges and the INDIRECT formula together with the VLOOKUP formula to increase productivity and reduce errors when working with rewards data
  • Understanding the logic of the IF formula
  • How to use IF formulas, IF (AND) and IF (OR) formulas, Nested IF formulas, COUNTIF, SUMIF, AVERAGIF, COUNTIFS, SUMIFS and VERAGIFS formulas for rewards work
  • How to set up data validation for forms, models or dashboards
  • How to protect the sheet and the workbook
  • Understand the principles of dashboard design
  • Create an interactive formula driven market comparison dashboard using formulas, conditional formatting, charts and the camera tool
  • Create a pivot chart HR statistics dashboard, using the pivot functionality to group data, and making the dashboard interactive with slicers

BC8648JO
Advanced Excel Skills & Dashboards for Compensation Professionals