Collaborate on Create Invoice in Word from Excel Data for Human Resources with Ease Using airSlate SignNow

Create invoice in word from excel data for Human Resources

hi and in today's tutorial i'm going to show you how to create this invoice in word so i'm just going to open a new document and i'm going to create this with the help of tables which makes everything really really simple and adjustable so let's go up to the insert tab go to table click on the drop down and go down to insert table i'm going to choose four columns and 20 rows and click ok now my rows are quite narrow at the moment so i'm going to increase the height of them and the way to do that is to select the whole of the table by clicking on this square at the top left or you can simply click and drag across all the cells go up to the layout tab go up to height here and you can adjust this value here you can either use this up and down arrow or you can simply enter in a value if i enter one you can see it doesn't quite stretch out to the end of my document so i'm going to choose 1.2 and you can see i've created an additional page i want to get rid of that so what i'm going to do is go down to my rulers here if you can't see your rulers go to view and click on this ruler icon here and just check this box go down to the bottom here hover your cursor between the white and gray section click a line will appear and you just drag that down to the end there perfect the first thing we're going to do is to insert our logo but what we don't need to do is adjust the size of these cells what we're going to do is to merge them so we're going to create a space around this big so just going to click and drag across those cells and then i'm going to go up to table layout and then across this icon that says merge cells as you can see we've merged that cell into one and then we're going to insert our logo so go to insert pictures picture from file i'm going to go to my desktop and select my logo and click insert now your logo can sometimes be a bit clunky to move around so all you need to do is select it make sure you're on picture format go to wrap text click on the drop down and select in front of text then you can move this anywhere in your document we're just going to move it over to the side here but we can come back later if we want to to adjust it now we're going to go over to this section here and we're going to input in all of our contact details so what i'm going to do is let's go back to the original and you can see i've got these grid lines round here and i'll show you how to do that shortly we're going to insert all these contact details so what i've done is i've merged the cells here and i've also merged the cells here but i've moved this in this line in between here so let's show you how to do that so what we're going to do is select these four cells here go up to layout select merge select these four cells here select merge then select these two cells here because we only want to affect this line here we don't want to affect the rest of the line going down the table hover your cursor over the middle till it changes and then just drag that over to the side so let's go back to the original and all i'm going to do is select this text and copy and paste it but you can put obviously your own text in here this one just needs to move over to the other side so if we just select all of that text and in the layout tab you can go over to this section here and this will allow you to select exactly where you want your text to be placed within your cell so i want mine aligned to the center right and you can see as soon as i click that it aligns it to the center right and this really is the advantage of using a table because you can use these alignment tools to align all the text up where exactly where you want it the next thing is to place in my icons so i'm going to go to insert and icons for you this might be clip art and in the search bar here i'm going to type phone and then i'm going to select this one here click on it and go down and select and again we need to ensure that we can move this round correctly so select it right click go down to wrap text and select in front of text and that means you can move it anywhere in your document now this is obviously a little bit big at the moment so select it go to graphics format go along to height i'm going to select one and press enter and it will automatically adjust the other one just move that over next i'm going to go back over to my search bar in my icons and i'm going to type in a website i'm going to select this image here click insert again do exactly the same right click go down to wrap text and select in front of text that will allow you again to move it around any way you like again go up to graphics format along to height select one centimeter press enter and then move it down we will align all of these up so just put it roughly where you need it once again i'm going to go over to the search bar and type in location i'm going to select this like on here select insert right click wrap text in front of text go to graphics format height one centimeter press enter and move that down now once you've got them roughly in the right place you can use your arrow keys or you can use your mouse to adjust the location what we're going to do is select them all so hold down your command or control key on your keyboard and click on all of the different icons and then in the graphics format tab go along to this align tool click on the drop down and select distribute vertically and that will mean there's an equal distance between each of the icons then select group click on the drop down and select group and this will mean that you can move them anywhere as one unit and then you can pretty much line them up with the various bits of text now you can see there are all these lines in between here and this is a process that you'll very quickly get used to eliminating those border lines and putting them back in so i want to get rid of all the border lines around this section here so i'm going to select these two cells i'm going to go to table design and along to this section here and this is where you can color your borders take them out put them in make them thicker there's all these adjustments that you can make so i'm going to go to borders here and i'm just going to select no borders and as you can see all the borders have been taken out but the cells still remain now the easy solution to viewing those cells is to go down to view grid lines if you go to view grid lines you get these dotted lines that slightly gray and what that means is it shows you where the cells are but there are no border lines on those cells so it's just like a guide really to show you where your cells are so i'm going to keep that selected for now but you can keep checking it off when you want to see your completed invoice i'm also going to take out these borders on this cell here so i'm just going to click in it and i've already got no borders selected here so i'm just going to click on that i'm also going to take out this one here click no borders and then if i just go back and take that off you can see where you are at the moment with those border lines put them back on and now i'm going to merge these cells here because i'm going to put in the address bar if we go back to the original you can see i just want to put the address in here so i'm going to select those cells and i'm going to actually merge these cells so go up to layout and merge then i'm going to go back to the original i'm just going to select my text i'm going to copy it and then i'm simply going to paste now obviously you'll have your own text in here with your clients information and their details so just pop that in there and then i'm going to get rid of that borderline as well so up to table design and click no borders and then just just have a look at that without the grid lines perfect so again the next element i need to take out are these lines so again select those cells go to table design along to borders no borders so next we can start with the main table if you go back to the original we can start with this section here so i'm going to go up to boards and put those grid lines back on and i'm just going to type in that text now to customize this i'm going to change the position of the text the color of the text and the color of the cells so i'm going to select this top row here i'm going to go to layout and i'm going to put that text right in the middle of my cell then i'm going to go to table design i'm going to go to this shading icon and this is the one that you select to change the color of the cells of your table so if i click this color here you can see it's changed the color of my cells now the black doesn't work very well on this color i don't think so i'm going to change this text color to white so i've selected it all go to the home tab and go along to the font color icon click on the drop down and select the color of your choice then we can input all the information that we want so if we go back to the original we can see here that we've we've got one two three four lines of information so if we go back over here so to the main body of the text you can keep the height of these cells as you wish but i've actually merged them to make the heights of these cells wider so all i'm going to do is i'm going to merge these two cells go to the layout tab select merge cells continue to do that for four rows now for these four rows i'm just going to move this central line over so i need to create a little bit more space for my description let's just select the whole of these two rows and then grab that central line and then let's just move that over now obviously you can see how we've squashed this one here and we want these three columns to be exactly the same width so all we're going to do is select these three and then we're going to go up to layout and then distribute columns and that will distribute them equally makes them look perfect now i'm just going to steal the text okay so this is where you would put all the description about the charges that you're giving to your client whether that's a service or a product so once you've put the information in then we can line all of these up so i don't want the text to be at the top left i'm going to select it all go to layout and i want it over here so this is the center but to the left click on that and that's put that beautifully in my cells as i want next i'm going to put all my units in so again i'm going to go and steal this text here copy it and then paste it over now once again you can see it's not lined up in the center of my cells so i'm just going to select it all go to layout and then i'm going to put it right in the center here and this is just simple text that i've typed into my cells once i've done that i want to get rid of all of the cell borders here so i'm going to select in fact i'm going to select all of this here so i'm going to get rid of this at the top as well and just remember that when you want to get rid of a cell border you have to select the cell or the surrounding cells and sometimes it will take out borders that you don't want it to take out you can go back in and put them in afterwards so i'm going to select all of this go to layout sorry go to table design go to borders and select no borders and then up here i'm going to get rid of this line that runs down the side here so select it all go to borders click on the drop down and i'm going to select left border and that will get rid of that left border if we take off the grid lines you can see where we are so far you can see we've got a line here that i don't want so click in that cell go to borders select no borders and it will take out that line at the bottom there and so far so good so now we're going to do the total at the bottom so i'm going to select it all i'm going to go up to table design go to the shading and pick another color and then i'm going to type in total and then the final amount and then again i'm going to adjust my text so i'm going to select these two cells i'm going to go up to layout and i want them in the center of my cells i'm going to change the color again of the text so go to the home tab and select font color it's already set to white then i'm just going to select the total and make that bigger so i'm going to select that text go up to the home tab i'm going to go to this increase font size icon so i'm just going to keep clicking on that until it's the right size so i think that's absolutely fine then i'm going to go along get rid of the border lines so select all the cells go to table design select no borders and then we're going to put in the payment details at the bottom here so we just go back got one two three four cells there we've only got three here so we've made a slightly different adjustment to our table than the original but that's absolutely fine what we can do is we can select the top row here we can go to table layout we can go to split cells and then we can choose number of columns is eight we only want four and the number of rows is two so we want to split that row in half click ok and then you can see the adjustment we've made here so all we need to do is move this line over to this one move this line over and then move this line over so you can see now it's exactly the same if you want all of these cell heights to be the same select them all and then go to layout and then distribute rows now i can adjust where my text lies in my cells so again go up to layout and i want them to lie align to center left then i'm going to choose my text again this will all be down to your personal preference and then we're just going to adjust this middle line here we're going to bring that over like that don't forget only select the cells where you want this line to be affected and then just put in the details and then i'm just going to merge this cell here because i want to make this text a little bit bigger so i'm going to select them both go up to layout select merge cells and then stay on this cell i'm going to go to home and then increase the size of that text there now finally i want to get rid of all of the cell borders so select it all go to table design borders and click no borders okay so the only thing for me here is there is not enough space between this section here and this payments text here so i'm going to go up to my borders and i'm going to go to view gridlines what i want to do is maybe put a new row between payments and this blue line so we need to create some additional space so the first thing i'm going to need to do is move everything up and it's really easy to do that go over to your margin ruler over the side here again click between the gray and white section and just pull it up then i'm going to add a row above so i click in payments then i go to layout and then you can see this section here i've got insert above below left and right so i want to insert one above so just click insert above and now you can see we've got an additional space so if i take the grid lines off again go to borders a few grid lines you can see now i've got a much nicer and cleaner space between that blue shading and payments now if you want to make this into a template then just make sure you haven't filled in any of the details in the middle because obviously that's something you'll need to adjust time and time again but all you need to do is to go up to file save as template make sure your file format is microsoft word template and ensure you're in this templates file here name it whatever you like and then just click save and what that will mean is once you've saved that into your templates then you can use it time and time again and even when you put all the information and you save it you'll automatically be saving it as a brand new document so i hope that's helped you today if it has please subscribe and have a great day