Create an Excel Bill Sheet for HR Effortlessly

Excel bill sheet for HR

hi guys in this video you will learn how you can make a fully automatic salary slip easily in excel so first of all go to view tab and select page layout [Music] select column a and f and set the column width 0.45 this time you will select the column b c d e and set the column width 1.5 now leave the first row and merge second row from column b to column e here you can write your company's name same as it is merge the next row and write your company's address now let's adjust the font size of company name [Music] again leave one row and merge the next one and write salary sleep adjust font size make it bold and add thick bottom border enter here employees id employees name designation and month and year select all these add border and adjust the font size right here earnings and deductions merge these and adjust the phone [Music] under earnings write basic da hra ta and total addition [Music] now under deductions write provident fund esi loan tax and total deductions skip one row and write net salary and salary inwards select all add border and align in center merge the cells [Music] right here salary paid by cash or check align in center go to developer tab and insert check box and adjust it [Music] you can easily tick the box ingly merge the cells right here employ signature and director you can use underscore for underline now select this area add a thick border and fill white color [Music] select earnings and deductions cell and fill this color add some function to calculate total earnings and deductions for the net salary add equal select the total addition and minus total deductions to bring salary in words we'll use spell number function you won't get this function by default you can check my video how to get this function i'll put the link in description so now it's looking good as it's almost done you can fill manually details for each employee but as mentioned in videos title will make this salvi slip fully automatic as you can see i have this another sheet where i have sally details for employees i'll just link with salvi sleep so we do not need to add details manually first we'll make drop down list of employees id go to data tab click here and select list select the employee id list and hit the enter as you can see now we have a list where we can pick any employer id now we need to add x lookup function to get results associated with the employee id i have made a detailed video on how to use xlookup function you can check it out i'll put the link in description so we'll add x lookup then lookup value which is employee id then lookup array and return array as you can see we got the employee name so same as it is we'll add same formula to other cells as well [Music] [Music] [Music] [Music] [Music] once done select these cells and format cells and choose your currency [Music] now let's see if we change the employee id does it change the results so as you can see it's showing the results as required so this is how you can create a selfie slip easily if you have any questions do let me know in comment section i'll be happy to assist you and further thanks for watching this video see you in next video bye bye