Excel for personnel work

HR management requirements

• Secure handling of personnel and payroll data.
• Import, transform, link and summarize data from different sources.
• Use formulas and functions for calculations of all kinds.
• Support decision-making with meaningful key figures.
• Reporting and presenting.
• Automate processes with VBA macros.

Import, prepare and link data

• Data import from a wide variety of sources according to the ETL principle (Extract, Transform, Load) with Power Query.
• Large amounts of data and complex calculations with Power Pivot and DAX functions.
• Linking databases, time management and pay systems, CSV and text files in the data model, transforming, converting and cleansing data.

Fast and flexible data analysis with PivotTables and PivotCharts

• Ad-hoc reporting on complex issues.
• Distribution and frequency analyses.
• Visualize figures, present them clearly and informatively with pivot charts.

Practical examples from A-Z

• Calculate age structure, attendance management, working time and flexitime overview, payroll accounting, import external data, public holidays per federal state, fluctuation, calendar week, key figures in human resources, wages and working hours accounting, import and evaluate SAP data, statistics on additions/departures, timetables, appointment calendar, vacation plan, remuneration tables, Word serial letter.

Practical tips

• Data exchange with other applications.
• Task solution through considered list management.
• Increase the informative value and clarity of complex tables.
• Traffic light functions with conditional formatting.
• Context-dependent formatting.
• Keyboard and mouse secrets for more efficiency.