Course Outline
- Design a database for employees demographics
- Analyze employee demographics
- Manage Employment Status and records
- Apply complex formulas specific for HR managers
- How to apply date and time functions to calculate working hours and attendance
- Transform HR survey into database
- Analyze HR surveys using statistical techniques
- Advanced visualizations for findings and recommendations
- Apply advanced conditional formatting for automatic follow ups
- Design Timetable and roaster for employees
- How to protect confidential data with personalized permissions to executives
- How to compliance other departments to follow HR database pattern
- Analyze employees and departmental performances
- How to calculate bonus, salary
- Design a HR survey
- Pareto analysis on employees feedbacks
- Combine data from different departments
- Automate daily routine activities through Power Query function in Excel