Collaborate on Cash Bill Template Excel for R&D with Ease Using airSlate SignNow

Cash bill template excel for R&D

this guide shows you how to create a simple income and expenditure spreadsheet to keep track of your finances in Excel first of all you need to open Excel and then open a blank workbook then we need to create some headings so move your mouse over the cell a1 just here and left click once and we'll type in their dates then we might want to just move the cell over a bit to give us a bit more room so just move your mouse between a and B and left-click once and hopefully if you've got your mouse in the right position it should turn into a double-headed arrow like shown on the screen so when you've got it in the right position hold your left mouse button down and drag it slightly to the right there we go okay now we need to left-click into the B one cell and we want to type in their description okay and same again we need to move the the cell all of the column out a little bit to give us room to type some things in the description column so move your mouse between B and C left-click once the mouse should turn into a double-headed arrow and hold your finger down on the left mouse button drag it towards the right and drag a fairway to give us some space to type some things in the description column so move your mouse into the C one cell left click once and we're putting the money in okay and then we just move that out a little bit so again move your mouse between C and D left-click once and then once you've got your double headed arrow hold your finger down the left mouse button and just drag it out a little bit that's it there and then we left-click into D one and we type running count and then once again we just want to move this out a bit so move your mouse between DNA left click once you should have a double-headed arrow hold the left mouse button down and drag it out to the right a little bit like so doesn't matter if it's not perfect the next thing we need to do now is type in some data for instance let's type in the date so it's just typing don't here and then in description let's just call that starting balance and in money in will per our starting balance on their sales don't balance in 1395 that's great now what we need to do is we need to start typing in our income and expenses let's say right ok on the 2nd of December 2018 a gas bill of this will be the money out column of 50 site and on the 4th of the 12th 12 2018 I had oh sorry oh for 1 to 2 Oh 1.8 wants to it wants to for some reason his field actually put the the actual game but doesn't matter okay we can sort the hair in a second right okay so I got water bearing and so water bill and that was 35 in there and then perhaps on the 5th of December I got paid that would be money in so say I got paid 1,200 now what we need to do now is we need to create some total fields at the bottom here so I'm just gonna type in the left here in in cell a7 total and we're gonna type a formula into this which will basically add up everything that's in this column here follow this this formula we left click once into the cell c7 I will type equals and in capitals the word sum then open brackets and we type in direct Open bracket again switch mark and it's column C and we're starting at two so we type C 2 : C and those are capitals speech marks the band sign and then row in capitals open bracket close bracket -1 close bracket close bracket so there you go that's the formula we need to put in now if you're an expert with Excel you might be thinking well why don't you just do a simple two former formula C 2 to code on c5 which would just add up there well basically if we want to add more rows later on this formula here takes into consideration any rows that we've added and and recalculates for us let's just do that so there we go that's give us a calculation here and the next thing we need to do is we need to calculate these are add up these sales just here for the money out so once again we left click into d7 and type equals capitals sum then open brackets and capitals in diuretics open brackets speech mark d2 that's a capital D : d speech marks and sine row in capitals open bracket close bracket -1 close bracket close bracket and then press Enter or return on the keyboard Omega that's now totaled up the money outcome as I say this does mean that if we add rows later on it will still calculate the money and the money out and take into consideration any new rows we've added if we didn't do it that way then we'd have to reject this sum every time that's the reason for that what we want over here is we want a balanced field so if we just balance there and then click into g7 and what we want to do is we want to type a formula and again so equals in capitals type some open brackets c7 - d7 close brackets and then press Enter or return on the keyboard and there we go that gives us a total subtracting 85 from two thousand and two thousand five hundred and ninety five I'm just gonna correct this date here where it says for Dec so to do that if your starts playing up like this we just right-click on the the troublesome field go down to format cells and we want to click date okay and then click OK and there you go that's a brought it back so okay so let's just finish fulfilling this 1/2 so ok that was no YG's going in there and we were at another column because we've run out of room to add more things so all we do is we left click the number 6 there okay and then right click and then left click insert so on the 6th of the 12th 2018 I had a phone bill I'm bill and that was twenty four fifty there you go as you can see here that's added the 24 52 the the money out column and it's also deducted it from our balance there so we can see how much we've got left we can keep going like that we can keep like right left clicking on the on the empty row at the bottom above total and right click and then go insert and we can type they've got seven for the 12 mm 18 and perhaps I bought some birthday money that was a money in so say I got 85 in birthday money and there you go that side of the total up there and adjusted the balance as well there you go and then if you want to save it just go up to file save as and you can choose where you save you I mean most of the time you want to save it in documents it'll ask you to give it a name let's call that expenses December 2018 and hit save us off I've chose to save it in documents so I click Save remember that and if we want to load that back up again I can click on the yellow folder down here or if I'm got yellow folder down here click on the start button and click this folder here and then we click on documents on the left hand side and there we go we've got expenses December 2018 I'll just double click that ill open up Excel and they don't yell open up our expenses so there you go that's just a quick slapdash way of doing an income and expenditure spreadsheet in Excel hope this guide helps thanks for watching don't forget to check out my other videos in my youtube channel just Google Chris wait YouTube and don't forget to Like and subscribe to my youtube channel thank you for your support