Excel for Human Resources

Excel is used to solve many challenges, and among other things it can also serve as a human resources management software. You will find out how to link an employee to a Personnel Data in Excel, and how to easily search them. Many of you who read my blog loved Serbian TV series “Military Academy”. In this “recipe” I used data on several actors from this series (except for names and photos, most of it is fictitious).

CRM

CRM (Customer Relationship Management) represents the concept of managing relationships with potential and existing clients, customers or consumers (depending on what and to whom we sell). Its task is to obtain new and retain existing clients. Although there are plenty of software that very well support the CRM concept, when you are a beginner in business you do not need anything more than Excel.

Calendar

There are several ways to create Excel calendar. Also there are multiple templates that you can use for that purpose. The goal of this „recipe“ is helping you to understand practical application of some important date&time functions, and creating a calendar is an ideal opportunity to do so. When you learn how to generate dates and positions they should fit in you can use calendar for planning activities or tracking project realization.

Searching the ranges

The search of data ranges is most often done with the help of LOOKUP functions, where we enter the  criteria value, the search range (table) and the column containing the result values. After entering the formula, Excel finds and displays the requested value. There are several more ways to search the ranges when it is done relative to their position, which will be discussed more in the text that follows …

Randomly generated data

What is the most common problem for programmers and report makers? Certainly, it is a lack of adequate information they need to launch the report and see if it works. Data can be entered manually. But hey: imagine yourself to manually enter 100,000 records!?! This article demonstrates simple techniques to create tables with data to test the most demanding reports.