Automate HR Dashboard & Reporting with Excel

Webinar Outline:

An HR dashboard is a dynamic overview of the most important HR metrics in one place. 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. The course is designed to deliver fully automated reports and dashboards that will enable you to enhance productivity in the organization.

Key Learnings:
1. Understanding Dashboard Architecture & Required Excel Tools for a Dashboard
2. Understand proper Data Set to develop highly effective reports
3. Learn the Essentials of Power Query to Automate Report
4. Discover highly productive ways of presenting Data with PivotTable and Custom Data Table
5. Learn Effective Visualization Techniques in Excel
6. Prepare Animated Dashboard on Real Life Case
7. Learn Data Storytelling Techniques for Dashboards

Note:

• All participants will get a digital certificate from Thriving Skills Limited.
• Must set up your first name, last name, and display name from settings of your profile for your certificate.
• Don’t click on the “FINISH COURSE” button.
• If you click on the “FINISH COURSE” button then the webinar will be finished and a Certificate will be generated.

Webinar Instructor:

Md. Mehanazuddin Rupom

Course and Training of this Instructor:

• Business Reporting with PivotTables
• Advance Excel Functions & Tools
• HR Analytics & Dashboard with Excel
• Tips & Tricks of Modern Dashboard
• Bring Data to Life Excel Dashboard
• Use Excel Like a Pro!
• PivotTable Basic to Pro
• Increase Office Productivity with MS Excel Lookup Series
• Power up Excel Report with Power Pivot & Power Query
• HR Analysis & Dashboard with Excel
• Essentials of Excel Business Intelligence Tool