Manual file processing could be a cause of your organization losing money and your staff members losing interest in their commitments. The simplest way to increase all company processes and enhance your stats would be to manage everything with cutting-edge software like DocHub. Deal with your documents and Save Employee Reference Request in Excel in a matter of seconds and save more time for pertinent tasks.
With DocHub, you have unrestricted access to your documents and Templates available to you at any moment. Discover all capabilities right now with the free of charge DocHub profile.
in this video well be looking for cell reference different types of cell reference like say relative reference absolute reference and some more advanced mixed reference lets see that I am on the sheet lets say relative reference I have some data lets say month the total income total expense and the net income I can get a net income which I subtract expenses from the total revenue how do I do that its a very simple formula equal to Ill subtract cell number b3 - cell number c3 NL press Enter now when I press ENTER if I drag down all the cells the formula will be copied like this and if I just double click on any cell what is happening is it has taken the relative reference what it was done previously it has subtracted the b3 cell number from C b3 minus c3 similarly they have done as b8 - e 8 if you see here also b7 - c7 be 6 - c6 so as you go in the horizontal or vertical manner the formula gets copied accordingly so that is what is called relative reference but now lets see Ill