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

*red highlight indicates mandatory fields

Country(+)
Area Code
Phone Number

For further information on our privacy and cookies policies, click here.
Advanced Excel Skills & Dashboards for Compensation Professionals (Online Programmes) - Informa Connect Middle East
Home > Online Programmes > HR > Advanced Excel Skills & Dashboards for Compensation Professionals (Online Programmes)
2For1 Offer
Advanced Excel Skills & Dashboards for Compensation Professionals (Online Programmes) Training Course | HR Training Course

Advanced Excel Skills & Dashboards for Compensation Professionals (Online Programmes)

28 March - 10 April 2021
Online Programmes

Level: Advanced

In-Company Training   REGISTER FOR THE COURSE  

Course Director

Dianne Auld | Course Director

Dianne Auld


Course Schedule
  • 28 Mar 2021 Online

Overview

An advanced-level live streaming online 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

VL172
Advanced Excel Skills & Dashboards for Compensation Professionals (Online Programmes)