This includes: VLOOKUP (Birthday and Age) and CONCATENATE

Note: Imagine to explore data entry with more than 10,000 Employee information.

A sample work of a step by step Vlookup from some Data entries in HRIS:

In this area- I used to Vlookup some of the information with the Human Resource Information System wherein I need to add or see what's the Birthday of the employee.

A sample work of a step by step Vlookup from some Data entries in HRIS:

In this area- Thru this proper formula, i was able to perform and add their birthdays of each employee.

A sample work of a step by step Vlookup from some Data entries in HRIS:

In this area- With the same instructions, I was able to perform the formula to add some Age.

A sample work of a step by step Vlookup from some Data entries in HRIS:

In this area- Thru this proper formula, i was able to perform and add their Age of each employee.

CONCATENATE:

I know also how to formulate concatenate in order to Merge Last name, First name and Middle name:

By using this proper formula, i was able to perform it.

Once being Merged of names;

Just drag down the small dot below the merged name to the lowest employee in order to fill up all the information or just double click.

Thank you !

now,

Can't wait  to rock also some of your DATA's.

Hire me!