Day I 

Pragmatic Excel Training on Actual HR Examples in Human Resources
20 Different Examples of Human Resources and Excel Applications
Functions Used in Monthly Human Resources Reporting Samples
Pulling Reports from Human Resources Related Data to Excel via SQL
Extracting Data from a Data Table with Multiple Criteria Using Database Functions:
Dsum, Dget, Daverage Formulas
Time Formulas and Their Use in Human Resources
Reference Formulas: Vlookup, Hlookup, (Vhlookup), Index, Hyperlink
Formulas to Save Time in Personnel Tables
Concise and Easy to Understand Human Resources Management Reporting Examples with Conditional Formatting (Function Based Wage Increase Reporting)
Protect, Encrypt and Track Changes to the Working Document
Removeduplicates Sort Duplicate Data
Sparklines (Mini Graphics in a Cell)
A Sample Visual Basic Macro Application Ready to Use for Human Resources
(Human Resources Macro Examples for Attendance Reporting and Vacancy Analysis)
Making Sense of Information in Large and Complex Human Resources Data Tables
Reporting Demographic Data and Using Infographics
Examples of the Most Common Excel Calculation Mistakes in HR from Different Companies
The Most Common Staff Personnel Excel Table Errors in HR
Human Resources Information Systems Excel Examples
Laying the Groundwork for Strategy and Excel

Day II 

Human Resources Information Systems (HRIS), Excel and Reporting

Analytics 1.0, 2.0 and 3.0

Big Data Concept and Its Use in Human Resources

Human Resources and Measurement

"What" Should We Measure as Human Resources?

Reporting the Human Resources Budget in Excel and Measuring Budget-to-Factual Ratios

How to Design a Monthly, Quarterly and Annual Human Resources Reporting Set for Strategic Decision Making Processes?

Turnover Rate Calculation Methods. Monthly, Annual Reporting and Data Mining

Retention Rate Measurement Study

Using Average Workdays For Leaver Analysis and Results in Management Presentations

Publishing Demographic Data as Human Resources and Using Infographics

Globak HR KPI set example and benchmark study

Time Saving Areas in Human Resources and Excel

Seniority Risk (ETB Rate) calculation in Excel and integration into Human Resources budget

HeadCount and Fte based Understaffing measurement case study

Can you earn 11 days a year with PowerPivot alone?

Mandatory Disabled Quota Report case study for Human Resources

Monthly Human Resources Report Drafts for all company HRs

HR Excel application example to facilitate finance and HR reconciliations