DESCRIPTION
This highly intensive 3-day hands-on training will demonstrate step-by-step, how to use the Advanced Tools and Functionalities in Excel to create a practical HR System that collects HR data from multiple sources, and automates consolidation for serious HR data analytics, reports and dashboards that will dramatically improve your HR work.
Each session focuses on saving-you-time techniques, advanced ways to automate tasks, exploring simple techniques used by Microsoft Excel Consultants for developing HR Models and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Microsoft Office “family” for even greater results.
If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop.
In this 3-day highly intensive and practical residential seminar you’ll learn how to:
- Develop an end of month HR Report set that comprehensively analyse HR metrics
- Apply techniques for creating faster HR analysis and reporting
- Develop powerful PivotTable reports that quickly analyse volumes of data, generate summary views, track key performance indicators and reveal patterns in your data
- Create powerful HR charts that highlight HR issues and help non-HR professionals to quickly visualize their data
- Automate all your routine reports
- Setup a powerful HR dashboard that highlight key HR metrics
- Apply time-saving techniques that’ll allow you to organize your data, analyse it and report faster with Microsoft Excel
Create a complete HR Data Management System to manage every HR data including employee records (including ID photos), budgets, training, etc. to make complex data analysis and reports a snap.
