|
EFFECTIVENESS AND OPTIMIZATION |
|
EXCEL HRM |
|
All Microsoft Excel tools on this page are available for one price. Read more on the page ”Conditions”. All tools can be used directly in Microsoft Excel. |
|
The tool calculates employees age groupings to determine upcoming challenges with recruitment, pension etc. |
|
Calculate employees age groupings |
|
The tool calculates employees seniority groupings to determine upcoming challenges with recruitment, resignations etc. |
|
calculate employees seniority groupings |
|
The tool calculates numbers of full weeks between two dates. The tool can be used to calculate numbers of weeks for maternity leave, planning etc. |
|
calculate numbers of full weeks between two dates |
|
The tool calculates the development in headcounts in a given period of time via employee hiring and resignation data. Purpose is to show development in headcounts in a given period of time via hiring and resignation data. |
|
Calculate number of Headcounts - reporting |
|
The tool can be used to calculate the notice period for salaried employees according to the Danish Salaried Employees Act and the date of resignation. The tool can be used for control and higher efficiency via merging to Word e.g. date for resignation etc. |
|
calculate the notice period |
|
The tool calculates the number of working days between two dates. The tool is used to calculate the number of working days between to dates minus vacation, holidays etc. |
|
calculate the number of working days between two dates |
|
List of products |
|
The tool calculate the number of years, months and days between two dates. The tool can be used to calculate seniority, jubilee, age etc. |
|
The tool edits initials into an e-mail address. The tool can be used to find contact data in large data quantities. |
|
edit initials into an e-mail address |
|
The tool edits text in format "First name, Surname" or "Surname, First name" in one cell to the format "Surname, First name" in another cell. The tool can be used to align data format when merging letters and working with many data etc. |
|
edit text in format First name, Surname or Surname, First name |
|
Calculate number of years, months and days between two dates |
|
The tool edits text in two cells, e.g. names, into one cell in the format "First name Surname". The tool can be used to align data format when merging letters and working with data etc. |
|
The tool edits text to text with the first letter in upper case and cleans unnecessary spaces in the sentence. The tool can be used to align data format when merging letters and working with data etc. |
|
edit text to text with the first letter in upper case etc. |
|
The tool edits text with format "Surname, First name" to "First name" and "Surname" in two cells. The tool can be used to align data format when merging letters and working with data etc. |
|
edit text, e.g. name, in one cell into two cells |
|
The tool matches data in one list with data in another list. The tool is used to return employee data as addresses, postal codes, salaries, absence etc. from one list to another list. |
|
return employee data as addresses, postal codes, salaries etc. |
|
edit text in two cells into one cell |
|
The tool is used to return one or more values on employees in a list to another list, where the employee appears only once. The tool is used to return values on e.g. absence, vacation etc., on employees in a list to another list where the employee appears only once. |
|
return one or more values in a list to another list added up |