KPI Based HR Dashboard with MS Excel

User Avatar
Md. Mehanazuddin Rupom

Please fill following information

KPI-Based-HR-Dashboard_August

Dashboard presents a synopsis of the performance that helps to take the right initiative. HR dashboard brings in the Key HR Metrics at one page so that the HR function can take the right initiative to expedite positive business performance. The HR dashboard provides a slice-and-dice overview of the workforce, their performance, absence, and turnover. It is key for strategic decision making in HR. The dashboard is used as the most powerful decision-making tool globally. Visualize, Track, Analyze, and make the Perfect Decision for your business.

Training Outline:

  1. Importance of KPIs 2.
  2. Learn Key HR Metrics 3.
  3. Most effective Excel Functions to derive HR KPIs 4.
  4. Generate Multiple HR Reports from a Single Table in no time! 5.
  5. Advance Data Visualization Techniques for Dashboard 6.
  6. Add the right animation to the Dashboard with VBA 7.
  7. Dashboard Best practices 8. Project: HR KPI Dashboard

Course Information

  • Reg. Ends 13 August, 2020
  • Start Date 14 August, 2020
  • End Date 15 August, 2020
  • Total Hours 4 Hours
  • Venue Title Online Live Training
author avatar
Md. Mehanazuddin Rupom

Microsoft Certified Excel Trainer

Md. Mehanazuddin Rupom is a seasoned HR Professional who possesses expertise of handling both local and international HR Projects in his 10+ years of professional journey. He is also Microsoft Certified Trainer, Microsoft Office Specialist – Excel Expert and Certified Microsoft Innovative Educator.

He currently leads the HR & Administration functions of Bangladesh unit for one of the top multinational international sewing thread dyeing & finishing company named AMANN Group headquartered in Germany. He joined AMANN in August 2015 and then on contributed significantly to develop a sustainable business for AMANN in Bangladesh with the management of HR & Admin activities. For his outstanding contribution for setting up the HR & Admin functions in Bangladesh, company has awarded him with the responsibilities of New HR Projects in Asia and also made the Employee Engagement Survey Project Lead – Asia back in 2018. Prior to AMANN, Rupom worked in a HRBP Role for Manufacturing Team of Lafarge Surma Cement Limited that was a French Multinational Cement Manufacturing Company. He was also key member of Lafarge’s Asian Technical Development Team. Before Lafarge, he was with one of the biggest LLC’s in Bangladesh named Beximco Pharma. He started his HR career for this company back in 2011. However, he stepped into the professional world with British American Tobacco back in 2010 when he was recruited in there Trade Marketing & Distribution – TM&D team.

Apart from his professional commitment, he also conducts training on Microsoft Excel & PowerPoint in both online & offline form 2012. He has also established himself as a key profile internationally in the field of Microsoft Excel. He also conducted several trainings on HR & Management Skills topics in the organizations where he had worked. His key interest areas in this trades are Team Building, Communication Skills, Business Etiquettes, Talent Management, Performance Management, Training & Development and Organization Development.

During the Corona Pandemic that has started to expand from April 2020 in Bangladesh till now, he has conducted 50+ webinars in Excel with over 2,500 students from around the world.

Book Your Seat

    Book Your Seat

    Please fill following information

    You May Like

    Message modal